Last post Aug 24, 2012 01:49 AM by Ajay2707
Aug 09, 2012 10:48 PM|Musikero11|LINK
I know that crosstabs are just for summaries. But is it possible to use a crosstab for daily reports given two dates? It's more like a details summary.
Aug 14, 2012 06:49 AM|Ajay2707|LINK
Cross-tab reports provide the support to extract data for decision making. It is basically used when you want to show data table format as a summary.
Aug 22, 2012 10:52 PM|Musikero11|LINK
But how can I have this sort of output?
Date: August 1, 2012
Aug 23, 2012 01:05 AM|Ajay2707|LINK
yes you will done in cross tab.
after making cross tab, you will show/hide the summary part at row level as well as column level by going CrossTab Expert - > customize style.
Aug 23, 2012 01:59 AM|cnranasinghe|LINK
Simple create the dataset as following
Name Center Qty
Brando Center1 5
Brando Center2 10
Jhenelhyn Center1 6
Jhenelhyn Center2 14
and add this datasource to a crosstabl, colum as center, row as name and details as qty. Total is built in.
Aug 24, 2012 01:49 AM|Ajay2707|LINK
As cnranasinghe said, if your data or sp is not complicated. then it is good to make sp same as you need output in report.
Because it is faster to show result.
In report, cross tab take some time to generate output and formatting.