Showing posts with label control. Show all posts
Showing posts with label control. Show all posts

Thursday, March 29, 2012

Dynamic Report Name at run time?

Hi Friends,

Is it possible to give a name at run time to a report when we try to download it in any format.

Do we have any control over the report name for e.g. the report name can be passed at parameter value.

Thanks,
Novin

Provide an example of the first five report names.

|||Hi,

I have created on single dynamic report name as "Generic Report" which will serve the need of 5 diff reports,

Where we go one by one report from the drill down from report no1 to 2 to 3 and....5 and all these 5 reports are generated using the single dynamic general report.

Problem is when ever at any report level i try to download the report its name remain the same as "Generic Report".

but I want the name to be parameteries based on the report level.

Hope you understood my probelm now.

Thanks

Novin

Dynamic Report Name at run time?

Hi Friends,

Is it possible to give a name at run time to a report when we try to download it in any format.

Do we have any control over the report name for e.g. the report name can be passed at parameter value.

Thanks,
Novin

Provide an example of the first five report names.

|||Hi,

I have created on single dynamic report name as "Generic Report" which will serve the need of 5 diff reports,

Where we go one by one report from the drill down from report no1 to 2 to 3 and....5 and all these 5 reports are generated using the single dynamic general report.

Problem is when ever at any report level i try to download the report its name remain the same as "Generic Report".

but I want the name to be parameteries based on the report level.

Hope you understood my probelm now.

Thanks

Novin

Friday, February 24, 2012

Dynamic Connection String

I've seen some threads here about Dynamic Data Sources.

I am using the ReportViewer Control for WebForms.

I simply want to say the following:

reportviewer fv = new Microsoft.Reporting.WebForms.ReportViewer();

rv.ServerReport.SetConnectionString(......);

I want to avoid using parameters to do this if I can. I've read that stored procedures don't work when you use parameters.

Is this possible?

Thanks

It sounds like you are using the ReportViewer control in LocalMode. In that case, your application has to directly provide the data as a dataset to the ReportViewer control. There is no connection string, because the ReportViewer control will never execute any queries in LocalMode. More information is available here: http://www.gotreportviewer.com/definedata/index.html and here: http://www.gotreportviewer.com/objectdatasources/index.html

If you use the ReportViewer control in ServerMode, it will just point to a report on a report server. That report is executed on the report server and could use an expression-based connection string, as discussed here: http://msdn2.microsoft.com/en-us/library/ms156450.aspx (scroll to the "Data Source expressions" section).

-- Robert