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.
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.