Crystal Report

hi

don't use same database once again, if you want to open more the one database, use 0 index for first database, use 1 index for second database.

make sure your database path is correct

if your database is placed in your exe directory you may use the following e.g. code

gDataBaseNameSecond = App.path & "\Inventory.mdb"

CrystalReport1.DataFiles(0) = gDataBaseNameFirst
CrystalReport1.DataFiles(1) = gDataBaseNameSecond

Hi Babu,
I tried your suggestion and I still get the same error. The report will work on my machine as the db location is the same as when I set up the report / subreport in Crystal.

I wanted to change the location at run time, as I do for my other reports using app.path. That way I do not need to know where the db is on the user's pc.

I found this on Crystal's web site, but have not been able to work through it yet.

http://support.crystaldecisions.com/...s/c2002360.asp

I was hoping there was an easier way to do it.

Thanks,
SB

hi,

You may also test sub report working alone, without any main reports.

For testing.

Dear All,

Some people mailed at my personal mail, and they asked me to send my photo, so i upload my photo at codeguru web site with the size of 50 x 50 pxls.

Yours Babu

Hi Babu,
That's a great job done. Just an unsolicited advice, while posting reply please do address the answer to the member who posted it like : Dear debuchakrabarty, if I had posted it. Since the thread is collosal now, it would let the member locate his answer easily. More easy would be to reply to the particular post in which case s/he gets to know about it thru email.

:)
Hats off to you!

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

---

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

---

hi,

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:

---

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

---

[/QUOTE]

Create simple crystal report file, call the file in vb, if it's working fine the problem may be some others.

yours,
Babu

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

---

[/QUOTE]

i have tried that also none of them are working all comes up and closes immediately.
thanks
roopa

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

---

[/QUOTE]

Are you Confirm your condition matches the records in data.

Quote:

---

Originally posted by sing12
i have tried that also none of them are working all comes up and closes immediately.
thanks
roopa

---

[/QUOTE]

dear babu,

i am using vb.net and sql server and crystal reports

i did all reports outside .net and i want to show the reports and selectin formula in browser

what r the steps to show report in browser without enabling savewithdata option


phani

hi
i am confirmed the records match since the report is seen in the report designer without any problem
But now within 2 days i have to solve it.
this time i tried in another system also still does not work(completely new did installation from scratch)

any other suggestions?

thanks

roopa

Quote:

---

Originally posted by K.Babu
Are you Confirm your condition matches the records in data.

---

[/QUOTE]

Hi Badu, we have licensed Crystal 8.5 Enterprise , we developed
embedded Reports (dsr) with Visual Basic 6.0 SP5.

But we are not able to distribute it , we built a setup
routine with the Setup Factory tool from indigo rose
(great tool) .

After installing on a new machine everything works ,
but when it comes to the reports

-> bang , 713 error active X Object can not be activated.

We have to install the full Version on that machine then
it works . is it a license Problem ???

can you help ?

Most of the developers mailed me, setup wizard unable to prepare installation files, because of crystal report, they had licensed version of crystal reports.

You need to edit your setup wizard (or) other third party setup tool

Find out crystal report related files and add at setup wizard manually (depends the usage of crystal report).

for more information refer crystal report distribute fies from documentation.

Babu

Quote:

---

Originally posted by bobiermann
Hi Badu, we have licensed Crystal 8.5 Enterprise , we developed
embedded Reports (dsr) with Visual Basic 6.0 SP5.

But we are not able to distribute it , we built a setup
routine with the Setup Factory tool from indigo rose
(great tool) .

After installing on a new machine everything works ,
but when it comes to the reports

-> bang , 713 error active X Object can not be activated.

We have to install the full Version on that machine then
it works . is it a license Problem ???

can you help ?

---

Hi Babu,

Someone has also encountered the same problem with me. The image quality is very poor when we include a BLOB object in the report.

I notice that the same image (if I happen to enlarge the size of it on the design part in details section of Crystal Report) has better and in fact excellant quality if I make it the size of about 1/2 A4 paper.


We also tried doing this using VB. No problem with the image quality.

