[2005] Creating dyanmic reports - HELP!!

[mulhearn22]

Hi,

So here's what I want to do:

I want to query the database, get a dataset, bind it to the reportviewer and display the results. I do not want to create a template report before hand. I do not want to use CrystalReports because it is not installed. I want to use the ReportViewer that comes with VS05 and has the rsweb prefix.

Please help.

TIA,
Matt

[mendhak]

http://msdn.microsoft.com/en-us/libr...71(VS.80).aspx

[mulhearn22]

mendhak - That was close but the tutorials still had me creating a template beforehand (when they make a xsd and then have you drag the columns onto the report to show them). I want the report to juse fill no matter what SQL statement I hit it with. Any ideas on how to do that?

[mendhak]

You aren't necessarily restricted by dragging and dropping. You can always specify the sql/stored procedure you want to use.

I did another search and came across this
http://www.codeproject.com/KB/webfor...ortViewer.aspx

Which uses a stored procedure. I'd imagine that you can modify this to make it run anything.

[mulhearn22]

are you sure i'm not? this example also has me drag and dropping. under fig 2 it says:

"Drag the column “ProductName” from the “Website Data Sources” window, and drop it in the Detail row "

i've gotten it to work where it sees the datatable and binds it, but nothing shows up. am i really restricted to having the fields manually setup before hand to display the data?