is it possible to use crystal report for a flat file . if so give example
Printable View
is it possible to use crystal report for a flat file . if so give example
Can I populate a blank Crystal Report with labels, graphics, textboxes and data at runtime ?
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
Can you guide me on how to do it?
Thanx first.
Hi Babu,
(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?
Thanks,
LingLee
Is BABU still around :confused:
Hi
i am facing problems printing the report in visual basic.
i am using the crystalreport ocx to print report to the window.
just as it is printing to window the window closes. i am not able to get any errors also.
i tried setting the properties through codes yet the result is same
CrystalReport2.ReportFileName = App.Path & "\Report.rpt"
CrystalReport2.Destination = crptToWindow
CrystalReport2.Action = 1
can you tell me is there any settings .i have used the similar way for other reports but is fine.
thanks
roopa
hi,
Make sure your default printer is currectly installed, if it's work fine with other software like MSWord.
Then open the crystal report design environment select the printer setup reselect the printer, if you had more than two printer driver change the other printer driver and try again.
yours,
Babu
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.
thanks
roopa
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,
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
Quote:
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.
thanks
roopa
hi,Quote:
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
Which version of crystal Report you are using? Because the all version of crystal report not support stored procedure.
yours,
Babu
i am still unable to see the report it closes without any error
thanks
roopa
QUOTE]Originally posted by K.Babu
hi,
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
[/QUOTE]
The report and program working on another system not on my system. What may be wrong.
i reinstalled crystal reports.it is something with my vb?
i am not able to configure what is wrong.
thanks
roopa
[/QUOTE]Quote:
Originally posted by sing12
i am still unable to see the report it closes without any error
thanks
roopa
QUOTE]Originally posted by K.Babu
hi,
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
Create simple crystal report file, call the file in vb, if it's working fine the problem may be some others.
yours,
Babu
[/QUOTE]Quote:
Originally posted by sing12
The report and program working on another system not on my system. What may be wrong.
i reinstalled crystal reports.it is something with my vb?
i am not able to configure what is wrong.
thanks
roopa
i have tried that also none of them are working all comes up and closes immediately.
thanks
roopa
[/QUOTE]Quote:
Originally posted by K.Babu
Create simple crystal report file, call the file in vb, if it's working fine the problem may be some others.
yours,
Babu