Did u, or anyone in the forum, has any idea about this? Need some advice.

Thanks.

Hi,

Try to change the picture some other format like .jpg .gif .tif, this will solve your problem.

yours,
Babu

Quote:

---

Originally posted by alfee5
Hi Babu,

Someone has also encountered the same problem with me. The image quality is very poor when we include a BLOB object in the report.

I notice that the same image (if I happen to enlarge the size of it on the design part in details section of Crystal Report) has better and in fact excellant quality if I make it the size of about 1/2 A4 paper.


We also tried doing this using VB. No problem with the image quality.

Did u, or anyone in the forum, has any idea about this? Need some advice.

Thanks.

---

Hi, Babu

I was "forced" to use BLOB instead of jpeg, gif, etc.

Initially I was storing only the the .jpeg file location in my SQL database. However, when I designed my report, I can't drag the data field of my image file location to the detailed section in the report. Else, during run time, the report won't show my image!!

If I design using the picture box, I need to specify the image file name at the very beginning. But I have different image to show during run time for each record in the SQL database.

So I just want to confirm with you is it because of BLOB, the quality of image becomes so bad??

Is there any other way to solve my problem? Bearing in mind that I need to store my image file location (or it can be BLOB object, i don't really care) in SQL DB. Actually I have tried to write a .jpeg file to BLOB object in SQL DB and then read the BLOB object out from SQL DB back to .jpeg file. I find no data loss as the file size still the same, and the .jpeg image still looks like original.

Thanks.

You have two options - make the pic box the same size as the original jpeg size, or,
decrease the size of the jpeg to the size of your pic box BEFORE you store it away as blob/file name.

The problem is caused by the pic box not resizing the image correctly.

Actually I tried that before, using Photoshop to reduce the image size before storing into SQL DB. And my picture box in the crystal report is sized to about that of my image. However, I still get the same poor quality of image.

Another thing to check with you all.......................

Anyone uses Crystal report and integrate with web? Meaning that I am accessing the report through web using some asp codes.

I am able to do that from machines that have win2K server on it.
I was prompted to install some Crystal Active X stuffs before the viewing of the report through our work place domain.

However, on other machines with Windows 2000 Professional or XP, I won't get prompted to install the ActiveX stuffs, and my report won't be able to view.

May I know what can I do? or where is the viewer active X stuffs for me to install on those win2K Pro machines?

Thanks a lot in advance.

Hi Babu,

I am using Crystal Report 8.0 and VC++. I am forced to used foxpro data files. I have to display image which stored in general field, they are in JPEG binary format. Could you show me how to do that, please ?. Is it possible to implement user define functions to perform data manipulation, most UFL samples show date or string manupulation ?.

Regards,
Attawee:)

How the Runtime Databinding is done in Crystal Report?
Like in Data Report we are using Recordset for assigning values, or we are using Dataenvironment? It would be more helpful if you can give a small code related to it.

And how can we group the related data in it?

Another Question,

Can we Stop the Crystal Report printing in between after printing some specific lines of data. Like we are using Kill doc in VB Printer Object. Or can we specify/change the length and width of the page. I will be grateful if you can provide small code for it..

Thanking you

hi

i am facing problem refreshing data from the database using crviewer.

the report with database db1 is created with save data with report unchecked.

in vb during runtime i set the database to the user selected database(which has the same stucture as the db1) using Adodb.
the recordset does retrive all the data but
the data never refreshes only the field names which was originally there in the report is showed.

no errors.i am stuck with this problem

help please
roopa

Hi Babu,
Do you know how to connect to an Access 97 db with db level password using the Crystal RDC?

I am able to connect for other Crystal reports using just the CrystalReport viewer.

Any input would be appreciated. As always, thanks for your help.

Regards,
SB

Babu,
Never mind my question - I figured it out. Just in case you were interested this seems to work:

crpReport.Database.Tables(1).SetSessionInfo "", Chr(10) & "password"


SB

Hi K. Babu,
1)Does Crystal Reports for .NET contain all features as Crystal Reports 8.0 or 9.0 does ? I mean : support for SQL DB stored pictures display etc...
2)Is it possible to configure on run-time the Data source of my report, not only to change the LogOnInfo ? If so, how can I do that ?
Thanks.

