Using report viewer on aspx (VS2005) page and calling enterprise crystal report 10 vertion, but when we trying to export using export button to PDF all characters in englisg exporting properly, but Chinese letters are not exporting correctly, exporting like squares, can any one advice what needs to do.
Thanks
Phaneendra.Are Chinese fonts installed on the client and server? Does Crystal or Adobe require a separate or special Chinese fonts install?|||Thanks for response TripperDay,
Using font type PMingLiu for report chinese fields, Yes font type allrady installed in bothe local and UAT machines, it is like
Font Name : MingLiu & PMingLiu (TrueType)
Filename : mingliu.ttc
in C:\WINDOWS\Fonts, but still can't see chinese fonts in PDF,
is there any other way to get correct.
Showing posts with label button. Show all posts
Showing posts with label button. Show all posts
Thursday, March 22, 2012
Crystal Reports error
Hello: :wave:
I have a C# project which contains a web form, which has a button calling a web page containing a crystalreportviewer, which contains a CrystalReport report; when I call this page through Response.Redirect("WebForm2.aspx"); WebForm2 is not opening, instead it is sending me an error: [Null]Reference Exception: Reference to object does not stated as object's instance.]
Somebody know what is reason of this error?
I'll thank you for your help.
A.L.Hello.
At last I found the way to solve it. Something wrong was in it.
I reinstalled Visual Studio .NET.
Regards.
A.L.
:wave:
I have a C# project which contains a web form, which has a button calling a web page containing a crystalreportviewer, which contains a CrystalReport report; when I call this page through Response.Redirect("WebForm2.aspx"); WebForm2 is not opening, instead it is sending me an error: [Null]Reference Exception: Reference to object does not stated as object's instance.]
Somebody know what is reason of this error?
I'll thank you for your help.
A.L.Hello.
At last I found the way to solve it. Something wrong was in it.
I reinstalled Visual Studio .NET.
Regards.
A.L.
:wave:
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).
Crystal Report Viewer "Error, Not Implemented"
I have reports to display using Crystal Report 10.
To print it, the user has to push a button on vb which open a vb form called
CrViewer.
Since the source of the CR could be in a different location, im trying to make it load a db from a path that is saved into the db.
Private Sub Form_Load()
Dim lsSql As String
Dim lstr As String
Dim lDateDebut As Date
Dim lDateFin As Date
Dim lcFormulas As String
Dim liListcount As Integer
Dim lsPathBD As String
Dim lvRapportId As Variant
Dim llPeriodePaye As Long
Dim lCrxApplication As CRAXDRT.application
Dim lRapportCrystal As CRAXDRT.Report
Dim lCrxDatabaseField As CRAXDRT.DatabaseFieldDefinition
Dim i As Long
Set lCrxApplication = New CRAXDRT.application
Set lRapportCrystal = lCrxApplication.OpenReport(ObtenirRepertoireRapport() & "RapportAdmRemboursementCumul.rpt", crOpenReportByTempCopy) ' OptenirRepertoirRapport() is a function that return the path to the report directory that is saved in the database.
' Finds the path from the registry...
lsPathBD = GetSetting("GTS", "Demarrage", "RepertoireBD", "")
lRapportCrystal.DiscardSavedData
For i = 1 To lRapportCrystal.Database.Tables.Count
lRapportCrystal.Database.Tables(i).Location = lsPathBD
Next i
frmCRViewer.CRViewer.ReportSource = lRapportCrystal
CRViewer.ViewReport
Set frmCRViewer = Nothing
Set lCrxDatabaseField = Nothing
Set lRapportCrystal = Nothing
Set lCrxApplication = Nothing
End Sub
The problem is encounter when the Crystal Report is opening. it Open but then I get the Error "Erreur, Non Implment" with "Crystal Report Viewer" as title for the errmsg.
Im using Visual Basic 6.0 (SP6)
Windows XP Home, French (SP2)
Crystal Report 10.0.5.1025 Dev. Full, French
Any Help would be Appreciated.the properties of the Database are:
OLE DB (ADO)
Microsoft.Jet.OLEDB.4.0
C:\Projet\Simoneau\DB\DB.mdb
Access
1033
-6
Admin
When using the Crystal Report Tool, no error are popping up but when calling the command
CRViewer.ViewReport The Error pop's up.
I have download a sample from Planet Source
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=59818&lngWId=1
It also work fine using the Access/Excel(DAO) database source but if I change it to Microsoft.Jet.OLEDB.4.0 it keep giving me that same error.
Is there anyway to go around this error msg and display my report using Microsoft.Jet or do i have to use Access/Excel DAO absolutely ?
To print it, the user has to push a button on vb which open a vb form called
CrViewer.
Since the source of the CR could be in a different location, im trying to make it load a db from a path that is saved into the db.
Private Sub Form_Load()
Dim lsSql As String
Dim lstr As String
Dim lDateDebut As Date
Dim lDateFin As Date
Dim lcFormulas As String
Dim liListcount As Integer
Dim lsPathBD As String
Dim lvRapportId As Variant
Dim llPeriodePaye As Long
Dim lCrxApplication As CRAXDRT.application
Dim lRapportCrystal As CRAXDRT.Report
Dim lCrxDatabaseField As CRAXDRT.DatabaseFieldDefinition
Dim i As Long
Set lCrxApplication = New CRAXDRT.application
Set lRapportCrystal = lCrxApplication.OpenReport(ObtenirRepertoireRapport() & "RapportAdmRemboursementCumul.rpt", crOpenReportByTempCopy) ' OptenirRepertoirRapport() is a function that return the path to the report directory that is saved in the database.
' Finds the path from the registry...
lsPathBD = GetSetting("GTS", "Demarrage", "RepertoireBD", "")
lRapportCrystal.DiscardSavedData
For i = 1 To lRapportCrystal.Database.Tables.Count
lRapportCrystal.Database.Tables(i).Location = lsPathBD
Next i
frmCRViewer.CRViewer.ReportSource = lRapportCrystal
CRViewer.ViewReport
Set frmCRViewer = Nothing
Set lCrxDatabaseField = Nothing
Set lRapportCrystal = Nothing
Set lCrxApplication = Nothing
End Sub
The problem is encounter when the Crystal Report is opening. it Open but then I get the Error "Erreur, Non Implment" with "Crystal Report Viewer" as title for the errmsg.
Im using Visual Basic 6.0 (SP6)
Windows XP Home, French (SP2)
Crystal Report 10.0.5.1025 Dev. Full, French
Any Help would be Appreciated.the properties of the Database are:
OLE DB (ADO)
Microsoft.Jet.OLEDB.4.0
C:\Projet\Simoneau\DB\DB.mdb
Access
1033
-6
Admin
When using the Crystal Report Tool, no error are popping up but when calling the command
CRViewer.ViewReport The Error pop's up.
I have download a sample from Planet Source
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=59818&lngWId=1
It also work fine using the Access/Excel(DAO) database source but if I change it to Microsoft.Jet.OLEDB.4.0 it keep giving me that same error.
Is there anyway to go around this error msg and display my report using Microsoft.Jet or do i have to use Access/Excel DAO absolutely ?
Sunday, March 11, 2012
Crystal Report Problem
Please guide me..
I have a form which has a button on it. when clicked it opens up a Crystal Report, designed in Crytsal Report 10.0.
The source of the data for the report is an .xsd file, which basically resides in my C:\INETPUB\WWWROOT\<app name>\ directory.
The application runs fine on my machine.
when the whole of the code is deployed to some other machine and executed, the report again looks for the .xsd file in the
C:\INETPUB\WWWROOT\<app name>\ which is different this time, and thus results in an error.
How can this be solved...The data source obviously has to be available to wherever you're trying to run the report from. I'd suggest putting the file in a shared place on the network so that all machines running the report can access it using the same address.
I have a form which has a button on it. when clicked it opens up a Crystal Report, designed in Crytsal Report 10.0.
The source of the data for the report is an .xsd file, which basically resides in my C:\INETPUB\WWWROOT\<app name>\ directory.
The application runs fine on my machine.
when the whole of the code is deployed to some other machine and executed, the report again looks for the .xsd file in the
C:\INETPUB\WWWROOT\<app name>\ which is different this time, and thus results in an error.
How can this be solved...The data source obviously has to be available to wherever you're trying to run the report from. I'd suggest putting the file in a shared place on the network so that all machines running the report can access it using the same address.
Crystal Report Factors
hi guys!
i just want to ask my problem about my exporting file under vb code applications...
when i click the export button it doesnt work... nothing happen...
i wonder if you can give an idea how to fix this problems...
ASAP!
thank you very much!
benjzMake sure you have the correct dlls installed on the machine you want to Export from. In Crystal Reports 8.5, there's a file called runtime.hlp that tells you what files are required and whee to put them.|||do i need to install those dll in every client that are using the application? i thought its automatically deploy by setup app...
is it ok if you can give me the list of this dll's?
thankz a lot!
benjz|||Depending on what app you're using to create your setup file, you may have to specify that you want Export capabilities included.
See my post here (http://www.dev-archive.com/forum/showthread.php?t=318504) for a list of the Export dlls required (for CR 8.5).
i just want to ask my problem about my exporting file under vb code applications...
when i click the export button it doesnt work... nothing happen...
i wonder if you can give an idea how to fix this problems...
ASAP!
thank you very much!
benjzMake sure you have the correct dlls installed on the machine you want to Export from. In Crystal Reports 8.5, there's a file called runtime.hlp that tells you what files are required and whee to put them.|||do i need to install those dll in every client that are using the application? i thought its automatically deploy by setup app...
is it ok if you can give me the list of this dll's?
thankz a lot!
benjz|||Depending on what app you're using to create your setup file, you may have to specify that you want Export capabilities included.
See my post here (http://www.dev-archive.com/forum/showthread.php?t=318504) for a list of the Export dlls required (for CR 8.5).
Thursday, March 8, 2012
Crystal Report & PDF Format
hello
I need 10-15 reports on one button click from the database, all the reports should be print in a PDF Format. so pl. tell how i can do this in dot net envoirnment.
ASAP
Shoaib ShaikhHave you tried doing a search on this board? There are lots of examples. I have posted several for VB 6 and CR 8.5 which you might be able to tweak a bit to use with .NET.
Also, look at Crystal Report's Search (http://support.businessobjects.com/search/advsearch.asp) or Crystal Report's Forum (http://support.businessobjects.com/forums/default.asp).
I need 10-15 reports on one button click from the database, all the reports should be print in a PDF Format. so pl. tell how i can do this in dot net envoirnment.
ASAP
Shoaib ShaikhHave you tried doing a search on this board? There are lots of examples. I have posted several for VB 6 and CR 8.5 which you might be able to tweak a bit to use with .NET.
Also, look at Crystal Report's Search (http://support.businessobjects.com/search/advsearch.asp) or Crystal Report's Forum (http://support.businessobjects.com/forums/default.asp).
Saturday, February 25, 2012
Cryatal Viewer
I need to test if the user had clicked the print button on the crystal viewer in my design (not in run time) this button is disable how can I by code know if the user had clicked this button on any else button of the crystal reportLet me get this straight...
You want to determine if the Crystal Viewer was clicked in design time
Do you want to add custome events to any of those controls
I can't see why you want to do this, they already have functionality, they already function as they should :confused:
Or..
You can in any case loop through the Form's controls, determine if the current control is a
CrystalDecisions.Windows.Forms.PageView then loop further through that container to (for example) change the caption of the Tabpage.
Can you explain your problem a bit more please!|||I need to know when he clicked the print button I need to know if he choosed to print as Landscape or portrait
You want to determine if the Crystal Viewer was clicked in design time
Do you want to add custome events to any of those controls
I can't see why you want to do this, they already have functionality, they already function as they should :confused:
Or..
You can in any case loop through the Form's controls, determine if the current control is a
CrystalDecisions.Windows.Forms.PageView then loop further through that container to (for example) change the caption of the Tabpage.
Can you explain your problem a bit more please!|||I need to know when he clicked the print button I need to know if he choosed to print as Landscape or portrait
Subscribe to:
Posts (Atom)