Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Passing multiple parameters to generate report

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
Kobz46
Asked:
Kobz46
  • 2
  • 2
1 Solution
 
CutSackCommented:
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
 
Kobz46Author Commented:
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
 
CutSackCommented:
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
 
Kobz46Author Commented:
Thought as much... :-/

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

Thanks bud!
K
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now