Skip to Content
0
Former Member
Apr 28, 2014 at 06:37 AM

Crystal reports links tab

83 Views

Please suggest me to get this requirement.

I have a report where I need show data wise sites.Suppose if I click on particular date it should show respected sites.

The date field is coming from different query and sites info is coming from diff query.

Now I need to pass this date field as a parameter to 2nd query.But due to some limitation(nested sub reports) I am not using sub report approach. I am using drill down concept.

So I have taken both queries in one report only and I written a sub query in 2nd query to get 1st queries date .

Now I am displaying the date parameter in 2nd query as a column. Now I have date columns in both the queries.

Now what is my doubt is whether I need to link both the queries date fields in links tab(As I need to show sites coming from 2nd query by clicking date field coming from 1st query) .

Please suggest .