Hi all,
Been a while since I last posted and I'm trying to come up with a solution.
I have 7 fields in a crosstab and want to make it so the users can select which fields are displayed when they run the report. Is there a way to do this without having to create every iteration of the crosstab and providing a list they can select.
Date
Location : Company : Item : Area : Data | Count
For example they pick location, item, area, data and will get the below:
Date
Location : Item : Area : Data | Count
so essentially I want them to be able to select which fields (marked in bold) appear in the crosstab from a multi select value prompt and then the crosstab to calculate correctly based on which fields have been chosed.
I hope I have managed to explain this.
Shall try make up some pictures to demonstrate this better.
Hi,
Did you try the solution from CognosPaul for a similar solution for lists? Below is the link
http://cognospaul.com/2014/09/14/prompting-fields-list/
Good luck
New guy
Quote from: New_Guy on 10 May 2017 04:25:28 PM
Hi,
Did you try the solution from CognosPaul for a similar solution for lists? Below is the link
http://cognospaul.com/2014/09/14/prompting-fields-list/
Good luck
New guy
Cheers for that, I'll take a look.
hmmm I played around with a list but still not quite able to get a crosstab working.
Shall keep at it and see what I come up with.