Hello,
I have a load of crystal reports which have been created previously, and what I'd like to do is print / preview these from my VB.NET application.
Ideally I'd want a form in VB which will list all of the crystal reports in a particular location on my hard drive. Then I'd like to be able to click onto the reports and print / preview them in the Crystal Viewer.
I have found something called Crystal Reports Viewer on the toolbox, but I can only seem to link 1 report to that.
Can anyone help me with this please, or point me in the direction of some documentation which will help me do this?
Thanks,
J.use filedialogbox and set default path to ur local hard drive folder.
whattever file user selects map it to, reportsourse property of crystalreportviewer.
Showing posts with label preview. Show all posts
Showing posts with label preview. Show all posts
Sunday, March 25, 2012
Tuesday, March 20, 2012
Crystal Reports 10 - Export Function does not work
Hello,
I have Version 8 and Version 10 Professional of Crystal Reports installed on my PC. When I embed a Preview window for Crystal Reports using crpe32.dll (version 8), I can click on the Export option ... and export to anything.
When I use the crpe32.dll (10.0.0.533) for Version, everything works except the Export button. I just get a cursor wait for a second and nothing happens.
If I open Crystal Reports Version 10 Professional and run the report from there, I can select FILE / EXPORT and get the Export Dialog box without any issue.
What is needed to make this work ... and what is needed for end-user distribution. The end-users are responsible for writing their own reports, and I don't want to require a certain version (8, 9,10,etc) -- what am I missing?
Thank you very much.I am having the same problem except I am converting from Crystal 6 to Crystal 9. Let me know if you get a fix for this.
Thanks!|||Still now answer?
Does anyone know - who can help me with this?|||There is a Crystal Reports 10 hot fix for this problem. Go to http://support.businessobjects.com/search/ and search for "crystal reports runtime error export excel". I downloaded and installed it and am able to export now.
I have Version 8 and Version 10 Professional of Crystal Reports installed on my PC. When I embed a Preview window for Crystal Reports using crpe32.dll (version 8), I can click on the Export option ... and export to anything.
When I use the crpe32.dll (10.0.0.533) for Version, everything works except the Export button. I just get a cursor wait for a second and nothing happens.
If I open Crystal Reports Version 10 Professional and run the report from there, I can select FILE / EXPORT and get the Export Dialog box without any issue.
What is needed to make this work ... and what is needed for end-user distribution. The end-users are responsible for writing their own reports, and I don't want to require a certain version (8, 9,10,etc) -- what am I missing?
Thank you very much.I am having the same problem except I am converting from Crystal 6 to Crystal 9. Let me know if you get a fix for this.
Thanks!|||Still now answer?
Does anyone know - who can help me with this?|||There is a Crystal Reports 10 hot fix for this problem. Go to http://support.businessobjects.com/search/ and search for "crystal reports runtime error export excel". I downloaded and installed it and am able to export now.
Monday, March 19, 2012
crystal report.. on network application
i m using crystal report with vb...
i have designed a report with a table on it..
the table creates when user click on the preview button on the form..
named tmpAccountLedger..
but when 2 or more users click at the same time..with the different account specifie.d...
the report shows the same for all users..
what should i do..
plz suggest..
regards.What's the underlying database? Can you use a session table? Can you use some sort of id to uniquely name each table creation? I assume you drop it at the end somehow?|||For MSSQL, I use global temporary tables for such purposes. When developing a report, I create a normal "dummy" table with prefix "_tmp_" that can be used for building report. At runtime, I create global temporary table like "##SF93DXU2" with same structure, and replace the name of original dummy table with the name of actual temporary table. Works fine. You can even forget to drop the table afterwards and SQL will clean it up for you. In fact, there are situations where you can't drop the table yourself (for example, if temporary table is used in a subreport at the end of the report, then it is not queried immediately but only when the user reaches the page that contains subreport).
i have designed a report with a table on it..
the table creates when user click on the preview button on the form..
named tmpAccountLedger..
but when 2 or more users click at the same time..with the different account specifie.d...
the report shows the same for all users..
what should i do..
plz suggest..
regards.What's the underlying database? Can you use a session table? Can you use some sort of id to uniquely name each table creation? I assume you drop it at the end somehow?|||For MSSQL, I use global temporary tables for such purposes. When developing a report, I create a normal "dummy" table with prefix "_tmp_" that can be used for building report. At runtime, I create global temporary table like "##SF93DXU2" with same structure, and replace the name of original dummy table with the name of actual temporary table. Works fine. You can even forget to drop the table afterwards and SQL will clean it up for you. In fact, there are situations where you can't drop the table yourself (for example, if temporary table is used in a subreport at the end of the report, then it is not queried immediately but only when the user reaches the page that contains subreport).
Sunday, March 11, 2012
Crystal report in VB
Hello,
THis is my first time using crystal report and VB6.
Can someone give me some examples on how should I do to preview the report built in crystal report in VB6? After preview, I want to print it out too, using VB.
I found something in the internet that I should use the crystal report control, but I still don't know how to display it...
Cheers!
ClaudiHi,
You can very well use the crystal report control. kindly follow the steps to view crystal report using VB 6.0
1. Open a vb application (Standard EXE).
2. go to Project Menu->components
3. in components list box, get the crystal32.ocx control to add that.
4. design a report using crystal report.
5. then follow the code to view the report from VB.
public sub cmdViewReport_Click()
With
.reportfile=app.path & "\MyReport.rpt"
.WindowTitle = "Report Output"
.WindowState = crptMaximized
.WindowShowGroupTree = True
.WindowShowPrintSetupBtn = True
.WindowShowSearchBtn = True
.Action = 1
End With
End Sub
Hope, this will help....
Regards
Deepak
THis is my first time using crystal report and VB6.
Can someone give me some examples on how should I do to preview the report built in crystal report in VB6? After preview, I want to print it out too, using VB.
I found something in the internet that I should use the crystal report control, but I still don't know how to display it...
Cheers!
ClaudiHi,
You can very well use the crystal report control. kindly follow the steps to view crystal report using VB 6.0
1. Open a vb application (Standard EXE).
2. go to Project Menu->components
3. in components list box, get the crystal32.ocx control to add that.
4. design a report using crystal report.
5. then follow the code to view the report from VB.
public sub cmdViewReport_Click()
With
.reportfile=app.path & "\MyReport.rpt"
.WindowTitle = "Report Output"
.WindowState = crptMaximized
.WindowShowGroupTree = True
.WindowShowPrintSetupBtn = True
.WindowShowSearchBtn = True
.Action = 1
End With
End Sub
Hope, this will help....
Regards
Deepak
Crystal Report Generic Text Printer - Printing Problem
Hi
I am using vb6. Crystal Report 9. I use Generic / Text Printer to print Invoice. It shows everything ok in preview but when it prints, printing goes outside the printing area. I use mostly 10cpi fonts and for figures 17cpi fonts.Install the latest CR9 service pack. If problem remains, use another printer driver.
I am using vb6. Crystal Report 9. I use Generic / Text Printer to print Invoice. It shows everything ok in preview but when it prints, printing goes outside the printing area. I use mostly 10cpi fonts and for figures 17cpi fonts.Install the latest CR9 service pack. If problem remains, use another printer driver.
Subscribe to:
Posts (Atom)