Using stored procedure in crystal report 8.5?

Posted by odiseh on Stack Overflow See other posts from Stack Overflow or by odiseh
Published on 2009-11-24T10:38:29Z Indexed on 2010/03/24 20:03 UTC
Read the original article Hit count: 440

Filed under:

crystal-reports

|

vb6

|

stored-procedures

|

parameter

I have made a new report using Crystal Reports 8.5 (report1) which uses a stored procedure as its data source. The stored procedure has 2 input parameters (@p1 and @p2) and when I enter some test data for @p1 and @p2 within crystal report IDE , every thing is all right. Then, I added the report1 in visual basic 6.0 IDE and added a new form (form1) and a crystal report viewer control on form1. Now please help me: I wanna to show the report1. What codes exactly should I write to show it?How send data user has entered to the stored procedure parameters via application? I also get this error messsage: the server has not been opened yet"

What's wrong?

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about vb6

VB6 App + .Net component working as compiled app but not in VB6 IDE

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VB6 App that uses a .Net component (via a .tlb reference in the VB6 app) which is working fine when executed as a compiled app, but it produces an error from the VB6 IDE a certain point when it is trying to use the .NET component. I should note that the error occurs when the .NET component… >>> More
Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
Is it possible to simultaneously debug VB6 and a C++ COM dll?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VB6 dll that is loaded by a VB6 frontend. This VB6 dll calls a C++ ATL dll via its COM interface. So, I can run from code in VB6 and I can debug in C++ also, however I can't seem to step through the VB6 code and then get into the C++ code. I feel that this should be possible. Currently I… >>> More
Writing excel file to vb6

as seen on Stack Overflow - Search for 'Stack Overflow'
i have an excel file template and i want save the written value in textboxes to the cells of excel using vb6 language. can anyone help me? >>> More
Trace not working in a .NET DLL loaded from VB6 EXE

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I have a .NET DLL that writes to the Trace. But seems that when I call my DLL from a VB6 EXE the trace is not working. I have created an myApp.config file in the EXE folder with the trace configuration, but this does not solves the issue. I've also tried creating the Trace objects in code… >>> More