Cross Tab report specific number of columns only display

[Former Member]

I am new to work on cross tab reports.

i am generating crystal reports from the stored procedure,

In the below results, i need Only 3 Columns(A00000450,A00000451,A00000452)

Please help me. how to get..

	A00000450	A00000451	A00000452	A00000453	A00000454	Total
X		<10	<10			<10
Y		❤️	3	3	4	4
X		3	4	4	5	5
ABC		1	2	3	4	4
dsf	11					11
dfg	12					12
ff	13					13
VI219	14					14
dfg	15					15
dfg	16					16
gdfgdf	17					17
dfg	18					18
dgh	99					99

[abhilash_kumar · Accepted solution]

Hi Sankar,

Try this please:

1) Create a formula with this code:

IF {Database_field} IN ['A00000450','A00000451','A00000452'] then

     {Database_field}

2) Create another formula for the 'Summarized Field' as:

IF {Database_field} IN ['A00000450','A00000451','A00000452'] then

     {measure_field}

3) Replace the existing field under the crosstab's column with the first formula above

4) Replace the existing field under the 'Summarized Field' with the second formula above

5) Go to the Crosstab Expert > Customize Style tab > Check the option 'Suppress Empty Columns'

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash..

It's working perfectly..  The thing is that ['A00000450','A00000451','A00000452']  Not a constant data. it's always change.

I need to display first 3 distinct columns.

Please help me..

-Sankar