dynamic hiding columns with procedure as datasets

Ronak

HELLO,

Fine, Now I have one procedure which is as follows.

---

CREATE OR REPLACE PROCEDURE getRepGlobalProperties( pvReportName Varchar2, pnCols OUT Number ) AS
BEGIN

If pvReportName = 'TITLE' Then
pnCols := 2;
Elsif pvReportName = 'SALUTATION' Then
pnCols := 3;
Elsif pvReportName = 'ENTPTYPE' Then
pnCols := 4;
Elsif pvReportName = 'USER' Then
pnCols := 10;
Elsif pvReportName = 'CLIENT' Then
pnCols := 6;
Else
pnCols := 0;
End If;
Exception
WHEN OTHERS THEN
pnCols := 0;
END getRepGlobalProperties;
/

---

Scenario is : I agaoin have 20 columns.
In procedure I have two parameters. The first parameter is pvReportName. If pvReportName = 'TITLE' then the two coluns to be diaplayes as described as PNCOLS = 2 in procedure.

Similarly if pvReportName = 'SALUTATION' THEN out of 20 columns only 3 columns to be displayed as PNCOLS = 3 given in procedure.
Similarly for others...
How to do this.
I am using birt 3.7.
If possible then provide sample example of it.

Thanks,
Ronak

mwilliams

So, you've got a table and you have script that tells you how many columns to show based on a certain value? Is this correct? If so, you should just be able to create visibility expressions for each column based on the value of pnCols. Hope this helps.