Crystal Report

**K.Babu** · July 5th, 2002, 12:39 AM

hi,

When user click the link, change the link font color.

after color changes, you can identify the link previously read or not read refer by color, then do process what you need.

K.Babu

**pavankiran** · July 5th, 2002, 01:17 AM

Thanks for your reply...

No.., the processing i was talking about is read the data in the section.

This is like i have some data displayed on the report that is group by a field and has a subreport link, something like 'Details' link. Now i have to send the data to the subreport so that i can display the details. I can use subreport links options.. to link the data in the main report to and display the subreport, but this doesn't work for me. The only option for me is to identify the record on which he is intrested in. So is there any way to read that data.

Eg: Record will be like this

Cust Name: somename
Age: xx

View Details

I need to show details for the cust name, i can't link custname from the main report to subreport, my reqirement doesn't permit that. Now when user clicks subreport i need to identify the cust name he is intrested in. If i can get that..... my problem is solved.
I have been trying to get that.. and iam successful in getting custname in the first page using the 'index' parameter in DrillOnSubreport event. But from the second page the 'index' start from 1 again.

so any ideas...

Thanks once again..
kiran.

**debuchakrabarty** · July 15th, 2002, 12:17 AM

Hi Babu,

You indeed are doing a great job.

Please help me solve this problem.

I am using Crystal report 6.0. I have a master table (Employee Master) and several detail tables (EmployeeEducationDetails, EmployeeQualificationDetail, EmployeeTrainingDetail etc). Now I want to prepare a report where I pass the Employee ID as parameter and the report should display, in a Resume format, all Employee Details.

Problem is : there is only one detail section on the report so how would I display data from all the different Detail tables (there are 4 such detail tables). I tried grouyping the data (By qualification etc) but that did not help. Will I have to use Sub-reports?

**stealbreeze** · July 21st, 2002, 03:50 PM

Originally posted by K.Babu
hi,

create formulas names in crystal report design time.

eg. EmpName
EmpDesignation

vbcode:

cr.formulas(0) = "EmpName = 'Babu'"
cr.formulas(1) = "EmpDesignation = 'Programmer'"

if you had input variables use bellow code:

cr.formulas(0) = "EmpName = '" & svEmpname & "'"

K.Babu

K.Babu,
Your solution (using 'formula' fields) works for passing values to show in the crystal report. How do I pass values to represent the 'parameter' fields that the report is using in the selection criteria?
I have a crystal report with 'parameter' fields for the date range that the report is using in the selection criteria. I want to bypass the default form for using input of the parameters, and use a custom form for the user to pass 'parameter' values to the report to be run.

Any suggestions?

Thanks,
SB

**Zapotec** · July 23rd, 2002, 02:57 PM

cr_Report.Database.SetDataSource rs_Report

Using that line returns the entire contents of the query table instead of
the items in the query.

If I assign the recordset to an array the array contains ONLY the items I
requested but when I assign the same recordset to the crystal report it contains
ALL the items in the table.

Any help would be greatly appreciated.

Thanks,

Mike

**Cimperiali** · July 23rd, 2002, 03:17 PM

try giving some stars here....

**lsmeteor** · July 26th, 2002, 10:50 AM

Hi,

I have a more CR rquestion not really relating to VB.
Do you know what the maximum number of detail sections/sub-sections we are allowed in a report?
I heard something about 622 sections... but not sure.

TIA

Cheers,
Laurent

**stealbreeze** · September 3rd, 2002, 01:03 PM

Hi,
In VB, how do you specify the datasource for a subreport in Crystal?

For example, I use the following code to specify the datasource for the Crystal report:
CrystalReport1.DataFiles(0) = strDataBaseName

I need to specify the datasource (same database) for the subreport within this same Crystal report.

Any help will be appreciated.

Regards,
SB

**K.Babu** · September 3rd, 2002, 10:06 PM

hi,

Try this.

CrystalReport1.DataFiles(0) = strDataBaseName
CrystalReport1.DataFiles(1) = strDataBaseNameNext

Babu

**stealbreeze** · September 3rd, 2002, 10:37 PM

Hi,
I tried your code:

CrystalReport1.DataFiles(0) = gDataBaseName
CrystalReport1.DataFiles(1) = gDataBaseName 'It is the same DB as the Main Report

I get the following error:

---------------------------
Seagate Crystal Reports: Database Error
---------------------------
Error opening file.

File could not be found: "TransLog", at file location: "TransLog"
---------------------------
OK
---------------------------

"TransLog" is the name of the table in the DB that the Subreport is using.

Any other suggestions?

Thanks
SB

**K.Babu** · September 3rd, 2002, 10:56 PM

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

**stealbreeze** · September 3rd, 2002, 11:14 PM

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

**K.Babu** · September 3rd, 2002, 11:29 PM

hi,

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

For testing.

**K.Babu** · September 5th, 2002, 02:29 AM

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

**debuchakrabarty** · September 5th, 2002, 03:05 AM

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!