I’ve created a new SSRS and DSP file to fill in my info needed for my template. So far I’ve been able to do everything I want to do.
I have 3 lines being returned.
First line is Item
Second line is Labour
Third line is Charges
I was able to group my table and show all the correct information. One field I had a hard time with was because if it’s Item, I want to show the item field in column 2, but if it’s labour, I want to show the oprnum field in the same spot. I used an IIF statement on that field and show oprnum if it’s Labour, else I show the item field.
The part I’m having a hard time with is the heading of this field. If it’s item, I want it to say Item Number. If it’s Labour I want it to say Operation Number. If it’s Charges I want it to be blank. Now I can type Item Number and put an If tag on it, but this is just a boolean so it either shows or it doesn’t. I tried typing Item NumberOperation Number and only highlighting Item Number to put an If tag on that, which worked, but then when I highlighted Operation Number and tried to put an If tag on that, it didn’t work.
I’m not sure what the correct procedure is to accomplish what I need. Can someone please help?