Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Passing multiple parameters to generate report

Posted on 2008-06-24
4
Medium Priority
?
291 Views
Last Modified: 2013-11-26
Hi Experts,

I have a vb.net app, where i can choose multiple suppliers to generate a product list report on them. My question is, if I select 400 suppliers to include in the report, how do i get those values through to reporting services / my report url, without killing the query string with 400 values?
0
Comment
Question by:Kobz46
  • 2
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
CutSack earned 2000 total points
ID: 21862539
Hi,

How about creating a "ReportParameters" table in your database, with two columns, one being a GUID and the other a text/varchar.

The vb.net app could then create a GUID to put into the first column and a comma separated string of the suppliers into the other.

Then pass the GUID as a parameter to reporting services and use it in your query to do a sub-select to limit the results of the report, based on the saved string.

Your report would need to have a Stored Proc as the data source to enable the query to be dynamic.
0
 

Author Comment

by:Kobz46
ID: 21862987
Howzit C!

That is a good idea and perfect solution and I will award the points to you. I do however have another quick question, I know you can use the reportviewer in vs2005, to generate a dataset in code, give it to the reportviewer and bob's your uncle...

I can't seem to find that report viewer class in 2003? I can only see crystalreportviewer... Do you know of such a class?
0
 
LVL 4

Expert Comment

by:CutSack
ID: 21863388
Hi Kobz46,

The ReportViewer controls are new to VS2005 (and VS2008), prior to that the only option was to redirect to the URL of the report.
0
 

Author Comment

by:Kobz46
ID: 21863410
Thought as much... :-/

Good enough reason to convert the app to 2005/8 hey?

Thanks bud!
K
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month12 days, 13 hours left to enroll

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question