Column value depends on visible columns

Hi,

I am attaching my report design. The last column "Total" is from the query.

My problem is if a user selects only two columns(e.g.,coller_B and krueger_jg),how should my query be modified.

Thank you,

Find more posts tagged with

Comments

mwilliams

Looks like your design didn't get attached. Could you attach it again? Also, since I won't be able to run it, will you explain how everything with it works. Does the user select which columns they want to see? Is this why your total doesn't work if they only choose a selection of the columns?

ajunuthula

Yes, the user selects the columns he wishes to see and the total column does not work when the user chooses a selection of columns.

I am attaching the report design again for your reference.

I think I have to modify my query but not sure.

Thank you.

mwilliams

Before I open the design file, does your query get modified for bringing in the different columns? Or do you bring in all the columns and hide the unneeded ones? If you just hide the unneeded ones, you could take the total that you get from the hidden columns and subtract them from the totals column. You could use the same check as the visibility statement to figure out which ones to subtract. Or, you could simply just create a new binding that adds the columns selected by the user.

ajunuthula

My query brings in all the columns and using the visibility property, they are hided depending on the user selection. The total column is the number of unique publications,so I wrote a logic in the query as to how the aggregation is to be done. My problem is now when a column is hidden, my query fails.

ajunuthula

I edited my query and also the report design. Looks like its working.

I am attaching the rport design here.

Now my problem is I cannot set the visibility property for the columns, if I do, I cannot see the columns if selected or not selected.

Can you please look into my design and help.

Thank you.

mwilliams

Your visibility check checks for ALL CAPS and your parameter value is Not All Caps. Make those the same and it should work.

ajunuthula

Thank you!