Minimize (not hide) Parameters

Hello,

I am wondering if RS has the capability to minimize the parameter portion on the top. I see that parameter can be hidden, but I would need the capability to just minimize and if the user needs to change the parameter, they can still click on a button to un-minimize.

Does that make sense?

-Lawrence

If by RS you mean the Report Manager, the toolbar cannot be customized. If you are report-enabling a custom application the ReportViewer controls support customizing the toolbar.

|||

If you are accessing your reports over the web, then if you use URL access to the report server you have the capability of launching a report with the parameters area collapsed. You do this by adding rcarameters=collapsed to the URL query string.

So your URL might look like:

http://localhost/reportserver/?%2freport+directory%2freport+name&rs:Command=Render&rcarameters=collapsed

|||

This is exactly what I was looking for.

Thanks a bunch!

Minimize (not hide) Parameters

Hello,

I am wondering if RS has the capability to minimize the parameter portion on the top. I see that parameter can be hidden, but I would need the capability to just minimize and if the user needs to change the parameter, they can still click on a button to un-minimize.

Does that make sense?

-Lawrence

If by RS you mean the Report Manager, the toolbar cannot be customized. If you are report-enabling a custom application the ReportViewer controls support customizing the toolbar.

|||

If you are accessing your reports over the web, then if you use URL access to the report server you have the capability of launching a report with the parameters area collapsed. You do this by adding rcarameters=collapsed to the URL query string.

So your URL might look like:

http://localhost/reportserver/?%2freport+directory%2freport+name&rs:Command=Render&rcarameters=collapsed

|||

This is exactly what I was looking for.

Thanks a bunch!

Miltivalue Parameters with Max Pool connections

I am trying to write a report with many different records needed (way the database was designed). Client will need multivalue parameter and I have reached max pool connections(can anyone please give me the number).

Normally I would handle this with a stored procedure to create a temp table with the needed information for each section(one row per section), but this will not work with the multivalued parameters(more than one in this report).

Any help on this issue would be appreciated.

Thanks!

Terry

I'm not sure I understand the issue why you are running out of connections, but if all datasets are based on the same data source, you could select the "Use Single Transaction" checkbox on the data source dialog. In that case, all datasets running against that data source will use the same connection. See also: http://msdn2.microsoft.com/en-us/library/ms181198.aspx

-- Robert

|||

I have found the data source, but not the single transaction area. Any help in this area would be appreciated. Will have to solve the multivalue parameter issue later. Idea without multivalue parameter would be a stored procedure to fix this.

Have one other idea with @.t table useage.

Thanks for the information.

Terry

|||

The "Use single transaction" checkbox is only available in report designer. You cannot change this setting once the report is published.

-- Robert

|||

That answered the question. I will have to find it at the start of the development for a new system.

Thanks!

Terry