Crystal Report

Babu,
My VB6 program uses CRE8 for reporting. I just upgraded to Crystal 9. Do you know of any easy ways to migrate to RAS from RDC?

Regards,
SB

Quote:

---

Originally posted by K.Babu
Dear All,

If you have any doubt in Seagate Crystal Reports contact me, i will help you my level best.

Babu


Present EMail : [email protected]
Permanent EMail : [email protected]
WebSite : qmaxtest.com

---

Hi

I've VB6.0 Enterprise Edition and Crystal Reports 7 installed. I'm currently doing a project in VB and i wish to have Crystal Reports to be my reporting tool.

However, there are several reports to be done in the project around 35 reports. Now if I create all 35 reports it makes my setup program larger.

Hence I would like to have only one reprt file in my project and should be able to pass the relevant source and column positioning from my vb code.

I thought that it may be done using crystal report engine but I dont know where to find it.Can you please help me regarding this, if this is possible

Thanx in Advance

Hi,
I designed a crystal report with the pull method and display it in the web browser using the
crystal report viewer control. During run time, I am setting the login id
and password. I am able to view the report in the browser. However I am
noticing that each time I view the report in the browser, a connection
with a sleeping status is left open in the database. Eventually I max out
of connections and login failed error is displayed in the browser.

I am using SQL Server 6.5. (does this have anything to do with the problem??)

The following is my code. Please tell me what I am doing wrong. Why are
the database connections left open?

Dim paramFields As ParameterFields
Dim paramField As ParameterField
Dim curValues As ParameterValues
Dim discreteValue As ParameterDiscreteValue
Dim dtReleased As String
dtReleased = Request("dtRel")

CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.SeparatePages = False
CrystalReportViewer1.DisplayToolbar = False

CrystalReportViewer1.ReportSource = Server.MapPath("Reports\claims.rpt")

CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.ServerName =
"serverName"
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.UserID = "UID"
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.Password = "pwd"
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.DatabaseName =
"dbName"

paramFields = CrystalReportViewer1.ParameterFieldInfo
paramField = paramFields("ReportDate")
curValues = paramField.CurrentValues
discreteValue = New ParameterDiscreteValue
discreteValue.Value = dtReleased
curValues.Add(discreteValue)
CrystalReportViewer1.ParameterFieldInfo = paramFields

paramFields = Nothing
curValues = Nothing
paramField = Nothing
discreteValue = Nothing

CrystalReportViewer1.Dispose()
CrystalReportViewer1 = Nothing
DataBind()

Based on an article that can be found at http://support.crystaldecisions.com/...s/c2010371.asp
I changed my code to the following but still encountered the same problem of running out of database connections.
I posted to the Crystal Report support team and yet to hear back from them. But If someone knows what's going on here, I would appreciate your response very much.

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
InitializeComponent()
crReportDocument = New ClaimsRpt
With crConnectionInfo
.ServerName = "srvName"
.DatabaseName = "dbN"
.UserID = "Uid"
.Password = "pwd"
End With
CrTables = crReportDocument.Database.Tables
For Each CrTable In CrTables
crtableLogoninfo = CrTable.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next
discreteValue = New ParameterDiscreteValue
discreteValue.Value = "8/5/2003"
crReportDocument.SetParameterValue("ReportDate", discreteValue)
CrystalReportViewer1.ReportSource = crReportDocument
End Sub

I also tried setting every reference to Nothing but still the problem remains

Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Unload
crReportDocument.Close()
crReportDocument.Dispose()
crReportDocument = Nothing
crtableLogoninfos.Clear()
crtableLogoninfos = Nothing
crtableLogoninfo = Nothing
crConnectionInfo = Nothing
CrTables = Nothing
CrTable = Nothing
discreteValue = Nothing
CrystalReportViewer1.Dispose()
CrystalReportViewer1 = Nothing
End Sub

Thanks

Hello,

How can I concatenate data in a field? Example, I got an output of data that print out on the report as one data per row:
20
25
41
56
and I want it to look like
20, 25, 41, 56

The number of data in the field various.

Thanks.

Hi,
I need to email the report using VB how can i do that ?

I created a payslip for each employee using crystal report i want to email each employee its own payslip without need to print it how can i do that using VB ?

I am new to crystal reports so plz help me.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted.

Ideas?

Thank you in advance.

++Roddy

