Can I make crosstab customisable?

[kc9400]

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.

[New_Guy]

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

[kc9400]

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.

[kc9400]

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.