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
Printable View
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
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.
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?
K.Babu,Quote:
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
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
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
try giving some stars here....;)
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
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
hi,
Try this.
CrystalReport1.DataFiles(0) = strDataBaseName
CrystalReport1.DataFiles(1) = strDataBaseNameNext
Babu
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
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!