Here is the one interesting code below: I am using this below code as part of report. ################################# SUM COMP_RATECD AS 'Rate Code' CURRENCY_CD AS 'Currency Type' COMP_RATE/D18.2 AS 'Amount' BY TGT_BUSINESS_NAME NOPRINT BY EMPLID NOPRINT
ACROSS TGT_COMPRATE_TYPE NOPRINT COLUMNS 'Allowance #1' AND 'Allowance #2' AND 'Allowance #3' AND 'Allowance #4' AND 'Allowance #5' AND 'Allowance #6' AND 'Allowance #7' AND 'Allowance #8' AND 'Allowance #9' AND 'Allowance #10' AND 'Allowance #11'
#################################
Explaination: Right now report is displaying values for 'Rate Code', 'Currency Type', and 'Amount' with repetition of 11 times because of the database values given with ACROSS VALUES from 'Allowance #1' to 'Allowance #11'. Here these 3 titles are repeating with same names in 11 times. (Data is coming correctly for each Allowance)
But, the requirement of Titles display on HTML report must be same as mentioned below:
Is there any solution to resolve these kind of Tiles on HTML Report output.??
Thanks, Hari.This message has been edited. Last edited by: Kerry,
Harikrishna.V, Bangalore.
November 01, 2011, 01:25 PM
Ram Prasad E
Hari, First you need to hold the table with ACROSS. So the hold file will contain 2+(3 x 11) = 35 columns, with alias name E01,E02,... till E35.
This you can Print in HTML output in the subsequent TABLE FILE request by directly refering to these 35 columns. Or you can use Looping to get this in case if ACROSS Values are dynamic.