Home > Archive > Visual Basic Crystal Reports > May 2005 > Cant see SQL Server Stored Procedures in CR in VB.Net
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 |
Cant see SQL Server Stored Procedures in CR in VB.Net
|
|
| Jim Florence 2005-05-13, 4:22 pm |
| Hello,
I'm new to Crystal Reports and have been trying to use some of my stored
procedures and general SQL queries to create reports. I'm using Crystal with
Visual Studio .Net 2003.
I have set up every connection type known to man, OLE, ODBC etc and still
can only see tables and views when I connect to the database in database
expert.No sign of stored procedures.
Am I doing something obviously wrong? I've looked for info everywhere on
this and I'm still  as to exactly how a stored procedure can be used
to easily create a report so any pointers on that would be gratefully
received
Many thanks
Jim Florence
| |
| Brian Bischof 2005-05-14, 4:11 pm |
| Yeah, this tricks everyone. You have to go into the database defaults of the
report designer and check the box to enable SPs to be displayed.
HTH,
Brian Bischof
www.CrystalReportsBook.com
"Jim Florence" <florence_james@hotmail.com> wrote in message
news:4283f210$0$326$cc9e4d1f@news.dial.pipex.com...
> Hello,
>
> I'm new to Crystal Reports and have been trying to use some of my stored
> procedures and general SQL queries to create reports. I'm using Crystal
with
> Visual Studio .Net 2003.
>
> I have set up every connection type known to man, OLE, ODBC etc and still
> can only see tables and views when I connect to the database in database
> expert.No sign of stored procedures.
>
> Am I doing something obviously wrong? I've looked for info everywhere on
> this and I'm still as to exactly how a stored procedure can be
used
> to easily create a report so any pointers on that would be gratefully
> received
>
> Many thanks
>
> Jim Florence
>
>
| |
| Jim Florence 2005-05-14, 7:14 pm |
| Brian,
Your a star,many thanks. I spent a whole day looking for that, could they
have hidden it any better :0)
Regards
Jim Florence
"Brian Bischof" <Brian@NoSpamBischofSystems.com> wrote in message
news:e7$tPQAWFHA.2928@TK2MSFTNGP10.phx.gbl...
> Yeah, this tricks everyone. You have to go into the database defaults of
> the
> report designer and check the box to enable SPs to be displayed.
>
> HTH,
>
> Brian Bischof
> www.CrystalReportsBook.com
>
>
> "Jim Florence" <florence_james@hotmail.com> wrote in message
> news:4283f210$0$326$cc9e4d1f@news.dial.pipex.com...
> with
> used
>
>
|
|
|
|
|