Sorry, I could not serve all developers doubts for long time, because of my busy work.

Now, Iam little relax

Im trying to connect to Pervasive SQL data base. The report works fine except when I try to access it thru VB. I am also trying to use the CRviewer in VB. I can use this all just fine when using SQL and our normal databases. But now Im trying to create some reports for other departments. My code...

Dim CrxApp As New CRAXDRT.Application
Dim CrxRpt As CRAXDRT.Report

Private Sub Form_Load()
Dim rptfile As String

rptfile = "C:\CrystalReports\test5.rpt"
Set CrxRpt = CrxApp.OpenReport(rptfile)
CrxRpt.Database.LogOnServer "PDSODBC.DLL", "10.0.0.34", "DATABASE", "USERID", "PASSWORD"

CRViewer1.ReportSource = CrxRpt
CRViewer1.ViewReport
end sub

-----

The error I get is. "Server has not yet been Opened"

Is there a way to set this UserId and password in the report itself? or have I just got something wrong in the Logonserver line? Im totaly confused.

hi,

Try to set server username & password in direct ODBC DSN, which is available in coltrol panel.

Then we will go for next step.

Thanks
K.Babu

Quote:

---

Originally posted by JimB
Im trying to connect to Pervasive SQL data base. The report works fine except when I try to access it thru VB. I am also trying to use the CRviewer in VB. I can use this all just fine when using SQL and our normal databases. But now Im trying to create some reports for other departments. My code...

Dim CrxApp As New CRAXDRT.Application
Dim CrxRpt As CRAXDRT.Report

Private Sub Form_Load()
Dim rptfile As String

rptfile = "C:\CrystalReports\test5.rpt"
Set CrxRpt = CrxApp.OpenReport(rptfile)
CrxRpt.Database.LogOnServer "PDSODBC.DLL", "10.0.0.34", "DATABASE", "USERID", "PASSWORD"

CRViewer1.ReportSource = CrxRpt
CRViewer1.ViewReport
end sub

-----

The error I get is. "Server has not yet been Opened"

Is there a way to set this UserId and password in the report itself? or have I just got something wrong in the Logonserver line? Im totaly confused.

---

Thanks for suggestion. I tried setting Username and Password in Control Panel and am getting the same exact error. I did a little research and found that others are having the same problem with LogonServer.

Info at : http://support.crystaldecisions.com/...s/c2006666.asp

Sadly, thier suggestion of using this code instead :
Report.Database.Tables(1).SetLogOnInfo "server", "database", "UID", "PWD"
does not work either.

Our next attempt today is going to be to install CR and VB on the server and see if we can access and call it from there. I have my doubts about this as well, but at this point am willing to try.

Try first simple reports, and then step by step we will move all kind of reports.

K.Babu

Quote:

---

Originally posted by JimB
Thanks for suggestion. I tried setting Username and Password in Control Panel and am getting the same exact error. I did a little research and found that others are having the same problem with LogonServer.

Info at : http://support.crystaldecisions.com/...s/c2006666.asp

Sadly, thier suggestion of using this code instead :
Report.Database.Tables(1).SetLogOnInfo "server", "database", "UID", "PWD"
does not work either.

Our next attempt today is going to be to install CR and VB on the server and see if we can access and call it from there. I have my doubts about this as well, but at this point am willing to try.

---

The report we are trying to use is as about as simple as it gets. Just one file involved and only 5 fields.

What is weird is that I can access the file in VB thru data Environment, and even put fields in a listview.

I can also print the report and access all the data from Cystal reports developer no problem.

I can print any other report from all our other databases (we have several) that is NOT pervasive.

The only problem is when I try to access that particular report from VB.

I dont know what the solution is. I would be happy if it would let me access data even by inputting a password each time.

I was hoping there was a way to save the password info in the report itself, but I cant figure it out.

So far, we have had no success with VB and CR on the server either. Strange.

Thanks for you help...

use logoninfo without pwd and uid, if field is empty, it will prompt user name and password at run time.

