Reporting Services parameters not in correct order

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

Reporting Services on Windows 2003 Domain Controller FAILING

I have tried several times to install RS on two of our domain
controllers. I never get past the screen that installs the "Microsoft
SQL Server Reporting Services Setup Support Files". When I click
"Next" the screen dissapears and a event log is created that states:
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: 3/10/2005
Time: 12:30:20 PM
User: N/A
Computer: <<COMPUTERNAME>>
Description:
Faulting application setup.exe, version 0.0.0.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
When I look at the install log, the program dies on the following
function:
<Func Name='PerformDetections'>
0
That is the end of the log. Nothing follows. I am worried that a
GROUP POLICY is preventing me from continuing. Any ideas on what to
check? I have installed the RS on a 2003 test server that was not a
domain controller.
TIA,
Doug CrabtreeNevermind, found the answer:
http://support.microsoft.com/default.aspx?scid=kb;en-us;840219
Didn't seem to relate until we had another problem with authentication on
one of our databases. This solved it on both DCs.
Doug
>I have tried several times to install RS on two of our domain
> controllers. I never get past the screen that installs the "Microsoft
> SQL Server Reporting Services Setup Support Files". When I click
> "Next" the screen dissapears and a event log is created that states:
> Event Type: Error
> Event Source: Application Error
> Event Category: (100)
> Event ID: 1000
> Date: 3/10/2005
> Time: 12:30:20 PM
> User: N/A
> Computer: <<COMPUTERNAME>>
> Description:
> Faulting application setup.exe, version 0.0.0.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> When I look at the install log, the program dies on the following
> function:
> <Func Name='PerformDetections'>
> 0
> That is the end of the log. Nothing follows. I am worried that a
> GROUP POLICY is preventing me from continuing. Any ideas on what to
> check? I have installed the RS on a 2003 test server that was not a
> domain controller.
> TIA,
> Doug Crabtree
>sql