I had a similar situation so I hope someone answers. I tried to solve it
this way and it worked except it wont export correctly to excel and wont show
detail in pdf format unless I have all levels expanded. I created a table
.... similar to yours ... which has a group for each system which summarizes
data for a that system - total outages, total minutes down, total timeouts,
Percent Available
then I created another group and merged the cells in that group header
together and pasted another table inside that cell. The second table
contained all the detail for the summarized data that I mentioned above - the
detail for each outage for that system (start date, end date, duration of
outage). I had it set up to toggle the detail based on system name which was
cool ... you could view just the summary information or drill down to the
detail. Like I said ... the problem is that they need to be able to export
and print the summary followed by the detail. That didnt work at all for
excel (data areas embedded within a table or matrix are ignored on export)
and pdf format ... well that worked as long as they expanded all the groups
before exporting.
SOOOO .... I am hoping that someone can help with this
[quoted text, click to view] "Tony" wrote:
>
> I want to design a Report to print out all of our existing customer.
>
> Also, Quotation, Sales Order and Payment history for each customer is needed
> to show in the report.
>
> I try to use table in report to print out the customer data. Is ok!
> But I don't know how to print out the Quotation, Sales Order and Payment
> history corresponding to each customer!
>
> Thank You
Hi MJT,
Yes, we face same problem! But I try to use easy way to fix it. I use
subreport to print the Quotation, Sales Order ... information.
It looks ok when the report in previw. However
when print out in pdf format, the subreport will go down to next new page
when "it" find out there is not enough page to print the subreport. Then the
output will be a lot of space in page 1 !!!!! :<
when print out in excel, all subreport cannot be export. It show "ignore
database / matrix within the table cell in subreport" (something like that
because I try to transale it from Chinese.
Anyone cane help me!!!!!!!!!!!!!!!!!!!!!!!!
[quoted text, click to view] "MJT" wrote:
> I had a similar situation so I hope someone answers. I tried to solve it
> this way and it worked except it wont export correctly to excel and wont show
> detail in pdf format unless I have all levels expanded. I created a table
> ... similar to yours ... which has a group for each system which summarizes
> data for a that system - total outages, total minutes down, total timeouts,
> Percent Available
> then I created another group and merged the cells in that group header
> together and pasted another table inside that cell. The second table
> contained all the detail for the summarized data that I mentioned above - the
> detail for each outage for that system (start date, end date, duration of
> outage). I had it set up to toggle the detail based on system name which was
> cool ... you could view just the summary information or drill down to the
> detail. Like I said ... the problem is that they need to be able to export
> and print the summary followed by the detail. That didnt work at all for
> excel (data areas embedded within a table or matrix are ignored on export)
> and pdf format ... well that worked as long as they expanded all the groups
> before exporting.
>
> SOOOO .... I am hoping that someone can help with this
>
> "Tony" wrote:
>
> >
> > I want to design a Report to print out all of our existing customer.
> >
> > Also, Quotation, Sales Order and Payment history for each customer is needed
> > to show in the report.
> >
> > I try to use table in report to print out the customer data. Is ok!
> > But I don't know how to print out the Quotation, Sales Order and Payment
> > history corresponding to each customer!
> >
> > Thank You
Don't see what you're looking for? Try a search.