K.Babu

crCommon.LogonInfo(0) = "dsn=;uid=;pwd=chennai_;dsq="

Quote:

---

Originally posted by JimB
The report we are trying to use is as about as simple as it gets. Just one file involved and only 5 fields.

What is weird is that I can access the file in VB thru data Environment, and even put fields in a listview.

I can also print the report and access all the data from Cystal reports developer no problem.

I can print any other report from all our other databases (we have several) that is NOT pervasive.

The only problem is when I try to access that particular report from VB.

I dont know what the solution is. I would be happy if it would let me access data even by inputting a password each time.

I was hoping there was a way to save the password info in the report itself, but I cant figure it out.

So far, we have had no success with VB and CR on the server either. Strange.

Thanks for you help...

---

Hi.

I have a problems with closing reports during run-time using Crystal Report Designer Component (RDC) from
Crystal Repotrs 8.5 with Visual C++ 6.0. In spite of I'm using VC++, the problem is not VC-related, so I will be glad even if you will show me how to do this in VB. I have the following member variables defined in my appilication CWinApp-derived
class:

IApplicationPtr m_pApplication;
IReportPtr m_pReport;
IFieldObjectPtr m_pobjDetail[3]; // fields pointers array for three objects
ITextObjectPtr m_pobjHeader[3]; // text pointers array for three objects
ITextObjectPtr m_pobjFooter; // fields pointer for report footer
CCrystalReportViewer4* m_pCryst;
CAdodc m_ctlADODC; // Microsoft ADO Data Control

At application startup I'm initializing m_pApplication and creating CCrystalReportViewer4 object:

...

m_pApplication.CreateInstance("CrystalRuntime.Application");
m_pCryst=new CCrystalReportViewer4;

...

After that I'm creating ADO Data Control window. When user selects a new database, I'm setting new
ADO record source and creating new report during run-time at the following manner:

ISectionPtr pSection,pHeaderSection,pFooterSection;
ISectionPtr pGroupSection;

...

// get reference to my ADO recordset
CAdodc& refADO=m_ctlADODC;
C_Recordset& rc=refADO.GetRecordset();

// creating a new report (***)
m_pReport=m_pApplication->NewReport();

// add database to a report (THE REASON OF MY HEADACHE)
m_pReport->Database->Tables->Add("",vTemp,_variant_t((IDispatch *)rc.m_lpDispatch,true),vTemp,"p2smon.dll");

// get the Detail section using "D" and Header section using "PH" as the index
pSection=m_pReport->Sections->GetItem("D");
pHeaderSection=m_pReport->Sections->GetItem("PH");
pFooterSection=m_pReport->Sections->GetItem("PF");

// add data to the report's Header section
m_pobjHeader[0]=pHeaderSection->AddTextObject("Field1",400,0);
m_pobjHeader[1]=pHeaderSection->AddTextObject("Field2",1100,0);
m_pobjHeader[2]=pHeaderSection->AddTextObject("Field3",2900,0);

// add data to the report's Detail section
m_pobjDetail[0]=pSection->AddFieldObject("{ado.Field1}",400,0);
m_pobjDetail[1]=pSection->AddFieldObject("{ado.Field2}",1100,0);
m_pobjDetail[2]=pSection->AddFieldObject("{ado.Field3}",2900,0);

// add data to the report's Footer section
_bstr_t bstrMessage("My report footer");
m_pobjFooter=pFooterSection->AddTextObject(bstrMessage,0,0);
::SysFreeString(bstrMessage);

// pass the report to the viewer and preview the report
m_pCryst->SetReportSource(NULL);
m_pCryst->SetReportSource(m_pReport);
m_pCryst->Zoom(100);
m_pCryst->ViewReport();

...

Above code works fine and I can see a valid report.
When user closes current database, I'm trying to close ADO recordset and report:

C_Recordset& rc=m_ctlADODC.GetRecordset();
if (rc.m_lpDispatch!=NULL) rc.Close(); // close recordset if it wasn't closed previously

