Advertisement

05.09.2008 at 10:18AM PDT, ID: 23390181 | Points: 250
[x]
Attachment Details
Problem passing parameters to SSRS server report using Report Viewer Control.
Tags: SQL Server Reporting Services, 2005, .NET, C#, IE 7
Using the .NET ReportViewer Control we are trying to create a generic report viewer app that can display any report on our SSRS server.  We want to pass in one hidden parameter determined at run time and make use of the built-in functionality allowing the user to provide values for additional parameters.  A report could have any number of parameters specific to the report.  

(See code snippet)

The test report has Param1 and an additional string parameter defined in it.  When we run the code, we type something into the additional string parameter and click "View Report".  The additional string parameter is then blanked out and no report is generated.  

We have tried a couple of other methods: If we don't pass any parameters to the report and, instead, enter both in the report viewer control, the report works fine; also, if we pass all parameters in the code-behind the report works fine.  

The problem is we dont know how many parameters there will be for a given report.  So, we would prefer to only pass in the one parameter and have the system determine what to do with the other parameters.  Does anybody know a way to get this to work?
1:
2:
3:
4:
5:
6:
7:
8:
//The following code passes a single parameter to the server report:
protected void Page_Load(object sender, EventArgs e)
{
   List<Microsoft.Reporting.WebForms.ReportParameter> ParamList = new List<Microsoft.Reporting.WebForms.ReportParameter>();
   ParamList.Add(new Microsoft.Reporting.WebForms.ReportParameter("Param1", "TestValue", false));
   ReportViewer1.ServerReport.SetParameters(ParamList);
   ReportViewer1.ServerReport.Refresh();
}
Start your free trial to view this solution
Question Stats
Zone: Microsoft
Question Asked By: yladmin
Question Asked On: 05.09.2008
Participating Experts: 2
Points: 250
Views: 0
Translate:
Loading Advertisement...
05.09.2008 at 11:43AM PDT, ID: 21535456

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 11:58AM PDT, ID: 21535563

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 01:49PM PDT, ID: 21536321

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.12.2008 at 10:39AM PDT, ID: 21548959

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
05.09.2008 at 11:43AM PDT, ID: 21535456
Are you trying to generate a new parameter internaly based on the one that was submitted by the user or generate multivalue parameters?
 
05.09.2008 at 11:58AM PDT, ID: 21535563
What I like to do in this type of scenario

... (by that I mean not just for SSRS reports, but application scenarios where I need to limit the number of values passed or better yet pass them in the URL and hide it from the user)...

is to have the application link all parameters to a token (which is just a single unique value, for example a GUID).  Then insert into a table the token and the associated parameters.  Then in the report or whatever page being shown you just look at the token that was passed in,and do a select to find all the associated parameters.

A few of the advantages are that you are not limited by things like the length of an URL, or how many parameters the report supports, etc.  Using something like a GUID (or better yet a base-64 encoded GUID) you are adding a level of security because its unlikely the user could guess a valid token (if you really need security, make it so that the token expires either once read or after a time period, then you've eliminated the chance that someone could hit that page or report outside the scope of your application... i.e. they can't just send a link to a friend).
 
05.09.2008 at 01:49PM PDT, ID: 21536321
zx10r,
- Neither. The parameters are already defined by whichever report is selected to be viewed (by the user). The problem is we'd like to programmatically pass one parameter (for security) while using the Report Viewer Control built-in functionality to provide input controls for any additional parameters that are needed.

pragmatistMS,
- That's a good idea, but it's not the direction we'd like to go.... We want to avoid building our own input controls for parameters since we'll have to do that dynamically for any given report. We'd rather use the Report Viewer Control's built-in parameter entry controls and hide the single parameter that we'll pass programatically.

The problem comes when we combine passing a parameter with using the built-in functionality of the Report Viewer Control to gather parameter input.
 
05.12.2008 at 10:39AM PDT, ID: 21548959
Thanks for the comments but we found the answer.

The problem was that we were setting the parameter for the Server Report on Page Load. When we set the parameter earlier, on Page Init it resolves the problem.

this is not our post, but led to our solution: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=995022&SiteID=1
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628