Hi ,
I have a requirement to burst(to send emails) a report based on more than one BY field in Report Caster.Suppose I have a table called INFO with SITECODE , BUILDING_NO,FLOOR_NUM,VACANT_SQFT etc.

Our Sample data looks as below,

SITE BUILDING_NO FLOORNUM VACANT_SQFT
------------------------------------------------
BOS 1001 04 32323
BOS 1002 05 54545
SAL 1001 07 53534
SAL 3000 05 88484
BLR 1001 04 65445

I would like to burst the output and eMail as given below,

a) Site BOS and Building 1001 to ss@xxx.com , b) Site BOS and Building 1002 to aa@xxx.com ,
c) Site SAL and Building 1001 to bb@xxx.com ,
d) Site BLR and Building 1001 to jj@xxx.com

If My FEX is something like given below,

TABLE FILE INFO
PRINT
FLOOR_NUM
VACANT_SQFT
BY SITE_CODE
BY BUILDING_NO
END

I know one method which is using a define field with the concatenation of both the BY fields and use it as a single BY clause. Use this value (Concatinated value) in the burst_value of report caster and it is working. Is there any other method where we can have this feature?

Any suggestions?

Johney,

You have hit upon the only "real" option that you can use as RC only operates a burst upon a single BY field and therefore you need the concatenation as you imply.

T