// destroy footer since it doesn't refresh
pSection=m_pReport->Sections->GetItem("D");
pHeaderSection=m_pReport->Sections->GetItem("PH");
pFooterSection=m_pReport->Sections->GetItem("PF");
for (int j=0;j<3;j++) {
if (m_pobjHeader[j]!=NULL) pHeaderSection->DeleteObject(_variant_t(& *m_pobjHeader[j]));
if (m_pobjDetail[j]!=NULL) pSection->DeleteObject(_variant_t(& *m_pobjDetail[j]));
m_pobjHeader[j]=NULL; m_pobjDetail[j]=NULL;
}
if (m_pobjFooter!=NULL) pFooterSection->DeleteObject(_variant_t(& *m_pobjFooter));
m_pobjFooter=NULL;

// destroy report data
j=m_pReport->Database->Tables->GetCount();
while (j) {
m_pReport->Database->Tables->Delete(j);
j--;
}
m_pCryst->SetReportSource(NULL);
m_pCryst->DestroyWindow();
m_pReport->Release(); // HERE IS I'V GOT AN ERROR. HOW CAN I CLOSE OR
m_pReport=NULL; // DISCONNECT REPORT FROM ADO RECORDSET PROPERLY
// TO PREVENT DATABASE FROM STAYING LOCKED?

When I comment the last string ("m_pReport=NULL;"), the database stay locked and the error appear
during recreating report at line commented with "***" ("m_pReport=m_pApplication->NewReport();").
Could anybody advise how can I destroy created report properly (since there is no such method as
CloseReport at IApplicationPtr, or related method) to reuse the m_pReport for the next report and
prevent database from staying locked? Thank you very much!

P.S. Where can I get entire documentation on Crystal Report Designer Component (RDC)?

Close first crystal report after that close recordset and then close tables

example:

({[....]}) first open last close, second open second close, last open first close.

Try this sequence, that may slove your problem.

yours
K.Babu

Quote:

---

Originally posted by demask
Hi.

I have a problems with closing reports during run-time using Crystal Report Designer Component (RDC) from
Crystal Repotrs 8.5 with Visual C++ 6.0. In spite of I'm using VC++, the problem is not VC-related, so I will be glad even if you will show me how to do this in VB. I have the following member variables defined in my appilication CWinApp-derived
class:

IApplicationPtr m_pApplication;
IReportPtr m_pReport;
IFieldObjectPtr m_pobjDetail[3]; // fields pointers array for three objects
ITextObjectPtr m_pobjHeader[3]; // text pointers array for three objects
ITextObjectPtr m_pobjFooter; // fields pointer for report footer
CCrystalReportViewer4* m_pCryst;
CAdodc m_ctlADODC; // Microsoft ADO Data Control

At application startup I'm initializing m_pApplication and creating CCrystalReportViewer4 object:

...

m_pApplication.CreateInstance("CrystalRuntime.Application");
m_pCryst=new CCrystalReportViewer4;

...

After that I'm creating ADO Data Control window. When user selects a new database, I'm setting new
ADO record source and creating new report during run-time at the following manner:

ISectionPtr pSection,pHeaderSection,pFooterSection;
ISectionPtr pGroupSection;

...

// get reference to my ADO recordset
CAdodc& refADO=m_ctlADODC;
C_Recordset& rc=refADO.GetRecordset();

// creating a new report (***)
m_pReport=m_pApplication->NewReport();

// add database to a report (THE REASON OF MY HEADACHE)
m_pReport->Database->Tables->Add("",vTemp,_variant_t((IDispatch *)rc.m_lpDispatch,true),vTemp,"p2smon.dll");

// get the Detail section using "D" and Header section using "PH" as the index
pSection=m_pReport->Sections->GetItem("D");
pHeaderSection=m_pReport->Sections->GetItem("PH");
pFooterSection=m_pReport->Sections->GetItem("PF");

// add data to the report's Header section
m_pobjHeader[0]=pHeaderSection->AddTextObject("Field1",400,0);
m_pobjHeader[1]=pHeaderSection->AddTextObject("Field2",1100,0);
m_pobjHeader[2]=pHeaderSection->AddTextObject("Field3",2900,0);

