May 1, 2009 at 6:48 am
I have a matrix report(dashboard report), with appointment counts for each day. If we click on the appointment counts, all the details should show up. I have created this detailed report. Now I am trying to find out how I can link this detailed report(subreport) to the main report.
The following are the parameters of the main report and the detailed report(subreport):
1. The main report has startdate(datetime),enddate(datetime) and doctor-UNIQUEIDENTIFIER datatype as parameter.
2. detailed report has startdate(datetime), enddate(datetime) and doctor-varchar datatype as parameters.
Please let me know how I can do this. Thanks.
May 1, 2009 at 8:32 am
Mh (5/1/2009)
I have a matrix report(dashboard report), with appointment counts for each day. If we click on the appointment counts, all the details should show up. I have created this detailed report. Now I am trying to find out how I can link this detailed report(subreport) to the main report.The following are the parameters of the main report and the detailed report(subreport):
1. The main report has startdate(datetime),enddate(datetime) and doctor-UNIQUEIDENTIFIER datatype as parameter.
2. detailed report has startdate(datetime), enddate(datetime) and doctor-varchar datatype as parameters.
Please let me know how I can do this. Thanks.
IS the Doctor - GUID and the Doctor - Varchar the same value just stored in 2 different datatypes? all you should need to do is convert one of them and you'll be fine.
In your Subreport properties you could set @doctorID = Cstr(your doc-guid value)
-Luke.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply