Skip to Content
0
Former Member
Apr 27, 2009 at 04:46 PM

Different restrictions for each columns

65 Views

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