Hi,
SQL Server Reporting Services 2005.
I have 13 parameters, ordered correctly within the Report Parameter screen.
When displayed in the Preview tab they are all ordered correctly, but when viewed in the application the first 4 are at the top but ordered incorrectly. The remainder are ordered correctly.
I have tried reordering, saving, deploying, viewing and then doing the same but in the correct order without any success.
Please can someone suggest how I can get the parameters to appear in the correct order within the application?
Thanking you,
dwemh
dwemh
Do you mean the alignment of report parameters within ReportViewer
control parameters area? If so, may be custom control for parameters
setting is worth developing. As I know, GetReportParameters() web method returns parameter collection, saving original order.
|||
The parameters are displayed in the order they appear on the report parameters page in the report designer tool. If you have previously published the report, you may need to delete it and replublish for any order changes to be reflected on the server.
Other than that, parameters are always layed out left to right, top to bottom by default (this adapts to your globalization settings). If that doesn't meet you needs, you'll need to follow Anatoly's advice and provide a custom application to display them how you want them.
-Lukasz
|||Well. this bring me closer to a question I had since days.. Can we have more than 2 parameters displayed in a single row on report (when browsed ). The parameters by default - seems to be lined up in an array of 2 columns, ad N rows - which is frustrating because so much of space is left blank (space just left of <View Report> button.
How did you managed to get 4 parameters in one single row ?
Thanks for ideas.
|||Yup, can only have 2 columns in our UI and we don't expose a property to set the number of columns. I've added a design change request to our internal system to try to get this addressed.
Right now, the only way you can get more parameters is to build a custom UI.
-Lukasz
sql
No comments:
Post a Comment