is it possible to create a button control without a data source?

[cokeyng]

Hi all,

I am wondering if it is possible to create a button control on a report without a data source. here is an example I have

Cost Type   Location   Cost Value   

A                 City 1        500,000.00

A                 City 2        450,333.00

B                 City 1        750,000.00

C                 City 2        800,000.00

D                 City 1        950,000.00

I want to create a button control with a "Include Cost Type A ? Yes/No" choice. where "Yes" includes Cost Types A, B, C,D and "No" is for B, C and D only.

The only way I can think of is to create a dummy data set with two values, Yes and No. Associate a Parameter with that with on the control. Then make a filter to check the value of the parameter to set the filter to include A,B,C,D or B,C,D only

Thanks

Cokey 

[acordes · Accepted solution]

Correct, create a promoted table with few fake rows. 

data dummy_va(promote=yes);
do number=1 to 25;
num_char=put(number, 3.);
output;
end;
run;

Then load this table to the report. 

Next select the table and create a customized group.

Use this customized group, here sel lattice, in an object, here button bar. 

Assign a parameter to it, here sel lattice parameter. 

Then use the parameter i.e. in an if-then statement to return the desired category variable used for the lattice role.