// add data to the report's Detail section
m_pobjDetail[0]=pSection->AddFieldObject("{ado.Field1}",400,0);
m_pobjDetail[1]=pSection->AddFieldObject("{ado.Field2}",1100,0);
m_pobjDetail[2]=pSection->AddFieldObject("{ado.Field3}",2900,0);

// add data to the report's Footer section
_bstr_t bstrMessage("My report footer");
m_pobjFooter=pFooterSection->AddTextObject(bstrMessage,0,0);
::SysFreeString(bstrMessage);

// pass the report to the viewer and preview the report
m_pCryst->SetReportSource(NULL);
m_pCryst->SetReportSource(m_pReport);
m_pCryst->Zoom(100);
m_pCryst->ViewReport();

...

Above code works fine and I can see a valid report.
When user closes current database, I'm trying to close ADO recordset and report:

C_Recordset& rc=m_ctlADODC.GetRecordset();
if (rc.m_lpDispatch!=NULL) rc.Close(); // close recordset if it wasn't closed previously

// destroy footer since it doesn't refresh
pSection=m_pReport->Sections->GetItem("D");
pHeaderSection=m_pReport->Sections->GetItem("PH");
pFooterSection=m_pReport->Sections->GetItem("PF");
for (int j=0;j<3;j++) {
if (m_pobjHeader[j]!=NULL) pHeaderSection->DeleteObject(_variant_t(& *m_pobjHeader[j]));
if (m_pobjDetail[j]!=NULL) pSection->DeleteObject(_variant_t(& *m_pobjDetail[j]));
m_pobjHeader[j]=NULL; m_pobjDetail[j]=NULL;
}
if (m_pobjFooter!=NULL) pFooterSection->DeleteObject(_variant_t(& *m_pobjFooter));
m_pobjFooter=NULL;

// destroy report data
j=m_pReport->Database->Tables->GetCount();
while (j) {
m_pReport->Database->Tables->Delete(j);
j--;
}
m_pCryst->SetReportSource(NULL);
m_pCryst->DestroyWindow();
m_pReport->Release(); // HERE IS I'V GOT AN ERROR. HOW CAN I CLOSE OR
m_pReport=NULL; // DISCONNECT REPORT FROM ADO RECORDSET PROPERLY
// TO PREVENT DATABASE FROM STAYING LOCKED?

When I comment the last string ("m_pReport=NULL;"), the database stay locked and the error appear
during recreating report at line commented with "***" ("m_pReport=m_pApplication->NewReport();").
Could anybody advise how can I destroy created report properly (since there is no such method as
CloseReport at IApplicationPtr, or related method) to reuse the m_pReport for the next report and
prevent database from staying locked? Thank you very much!

P.S. Where can I get entire documentation on Crystal Report Designer Component (RDC)?

---

Hi,

I need to design a report. Most of the data are from one dataset. There is one field that comes from outside this dataset. I don't want to use two datasources in the report or combining two datasets into one source. I am considering to use unbounded field for this data. And assign a value to it programmatically. But I can't find info on how to do it.

Could ponit direction for me? Is unbounded fiels a good solution for the case?

Thanks very much.

Glen Chen

Hi,:

I am using crystal report visual studio.net, asp.net with c#. Crystal report creates a parameter field autmatically when I create a linked subreport. How do I retrive value of the parameter field from ASP.Net code ?

Thanks.

hai babu,

i am using crystal reports 4.5. i want to pass a value from vb , which is the number records per page in crystal reports.

so how to?

thank u
sthota

if you want to restrict number of lines per page, you don't need to pass the value from vb, you can set directly from crystal report design time, leave blank space at page footer group, this will reduce number of records per page.

yours,
Babu

Quote:

---

Originally posted by sthota
hai babu,

i am using crystal reports 4.5. i want to pass a value from vb , which is the number records per page in crystal reports.

so how to?

thank u
sthota

---

hai babu,

thank you very much for ur reply. but in my application user will select the number of lines per page. based on that i have to show report.

that is the problem. due to this, i cannot fix the report by increasing the page footer. so what should i do now?

thank u
sthota