Recent content by techies

I'm tring to select the papersource of a printer to the user selection and give it to the program to print the report to the selected tray of the printer. I bring up the CPrintDialog and let the user select the printer and the tray and assign it to a CrystalReport object to print it. What I'm...

Hi, From the report object you have to get the subreport and do the SetTablePrivateData 0, 3, rs with the subreport object. Refer to thread766-399956. It has the code both in VB and VC++. There since it is using native SQL server driver, there is a call to SetLogonInfo and SetLocation. You...

Hi, You can use the CR API Verify() to do this. oReport.Database.Tables.Item(1).SetDatasource yourRecordset oReport.Database.Verify This should do it. cheers, Techi

Hi Krishna, Yes CR requires a Clientside cursor. I found this out while working on my appn. There is no documentation in CR help regarding this. just look at the following thread thread766-403227

Hi, Are you printing it from the CRViewer after previewing your report or are you directly printing it using the CR API? If you are directly printing it, can you preview it in the CRViewer and can you view all the 50 pages. What database driver are you using for dataaccess? Can you explain it a...

Hi, So you are using the ADO driver. Since it seems to stop pulling pages fro the subreport, make sure you are opening the subreport and setting it datasource to the recordset you are passing.I do not know if you are doing this. From the Report object, get the Section object, iterate through...

Hi Denis, What is exact error text? From what I infer from your question, I think your problem is when you connect to the database. You have to use Report.Database.Tables.Item(1).SetLogonInfo(Server,Databse, userid, password) Then call Report.Database.Tables.Item(1).Location =...

Hi, Are you sure your report has 69 pages? IS the problem when you print\preview from your app? If so try to Preview it from CR itself with the exact same query and find out if it brings back 69 pages. Also what database are you using, what driver are you using for data acces. If you can be...

Hi Munny, Could you elaborate on this. Does your stored procedure have any parameters? How are you setting the datasource to the report? 4200 is an ODBC error code which means [b]Syntax error or Access violation[\b]. Search for ODBC error codes in MSDN. Hope this will help you. Cheers, Techi

Hi Susanne, Are you setting the parameter to the subreports? I mean. are you getting the subreport from the main report, opening the subreport. Then accessing the IParameterDefinition object and setting the values to it? From the main Report object, you have to get a handle to each of the...

Hi Krisha kumar, You can base your datasource to be ADO recordset. You will just have to create the .rpt file to use the ADO driver(Crdb_ado.dll). Execute the stored procedure and send the recordset to CR, this is more reliable than passing the stored procedure to CR, because CR has to execute...

Hi, Are you talking about the Crystal designer window. Then you will need the CRDesignerCtrl(CRDesignerCtrl.dll) instead of the CRViewer. Then you need to call m_CRDesignerCtrl1.ReportObject = CrystalReport Cheers.

Hi all, When you use ADO Recordsets as your datasourse, CR requires it to be a clientside cursor, or else you will not get all the rows back. So use AdoConnection.CursorLocation = adUseClient; I didn't find any documentation in this regard, just found out while working on my app here. This will...

I have CR9 installed on my primary machine. I searched my complete harddrive for crsource.tlb, but could not find it. However I have a secondary pc on which I have CR8.5 installed, I found the crsource.tlb on the 2nd one. So I think, crsource.tlb is not part of CR9, but have not verified it with...

I haven't used this CRDataSource object in CR8.5. Which dll is it from. I have CR9 installed on my machine currently. If you tell me which dll the object is part of I can find out for you. Cheers