April 27, 2018 at 12:08 pm
I was required to build a SSRS sub report using textboxes to show employee payroll deduction information if the dataset field not empty otherwise next non-empty field will be replaced at the location dynamically with each row 4 fields like this format (Sample from two employees for comparison).
There are around 30 dataset fields for each record (meaning each employee)
Such as in Data1 the field CREDIT UNI doesn't appear and FICA appears at second position comparing with Data2. In Data 2 LIFE INSUR, MUNICIPAL, PENSION-LO, TRANSITBEN, TDA LOAN appear but no in Data1
Is it possible to build this report? Thanks in advance.
Data1:
DED: CITY TAX 35.11 FICA 80.40 FEDERAL TA 123.51 HEALTH 2.52
MEDICARE 18.81 PENSION 38.98 STATE TAX 50.61 TAX-DEFFER 25.21
UNION DEDU 33.60
Data2:
DED: CITY TAX 61.87 CREDIT UNI 345.52 FICA 125.25 FEDERAL TA 18.06
HEALTH .00 LIFE INSUR 46.60 MEDICARE 29.29 MUNICIPAL 1.00
PENSION-LO 136.33 STATE TAX 91.44 TRANSITBEN 60.50 TAX-DEFFER 101.00
TDA LOAN 94.85 UNION DEDU 33.60
April 30, 2018 at 9:48 am
Almost anything is possible, but not necessarily always practical. Subreports can be a performance nightmare if they're all that complex. However, we don't have any idea what the size of the subreport is, or what the exact rules are for including a particular value. You would have a heck of a time computing length of text for the column names involved, so I'm not sure this is in the practical category at the subreport level. It might be more practical at the dataset level by integrating the value into the query, but without a lot more detail on how this report is put together in the first place, there's no easy way to know. Please provide a LOT more detail, such as the dataset query, and post some kind of image of the report design so we can at least see the basics of where the subreport is supposed to appear, along with a very detailed description of the exact rule to follow to include a value in the subreport.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply