Passing parameter to URL - SSRS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Passing parameter to URL - SSRS

Author

Topic

mundo23
Starting Member

10 Posts

Posted - 2009-01-23 : 03:41:40

***THE ISSUE IS NOT NAVIGATING TO THE REPORT IN GENERAL, WHEN I CLICK THE LINK IT GOES TO THE CORRECT REPORT SERVER LOCATION. THE ISSUE IS THAT, ONCE THERE, THE PARAMETERS ARE NOT POPULATED AS THEY SHOULD BE.***

I have had a look at various posts regarding passing parameters to a URL and, as far as I can gather, I'm doing it right. However, when I click on the link I am taken to the report without any parameters populated.

The code in the navigation expression is as follows:

="http://194.155.100.187/Apollo-5_Reports/Pages/Report.aspx?ItemPath=%2fDevelopment%2fDavidN%2fNR1+-+Nil+Returns+Report&Directorate=" & Fields!directorate.Value &"&Category=" & Fields!category.Value &"&SubCategory=" & Fields!subcategory.Value &"&ContractHeader=" & Fields!contractheader.Value & "&MonthFrom="& Parameters!monthstart.Label &"&MonthTo=" & Parameters!monthend.Label

and this comes out as:

http://194.155.100.187/Apollo-5_Reports/Pages/Report.aspx?ItemPath=%2fDevelopment%2fDavidN%2fNR1+-+Nil+Returns+Report&Directorate=Agency,%20Professional%20Services,%20Facilities%20Management%20and%20Utilities&Category=Allied%20Health%20Professionals%20and%20Healthcare%20Science%20Services&SubCategory=Allied%20Health%20Professionals%20and%20Healthcare%20Science%20Services&ContractHeader=CM/AST/05/3546&MonthFrom=20084&MonthTo=20085

as an example.

All of the parameters match what would be selected if I just ran the report normally but none are selected when I jump to it.

I apologise for the bold warning at the top but I have had a number of replies advising me to point it at ReportServer or to use the Globals!ReportServerURL command but these do not answer the problem and I believe that people are not looking at the posts if they believe an answer has been given. I am solely concerned with the parameters not passing through - I have tested that they should be correct by jumping to report within Visual Studio itself with the same data and it works fine. I assume I am missing something with the URL.

I am at my wits end with this problem, can anybody advise?

Many thanks in advance

revelator
Starting Member

32 Posts

Posted - 2009-01-23 : 05:35:51

Are you passing the parameter Value, not the Label?

-----------------------------------
Waiting for the Great Leap Forwards

mundo23
Starting Member

10 Posts

Posted - 2009-01-23 : 06:26:07

As i've stated, the values that are being passed through are correct, they are simply not pbeing picked up when the report renders.

revelator
Starting Member

32 Posts

Posted - 2009-01-23 : 06:50:04

Have you tried just passing in one parameter? This may be a good place to start debugging the issue.

-----------------------------------
Waiting for the Great Leap Forwards

mundo23
Starting Member

10 Posts

Posted - 2009-01-23 : 09:45:39

Tried that i'm afraid, it still does not work!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-23 : 09:53:23

are any of parameters multivalued with dropdown in drilldown report?

revelator
Starting Member

32 Posts

Posted - 2009-01-23 : 09:57:35

Can you post the properties of some of the parameters?

-----------------------------------
Waiting for the Great Leap Forwards

mundo23
Starting Member

10 Posts

Posted - 2009-01-23 : 10:20:22

Parameters in destination report:

Directorate –
Data Type: String
Multi-Value: False

Category –
Data Type: String
Multi-Value: False

SubCategory –
Data Type: String
Multi-Value: False

ContractHeader –
Data Type: String
Multi-Value: False

MonthFrom –
Data Type: String
Multi-Value: False

MonthTo –
Data Type: String
Multi-Value: False

All values from source report are varchar values and when run within Visual Studio using the jump to report function, it all works well.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-23 : 12:46:39

i see a lot of commas in parameters. is it a single value or are you trying to pass comma seperated list?

mundo23
Starting Member

10 Posts

Posted - 2009-01-26 : 04:10:56

The commas are a single value, not a comma separated list

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-26 : 08:44:07

and the parameters have free text input boxes in navigation report or combo?

mundo23
Starting Member

10 Posts

Posted - 2009-01-26 : 09:38:35

The parameters are all combos

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-26 : 09:40:34

are passed values available among combo values in correct format?

mundo23
Starting Member

10 Posts

Posted - 2009-01-26 : 10:19:28

yes, they are all from the same source

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-26 : 10:20:46

nope...not that. are passed values available inside combo values?

mundo23
Starting Member

10 Posts

Posted - 2009-01-26 : 10:32:19

Yes they are, I have tried within Visual Studio itself using the Jump To Report function and it works so I know that the parameter values themselves should work. It is when I use them to jump to a URL that they do not populate the combo boxes.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-27 : 00:47:44

are you using this in report body or header?

mundo23
Starting Member

10 Posts

Posted - 2009-01-27 : 03:42:24

Using it in the report body, from the row heading on a matrix

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-27 : 12:45:17

i just have a feeling that this is because of / characters in parameter value which its interpretting as path. i think you can try escaping values passed in url by using javascript escape() function. write a custom code to wrap the parameter values within escape() before appending to url.

mundo23
Starting Member

10 Posts

Posted - 2009-02-02 : 05:30:51

I am going to try this solution today to see if it works, however i already have plenty of reports which work with the / character in the parameter so i'm not sure that is the case

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-02 : 09:07:23

ok..lemme know how you got on

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources