If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

About SubReport

Hi, Babu

I have a problem with the parameters passing when I use Sub Report.

Suppose I have a report that contains a sub report. The sub reorts has the same parameters with Main Report. I want to pass the parameters from VC code to the reports, but I don't know how to pass the parameters to sub reports

(1) I would like to load a picture file (eg. JPEG) in Crystal Report. However, my data is in SQL DB. The picture data field is actually the file location (ie. string data type) on my hard disk. Is there a way to solve this?

(2) I know I can do it if I store my picture file as binary image data type in SQL DB instead of just a file name.

(3) And if I have to resort to (2), do u have any sample code about reading and writing a image file into SQL DB?

Sorry for confusion i am trying to view the report in the window.
i can see the report coming up but suddenly it closes. Sometimes it never even open up.
Can it be because of my installation.only few days back i installed and my previous reports if i save it using the recent version is also giving the same problem which was fine previously until i saved it.

Crystal Reports & stored sprocedures

I'm using SQL Server as database server and VB as a programming language. I need to know how can I make a report in CR with datasource as stored procedure (with parameters). I need to send the parameter from VB to CR and the the CR to send the parameter to the stored procedure. Thanks

Uninstall Crystal Report which is installed last, make sure the Crystal Report uninstall properly. Then reinstall the crystal report and then try again to view the reports.

yours,
Babu

Originally posted by sing12
Sorry for confusion i am trying to view the report in the window.
i can see the report coming up but suddenly it closes. Sometimes it never even open up.
Can it be because of my installation.only few days back i installed and my previous reports if i save it using the recent version is also giving the same problem which was fine previously until i saved it.

Re: Crystal Reports & stored sprocedures

Originally posted by valentindvf
I'm using SQL Server as database server and VB as a programming language. I need to know how can I make a report in CR with datasource as stored procedure (with parameters). I need to send the parameter from VB to CR and the the CR to send the parameter to the stored procedure. Thanks

hi,

Which version of crystal Report you are using? Because the all version of crystal report not support stored procedure.