Reporting Parameters

[ShaunBPD]

Hi All

I hope I am posting in the correct place.

I am busy developing a reporting tool in vb.net. I am using the report viewer control. The sql setup is pretty complex (well at least to my standards at the moment) and am now thinking about using multiple database queries instead.

So in order for me to do that, I will need to be able to use the information in a table within the report viewer (rldc file) which I have designed for a parameter for the db query.

Can anyone tell me if this is possible and if so, how to go about doing it, I have really tried many different approaches and am at my end on this one, so I have decided to ask for some expert advice.

Your help will be greatly appreciated.

Kind Regards

[Hack]

Welcome to the forums.

I am busy developing a reporting tool in vb.net.

So, you are writing your own report engine. That is pretty ambitious.

I have really tried many different approaches

Lets start here. So that we don't throw out suggestions you have already tried, tell us what approaches you have tried so far, and what went wrong with them.

[ShaunBPD]

Hi,

Thanks for the reply. Its actually the second reporting tool I have written for this client, the first is working pretty well and have asked me to do a second one on another system.

Basically, to be dead honest, I am pretty new-ish to development, my weakness in this case came in when the SQL queries became very complex and have been struggling to get the right data in the right place, so I thought I can have a couple of sql queries going through, but then using the result from one query to populate say the count column of the next query (based on a previously populated ID column).

One thing out of the SQL queries I tried was a subreport, but kept getting an error along the lines of 'Subreport data cannot be shown'.