I am new to crystal reports so plz help me.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted. (Ie, no NULL's and no blank lines.)

Ideas?

Thank you in advance.

++Roddy

Hi,

Enable Supress Blank Lines in section format

Thanks.

Quote:

---

Originally posted by Roddy
I am new to crystal reports so plz help me.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted. (Ie, no NULL's and no blank lines.)

Ideas?

Thank you in advance.

++Roddy

---

Babu,

I posted this earlier on the main page, I'm hoping you may be able to help me with this. I looked through your responses and didn't find anything that matched this problem:


Can you pass a formula from a SubReport back to a main report?

I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.
The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.
Any help will be appreciated.

Thanks

Hi Babu, Hi All

I am VB-Developer and I Designed a large set of Reports which are accessed from a VB-Application and a ISAPI Application ... works very good.

Well, now we get multilingual, and this Reports should this functionality too.

I implemented this functionality in that way:
I open a Report in the Runtime DesigneComponent (8.5) and I replace the translated text in all TextObjects.

Works fine too ... but unless I have to Replace The Text in a TextObject, which includes at least one Field object.

TextObject-Example with including FieldObject (View in the ReportDesigner):
"Your Invoice No. [InVoiceNo] amounts [Amount] EURO."

I had no chance to get any info about this extendet Properties of a TextObject.

The only chance i have is the Text-Property of the TextObject. But this only replies (for the example I mentioned) the Value: "Your Invoice No. [] amounts [] EURO."


My Question is: How can I cance the Text in an extendet Textbox, without loosing the including FieldObjects?

Hi - just posted a CrystalReport thread at
http://www.codeguru.com/forum/showth...hreadid=260497
Meant to add it to this thread but it went to VB programming...

Hi Confucius,

you can easyly solve your problem with shared variables, which are valid within MainReport and SubReports.

Do it this way:

use a Formula in head of the MainReport:
Shared currencyVar x := 0;


a Formula at end of your SubReport :
Shared currencyVar x ;
x = {@Amount}

and a Formula on the place in the MainReport, where you need the Sum:

Shared currencyVar x ;
x

All this are Crystal-Syntax
____________________________
Confucius
Junior Member

Registered: Jul 2003
Location: I'm Here!
Posts: 23
Babu,

I posted this earlier on the main page, I'm hoping you may be able to help me with this. I looked through your responses and didn't find anything that matched this problem:


Can you pass a formula from a SubReport back to a main report?

I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.
The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.
Any help will be appreciated.

Thanks

Sorry i forgot to mention that you have to declare the variable in every Formula, in which you need it.
But it has the last value which was assigned.

Shared Variables have the sane memory area for a variable in Report-SubReports.

Thanks Duman, I'll give it a shot.

Hi,

The Output what you have shown is one column with many rows... ... Right ?

One small solution can be given: see to that how you use to your situation..

1. Group that Column
2. If needed no data's can be displayed in that Group.
3. Create a Formula. Inside the formula, introduce a Variable and concatenate that Field values.

4. In Group Footer Show that Formula.


Just check with this. If not just attach your .Rpt files. Let me solve it, if possible..

Okay, Just try with the above Solu:

Alll the Best !!!

Quote:

---

Originally posted by Shinyee
Hello,

How can I concatenate data in a field? Example, I got an output of data that print out on the report as one data per row:
20
25
41
56
and I want it to look like
20, 25, 41, 56

The number of data in the field various.

Thanks.

---

Hi,

Iam creating an Report using Crystal Report. In the Formula Editor a get this error

"The remaining text does not appear to be part of the Formula":


Check the Attachment for clear understanding:

Do reply for this.... !!! :confused: and :(

thank U!!

I have created a crystal SQL queire to select my data for a report however when I use the queire in the report I only get the option to group by the numeric feilds where as when I make a connection to the data base through the report I can chose any feild to group by.
Also if I create a report using a specific database can that be changed using a VB or Borland builder to change the source location.

Hi,

For VS2002 they used to build a runtime for the subject with the following megre modules:
managed.msm
database_access.msm
database_access_enu.msm
regwiz.msm
VC_CRT.msm
VC_STL.msm
It was also a known issue about ATL.msm, which updated atl.dll, in orderd to eliminate the Load report failed error. All this used to work fine, until I was forced to upgrade to VS2003. I discovered, that the names of all the merge modules had changed, but tried my best guess:
Crystal_Database_Access2003.msm
Crystal_Database_Access2003_enu.msm
Crystal_Managed2003.msm
Crystal_regwiz2003.msm
VC_User_ATL71_RTL_X86_---.msm
VC_User_CRT71_RTL_X86_---.msm
VC_User_STL71_RTL_X86_---.msm
However, this leaves me with the Load report failed error. I tried to find the atl.dll on the target system, and found atl.dll in the system directory (the old one, I suspect), and some atl71.dll in the Application Folder of the installation. To me this looks a bit suspicious, but I can guess no further. Will anybody who knows for certain please help? BTW, the target system is w98.

Grateful in advance, Alexey

Hi robot96

the onyl fieldtype you cant group on is MEMO.

If you still want to Group on that fields, convert them in your SQL-Clause as Varchar.

Quote:

---

Originally posted by robot96
I have created a crystal SQL queire to select my data for a report however when I use the queire in the report I only get the option to group by the numeric feilds where as when I make a connection to the data base through the report I can chose any feild to group by.
Also if I create a report using a specific database can that be changed using a VB or Borland builder to change the source location.

---

About 1 month ago I demonstrated an application written in VB.

In this software I included crystal reports, because the standard reports don't have that kind of functionality.

Now the demo went really fine, no issues or such things. I did not change anything to the application, BUT, now when I wanted to install the full application, the reports don't wanna work.

1. I get the error: 'Physical Database not found!'
2. The report references a location eg. 'c:\program files\app\app.mdb
3. This report is using the CRViewer control, and the actual report designed in VB -> 'Designers'...

For some reason the reports don't wanna see the Database, BUT the actual Database, is refelecting, at the location, that the report points to, I have verified the Database, and I also made sure to set the location of the report to the directory where the report resides...

I am using the MyReport.DataSource = (ado recordset). (As explained by Crystal Reports, this actually did work). But now it does not work....?

Question: Is there maybe a property that I can use to programmatically "Set" the report's database location?

Please help this is urgent .....

Thanx in advance...

xIRC

Set PreviewReport = New CrystalReportInvoice

PreviewReport.Database.SetDataSource adoMainRecordSet
CRViewerReport.ReportSource = PreviewReport

CRViewerReport.ViewReport


adoMainRecordSet <- points to my recordset, but for some reason this aint working anymore, it used to ... ?

I also did re-install crystal reports, but it's the same version, with the same setup feautures, also installed it fully .... ?

Hi,

Iam using Crystal Report for Accounts Project, In that we have Balance Sheet : format sample


-----------------------------------------------------------------
Liability | Asset
-----------------------------------------------------------------
Share Capital XXXX Fixed Asset XXXX
Loans XXXX Investment XXXX
C.Liability XXXX C.Asset XXXX

-----------------------------------------------------------------
XXXX XXXX
-----------------------------------------------------------------

The Values for the first line is not in first record. Each and every item will be a record.

Solution for this, required ..... Thank You..

Soundar

I am using Crystal Reports through a Rational product - ClearQuest. All fields have been defined in ClearQuest and I just insert the field objects in the report design. The fields that I use are of type text and vary in their size (and could be 1 line or 50 lines). When I place these fields one below the other, they get overwritten. The second field that comes below the first one should start a couple of lines on completion of the first one.
What should I do to prevent this?

Hello Babu,
I am new in programming, especially in Crystal Reports! From a web form, I am sending few parametrs to another web form where I will use them to create a crystal report.

I have the database connection, parametrs and evrything added for Crystal report to be generated, but an user can select only 1 choice and 1 parameter can be sent to the other form. Maybe all 3 choices or different combinations of 2 parameters!

How do I write or where do I put the logic for crystal report to expect different numbers of parameters?
I thought Crystal Report was simple, but it's making me crazy.


Right now, I have a report set up that requires all 3 parametrs.

I need to create reports, according to what user selects! With 1 , 2 or all 3 parameters. Also sorting by a certain parameter.
One more thing, I need to display the report in .PDF format in webform. (vb.net)

Please help. Thanks in advance.

The project I created in VB 6, using MS Access.

Now redistributing this project to a client's PC works fine. I use the MDAC version 2.6. I created an installation file, and installed the application on the client's PC. I used the standard references, to dll included by the setup wizard. This works fine.

Now testing the application on the client's PC this actually run 100% fine, until I reach the reports, then I get the error: "Physical database not found.". This error, is 'caused by some dll files not being included on the client's PC. Now using Crystal reports I use, the RDC Model, and it's v 8.0. So I read up on this, and included these files on the client's pc, and it worked ... it got past this error. At this stage I'm faced with another error. "Can not create DAO DBEngine". I went on to install MS Access on the client's PC, and tested the application once more. It worked :)

My question stand at, this stage, according to Crystal Reports one needs to include 3 .dll files for this to work, when Access IS present. But what happens when the client does not have MS Access, installed, and he/she won't be able to install MS Access, remember the application does work when comunicating with the .mdb file. it's only the reports not working, so I thought this must be .dll files from Crystal Reports itself that I also need to distribute with the installation CD ????

Any help on this, I did read an article explaining this, but I tried that, and it did not work ...

Thanx in advance ...

xIRC

I would like to know how can I do printing, by scaping the preview. I'M currently using Crystal Report 8.5. IF I do printing without doing the preview, I dont get any data that should repect in my prinout.

Greetings Babu -

I was wondering if you could help me with some dynamic reporting issues that I have at the moment. I am working in C#, and am currently designing a program that will pull data from a SQL table (most likely into a dataset, so that each query run won't have the total roundtrip cost...I am still looking into it), and then allow the user to select to query the data using either pre-created queries, or by creating their own, and then selecting the report that they would like to see the data displayed in.

My problem is this - I have seen the dynamic report example for C#, and I can see what is being done in the code, but I do not understand how to create Formulas and such with the report designer that will allow me to pass parameters from the user into the report.

So: I have the application- / programming-level knowledge to utilize a user-defined field, but I do not know how to actually create the field within the Crystal Reports Designer included with .NET 2003. Can you help me with this?

Many thanks for your time.

Ciao,
Garret

Hi,

You have to install ODBC Data Source to your client machine, it's free download available in microsoft, make sure the file name MDAC_TYP.exe version 2.6.

so, you no need to install ms access.

yours friendly,
K.Babu

Quote:

---

Originally posted by xIRC
The project I created in VB 6, using MS Access.

Now redistributing this project to a client's PC works fine. I use the MDAC version 2.6. I created an installation file, and installed the application on the client's PC. I used the standard references, to dll included by the setup wizard. This works fine.

Now testing the application on the client's PC this actually run 100% fine, until I reach the reports, then I get the error: "Physical database not found.". This error, is 'caused by some dll files not being included on the client's PC. Now using Crystal reports I use, the RDC Model, and it's v 8.0. So I read up on this, and included these files on the client's pc, and it worked ... it got past this error. At this stage I'm faced with another error. "Can not create DAO DBEngine". I went on to install MS Access on the client's PC, and tested the application once more. It worked :)

My question stand at, this stage, according to Crystal Reports one needs to include 3 .dll files for this to work, when Access IS present. But what happens when the client does not have MS Access, installed, and he/she won't be able to install MS Access, remember the application does work when comunicating with the .mdb file. it's only the reports not working, so I thought this must be .dll files from Crystal Reports itself that I also need to distribute with the installation CD ????

Any help on this, I did read an article explaining this, but I tried that, and it did not work ...

Thanx in advance ...

xIRC

---

Dear Friends,

The following files are required at runtime, when using Crystal ActiveX Control Version 8.0

CRYSTL32.OCX Crystal Reports ActiveX Control
MFCANS32.DLL OLE2ANSI Library
OLEPRO32.DLL OLE Property Support DLL
CRPE32.DLL Interface to the Crystal Report Engine
CRPAIG80.DLL Crystal Reports text object support
IMPLODE.DLL Compression Library
MFC42.DLL Microsoft Foundation Class Libraries
MSVCIRT.DLL Runtime Library
MSVCP60.DLL Runtime Library

You have to register crystl32.ocx using with regsvr32.exe.

Thanks,
K.Babu

I have reports in my visual basic project and i but database oben by code in project to example server1
and also when create reports i assign server1 to report in my project
but how i can change from server1 to another server have the same database and tables and everything without gfo to each report to change server name

Hi,

1. From your vb application Which method you are using to access the crystal report engine?

2. What type of backend you want to connect (Backend Name)?

3. crystal report version?

4. Paste your sample code of connection database source?

Thanks
K.Babu

Quote:

---

Originally posted by fahedksa
I have reports in my visual basic project and i but database oben by code in project to example server1
and also when create reports i assign server1 to report in my project
but how i can change from server1 to another server have the same database and tables and everything without gfo to each report to change server name

---

Dear Friends,

I received more emails regarding problem while crystal report export to PDF format.

This problem happens when distribute the vb application using with crystal report to client machine.

This problem may occurs file missing (PDF export relation) or not registered properly in windows.

Export PDF format (Crystal Report Ver 8.0)
Following files are required run time.

CRXF_PDF.DLL PDF format.
EXPORTMODELLER.DLL Creates a representation of the Crystal Encapsulated Page Format (EPF). The representation is used by the export format DLL as a basis when translating to it’s own format.
CRTSLV.DLL Used by EXPORTMODELLER.DLL to process the EPF.

Note: ExportModeller.dll and Crtslv.dll should regester using with regsvr32.exe


Thanks
K.Babu

1-The code i use to connect visual basic to SQL Database

DB.Open "Provider=sqloledb;Data Source=server1;
initial Catalog=stock;Persist Security Info=False;
Integrated Security=SSPI"


then i can use deal with my projrct without any problem here.


2-Connect database to crystal report
i assign the databsed in report by choosing the oledbsql from add database
to report and thats it.


My problem as i said is :
my report work fine with my project ,when i was initalize these report
i but sql server (Server1) and to these points every thing Ok.

But if i want change from server1 to server3 should i go to all
reports to do these.


I use crystal report 8.5
O.S XP,2000
Visual Basic 6

hi babu !

please help me,,,am still a newbie in crystal reports.
i want to ask what particular control should i use in a form to run a crystal report,,, the crviewer seems to have a problem. i get an error when registering the crystl32.ocx

if you can discuss to me how should i start..please! thanks very much in advance! ;)

zhel

I am using VB.NET. Firstly I created a crystal report(a rpt file) in it, Then I created a new form, where I drag teh crystal report viewer into the new form. Then I link the souce of the rpt file to the database which I want to retrive the data from.
But when I ran the report, I could only see the table with the fields..no data appeared. What is the problem?

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.

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

Hey Babu
Two quite urgent questions!
First I have created a CR from a ADO.Net Dataset (filled using a ODBC connection and DataAdapter) and I am passing it to the Report.... at first everything is working fine but when I want to refresh the Report every Minute the changes in the Dataset do not occur in the ReportViewer.
Could you give me a hint why this problem appears?
Secondly I have to report the results from 7 Machines and not every machine returns a result at runtime, still I want to have seven parts on the x-axis. Is that possible?
Thanks a lot
joule

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...

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

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

---

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

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

Hi,
I want to dynamiclly load several datasets.
Make graph on crystalreport changing by different datasets.
How to handle in C#?
Thanks!

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

---

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

hi,Babu
How to set
ReportDocument.DataDefinition.SortFields[0].Field.FormulaName
like "Sum({Table.column1},{Table.column2})" , and Field.kind like SummaryField in Code.
I am so puzzled.

Thanks very much

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

Hello,

I have two subreports and merged them in a main report. I need to get the Grand Total from both the subreports and pass them into third subreport and also place it in the main report.. hope I am not confusing, :-)

Sub-Report1 having debit/credit column for some activites
Sub-Report2 having debit/credit coulmn for some other activites

MainReport = subreport1 + subreport2

I need to include the Grand Total from both subreport1 + subreport2 and place it in the main report.

How can i achieve this. Pls reply

Thanks
Thiyagu

Hi all,

I want to ask all of you a problems.
I using VB6 + Crystal Reports 8.5.
In my VB application, I make a report which developed Crystal Reports. In screen report, I export this report to Microsoft Word.
My problem is my report designed is nice, have rows and columns, but they disappear in word file that I exported.
I'm newbie VB and CR. I dont know how to be exported file has rows and cols as designed report.
Maybe this problems not be in VB, it is in CR.


For example, my report as
|----------------------------------------|
|ID | CustomerName | Date |
|-----|----------------------|-----------|
|001| David James | 10/9/03 |
|-----|----------------------|------------|
|002| Lam nguyen | 11/8/03 |
|-----|----------------------|------------|
|003 | Yamamoto | 7/20/03 |
|-----------------------------------------|

Exported word file is:

ID CustomerName Date

001 David James 10/9/03
002 Lam nguyen 11/8/03
003 Yamamoto 7/20/03

rows and cols disappeared in exported Word file.

What do I do to format of word file as in my report

Any hints are appreciate.

lam0620.