Print Page | Close Window

Different restrictions for each columns

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6195
Printed Date: 07 May 2024 at 4:26pm


Topic: Different restrictions for each columns
Posted By: rbarekere
Subject: Different restrictions for each columns
Date Posted: 27 Apr 2009 at 8:58am
I would like to restrict each column in a standard report with different value, without using global filter.
 
For Ex. I have a measure field called Amount. I would like to have 12 columns namely Jan, Feb etc... and then I would like to restrict each column with Month and I need to get the data for that particular month in the column.
 
In this case I cant use cross tab report because crosstab doesnt support some of the features of SAP datasource at this point of time. I can create measures in SAP datasource with restriction. But performance of the query will be affected.
 
In case of Web Intelligence we can create a formula with where clause for each of the column. But such thing i couldnt find in crystal report.
 
I need experts help here.
 
I appreciate your help.
 
Thanks
Raghu


Replies:
Posted By: lockwelle
Date Posted: 28 Apr 2009 at 6:27am
create formulas.  1 for each column.  in the formula you can check if the month is the one that you want, and if so, print a value, otherwise leave blank.  If you need to perform aggregate functions, you will need to keep counters in your formulas so that your aggregates can be calculated at the time of the footer. 
 
The only filter you would need would be the one to get the correct data into the report, the formulas would act as local column filters.
 

Posted By: rbarekere
Date Posted: 28 Apr 2009 at 10:35am
Thanks.
 
It worked.
 
-Raghu


Print Page | Close Window