Page 1 of 1

Grouping in crosstabs

Posted: Mon Sep 26, 2011 8:44 pm
by Naveen Aggarwal
Hi

I am using a crosstab to display some receipts having different fee heads date wise with sums printed at the end of the crosstab. Is it possible to display the sums after each date ?
Secondly, is it possible to have a conditional sum, i.e. can i put some condition to select which rows to sum in the crosstab ?
Thanks in advance !


Grouping in crosstabs

Posted: Tue Sep 27, 2011 1:30 am
by HighAley
Hello.
naveenagg wrote:I am using a crosstab to display some receipts having different fee heads date wise with sums printed at the end of the crosstab. Is it possible to display the sums after each date ?
Please, look at 'Cross-Tab without Columns' report in our Demo.
naveenagg wrote:Secondly, is it possible to have a conditional sum, i.e. can i put some condition to select which rows to sum in the crosstab ?
Please, describe your problem more detailed. What columns do you want to sum?

Thank you.

Grouping in crosstabs

Posted: Tue Sep 27, 2011 5:21 am
by Naveen Aggarwal
Thanks a lot for your mail sir !

I had a look at the crosstab without column but that wont serve my purpose. I can send you a sample of my requirement.
There is a video on your site for creating crosstab on databand using a master detail relation. I tried that also but didnt succeed.
I created a data source say dates which is having all the dates and took it as master table.
The second data table contains all the receipts and i took it as detail table, set the relation between the two on date.
Tried to render the report (preview), but it displays all the rows of detail table for every date in master table.

Kindly help !!

Thanks in advance !!

Grouping in crosstabs

Posted: Tue Sep 27, 2011 7:31 am
by Alex K.
Hello,

Please send us your report with sample data for analysis.

Thank you.