crystal report graph on client side
Hello all,
I've got a problem with my crsytal report.
Actually iI display a crystal report in a crystal report viewer, that works very well on my development machine which is my web server too (web server used is IIS).
But when I want to consultate the report from another machine ( a client machine) the report doesn't work:
the report is loaded, I can see the toolbar and the tree, but the graph can't be loaded and displayed.
I primary thought the problem was a bad dll, but finaly I think the problem is due to a access/permissions configuration.
If someone can help me...
In advance thanks.
ODBC error while calling subreport
hi Babu,
I have a main report which contains details of users like First name, last name ,address etc. This i am selecting directly from a table (database is SQL Server) . I have a sub report which should display the transaction details done by the user in between FromDate and ToDate. For this subreport i have written a parametrised sql query which accepts the From and To dates and selects details of all the users and transactions in that period. I have linked the main report and sub report on Firstname and lastname fields. In the query i am casting the date to smalldatetime. When i run the report it is giving ODBC error.. saying error in converting string to datetime.. . when i use the same query for a main report it is giving results.. Only when the same query is used in subreport and the sub report when called from main, it is giving the error.... please help me .
Thanks
Sudheer
Problems displaying image BLOB fields
Hi, i stored a JPG file (i tried with a BMP too) in a Blob field on a Sql Server 2000 db using a program in Visual Basic 6.
I simply read the file as binary, and put the data on the field using AppendChunk. When i want to retrieve the data in VB, i get it using GetChunk, i write it on a temp file, and use LoadPicture to display the temp jpg file on a PictureBox... All this works fine...
The problem appears in the Crystal Report 8.5 Report: it doesn't display anything. I'm sure i stored "something" because i can read data from my VB program. I tried with the Northwinds database (it has a Table with image data), and CR works fine with it... I think im not saving the data in the right way, does CR use a different manner as my program to read the image from a blob???
Please help me urgently ,
thanks in advance...
Supress report - Very Urgent
Hello there,
I am working with CR 9 evaluation package. I have a main report with 4 subreports. I created 4 details section and each section has a subreport.
I want to supress the main report itself if none of the four subreport have any data. My main report have header and footer too. I just dont want to have the report which is not having any data in the subreports.
And also I want to know whether exporting the report into pdf into separate individual files based on account ID
Expecting earlier reply
Thanks
Thiyagu
Re: Supress report - Very Urgent
Hi,
Refer the NoData event.
Event NoData(pCancel As Boolean)
Member of CRAXDRT.Report
Fires this event when there is no data
Thanks.
Quote:
Originally posted by Thiyagu76
Hello there,
I am working with CR 9 evaluation package. I have a main report with 4 subreports. I created 4 details section and each section has a subreport.
I want to supress the main report itself if none of the four subreport have any data. My main report have header and footer too. I just dont want to have the report which is not having any data in the subreports.
And also I want to know whether exporting the report into pdf into separate individual files based on account ID
Expecting earlier reply
Thanks
Thiyagu
Connect Database to main Report and SubReport (Sample Code)
Dear Friends,
I received more mail (in my personal email) regarding, how to connect database to subreport. Here i paste the sample code for subreport, I hope this will be help all.
'prompt for location of xtreme sample database
CommonDialog1.ShowOpen
'the following code sets the report tables to a different database
CRReport.Database.Tables(1).Location = CommonDialog1.FileName
'set the value for a text object in the header of the main report
CRReport.Text1.SetText "This is the main report"
'this code works through the RDC object model to identify a subreport object
'in the main report
Dim crSecs As CRAXDRT.Sections
Dim crSec As CRAXDRT.Section
Dim crRepObjs As CRAXDRT.ReportObjects
Dim crSubRepObj As CRAXDRT.SubreportObject
Dim crSubReport As CRAXDRT.Report
Dim i As Integer
Set crSecs = CRReport.Sections
For i = 1 To crSecs.Count
Set crSec = crSecs.Item(i)
Set crRepObjs = crSec.ReportObjects
For X = 1 To crRepObjs.Count
If crRepObjs.Item(X).Kind = crSubreportObject Then
Set crSubReport = CRReport.OpenSubreport(crRepObjs.Item(X).SubreportName)
'the following code sets the subreport table to a different database
crSubReport.Database.Tables(1).Location = CommonDialog1.FileName
'set the value for a text object in the header of the subreport
CRReport.Subreport1_Text2.SetText "This is the subreport"
'within this loop you can set other properties of the subreport and
'the field objects and sections in it.
End If
Next
Next
CRViewer1.ReportSource = CRReport
CRViewer1.ViewReport
Supress report - Very Urgent
Hi Mr. Babu,
I am new to CR and I dunno VB too. I couldnt able to find the CRAXDRT.Report anywhere in the CR 9 evaluation package. How to get this enabled or where should i find this. More details would be helpful to me.
Thanks
Thiyagu
Re: Supress report - Very Urgent
Hi,
Add Crystal Report x.x Designers Module in your project, then find the class CRAXDRT in object browser window in view menu.
Regards,
K.Babu
Quote:
Originally posted by Thiyagu76
Hi Mr. Babu,
I am new to CR and I dunno VB too. I couldnt able to find the CRAXDRT.Report anywhere in the CR 9 evaluation package. How to get this enabled or where should i find this. More details would be helpful to me.
Thanks
Thiyagu
Crystal Report Designer Module
Hi Babu,
Thanks very much for you reply. Is CR designer module comes with the evaluation package or I have to download separately :0(
sorry for asking such a simple question.
Thanks
Thiyagu
How to connect to different servers at runtime
Hi ,
In crystal Report can i be able to connect to different servers based on the user input. Eg- User will select a location (Chennai, Bangalore etc..) based on which i have to connect to SQL Server on that location. I don't have a front end like VB or ASP. I have to do it directly in Crystal Report. Is it possible to do this????
Please suggest a solution
Thanks in advance
Sudheer