Home > Archive > Visual Basic Crystal Reports > March 2006 > VB.NET, Crystal, and MS Access "Stored Procedures"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
VB.NET, Crystal, and MS Access "Stored Procedures"
|
|
|
| My questions is about using Crystal Reports with a parameterized query in
Visual Studio 2003. I have created a query in MS Access that takes two
parameters. I am using the Crystal Reports designer included in Visual
Studio. For some reason, I cannot select my Access query as the data source
for the report.
When I look in the Server Explorer, my query appears under the "Stored
Procedures" header. Other Access queries that do not take parameters appear
under the "Views" category. When I try to set my datasource for the Crystal
Report, I see all of the queries that show up under "Views", but I don't see
the "stored procedures", and don't see any way of selecting them.
I know that in the stand-alone version of Crystal, not the one included in
VS 2003, there was an option to display stored procedures along with tables
when specifying a data source. Is there a similar option in the version of
Crystal included with VS that I need to set? How do I get to it?
Or am I forced to either use the stand-alone Crystal or create my query
without parameters?
Thanks,
Dave
|
|
|
|
|