I have a web site that needs to generate crystal rpts at runtime. It is developed in VS 2008 with VB.NET. I am using the Crystal that is budled with VS for rpts.
I have been able to bind the crystal rpt with a dataset in the web site. Report is dispalyed correctly. My problem is I need for another the dataset to be bound to the same report at run time when the user selects a different entity on the webpage. This dymnamic binding to a different sql server stored procedure.
The layout of the stored procs are identical(i.e. field types, field names, etc), just being generated from a different set of tables.
I have not been able to find to dynamically bind a different dataset/tableadapter that is created from a different sql SP to my report at runtime. Can anyone give me some direction? I have spent a lot of time trying to solve this. Thanks!
John Mitchell