Using results from main reports in search criteria of sub report

[dacards]

Using Crystal 10

In short, I'm curious how to use results from your main report to drive the search criteria in the sub report. Not sure if this is even possible.

We're connecting to Remedy DB but we're unable to do joins on the fly, so we have to create Join forms within Remedy to pull this data.

My Main Report simply has the following search criteria:

{Create Date}=lastfullweek and
{Assigned Group}="Care"

From this I then get a list of ticket #s that were assigned to "Care". The data that I then need to grab has parameters around comment types.

I would like the subreport to pull any ticket number that matches a ticket number in the main report and where the {Change Type}="Comment Type".

Hopefully my post make sense, plesae let me know if i can add more. I've searched other threads and can't find a similar post.

Thanks again.

 

[Turkbear]

Hi,
You can link the subreport by Ticket Number and set an additional record selection in the sub to handle the {change Type} = "Comment Type"





To Paraphrase:"The Help you get is proportional to the Help you give.."