Friday, March 9, 2012

Matrix / Table Combo

Hello,
I have an request that is throwing me for a loop. The user is asking
for a report that provides purchasing amounts by months for the last
15 months, then asking for summary stats from different tables, i.e
sales, cogs and inventory. Normally I would use a matrix report to
present the 15 months of data. I could use sub queries to retrieve
all
the columns that are needed, but I was hoping there was a simpler
solution. Any thoughts or suggestions would be greatly appreciated.
R/ AnthonyOn Jan 29, 4:14 pm, awakin <a...@.ibtinc.com> wrote:
> Hello,
> I have an request that is throwing me for a loop. The user is asking
> for a report that provides purchasing amounts by months for the last
> 15 months, then asking for summary stats from different tables, i.e
> sales, cogs and inventory. Normally I would use a matrix report to
> present the 15 months of data. I could use sub queries to retrieve
> all
> the columns that are needed, but I was hoping there was a simpler
> solution. Any thoughts or suggestions would be greatly appreciated.
> R/ Anthony
As you eluded to, you could use a nested table in a matrix control.
One alternative would be to nest a subreport in the matrix control and
pass parameters, where necessary, from the matrix control to the
subreport. Also, you could use Jump to Report in the navigation
properties of a cell in the matrix control to jump to another report
and pass parameters where necessary. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

No comments:

Post a Comment