Should be simple but...

  • Thread starter Thread starter bborza
  • Start date Start date
B

bborza

What I am trying to do is to create a report which is a mailer. What
that means is I am creating pages to be sent out as letters.

One page per client.

Where this is tricky for me is that I need to display a Pivot Table on
the report based on what the client id is.

So I do a query to find the client id's and then I need to pass the
client id into another query which will return back my pivot table. I
think that the pivot needs to be a subreport but I am not sure.

I have tried to do this many different ways but have been unsuccessful.
 
It is possible to create a subreport based on a crosstab query. This is most
easily done if you can enter all the possible column names into the column
headings property.

Depending on your needs, you can use link master/child to limit the
subreport records.
 
Back
Top