Way to allow user to pick what fields get added to cross tab

[jwaldner]

Does anyone know of a way that I could the user pick the summarized fields that get added to the cross tab without editing the report? I am running out of room for all the fields my users want.

I thought maybe I could have a list of parameters available to a user that would somehow tie into formulas. The formulas would be return results based on what the user selected for parameters. The list of things added to the cross tab would never change, the formulas would return no data, and not be displayed if the user did not choose to add the field to the cross tab. Is such a thing possible?

 

[lbass]

Please explain how the crosstab is currently set up: row, column, summary fields. Then show the fields you want the user to be able to add via parameter and identify their datatype. What is the total number of summary fields you would want them to be able to add? Is the type of summary the same in each case?

-LB

 

[jwaldner]

There is one column on the cross tab [that represents a date range] the summary fields are sums of integers from the query for the range. the row has two groupings [name and team]

Date range [no grouping, the user picks the range]
t|
e|name|data data data data data data data data data
a|name|data data data data data data data data data
m|name|data data data data data data data data data
1|

t|
e|name|data data data data data data data data data
a|name|data data data data data data data data data
m|name|data data data data data data data data data
2|

The datatype for any field I make optional is a number. I am not sure yet how many fields need to be optional. I was hoping to get an example of how to make one or two optional then duplicate as needed.

The main problem with the report as it is now is that The name field can be 32 chars long and I only have 8 showing. All the other fields are equally important to one or more users. [There are 14 fields] Even making three of them optional would help.

 

[jwaldner]

Another thing I noticed with this report is that for the 'Team' group on the row. I set it to print at 270 degrees to save space [As shown in the diagram if the data] It works fine until you get to the bottom of the page, then it cuts off the team name instead of printing on a new page. It would be great if I could get it to print on a new page.

Date range [no grouping, the user picks the range]
t|
e|name|data data data data data data data data data
a|name|data data data data data data data data data
m|name|data data data data data data data data data
1|

t|
e|name|data data data data data data data data data
-------page break

 

[jwaldner]

I did find that if I put the cross tab in the group header instead of the report header I can get it to stay together. The report does not look as good...
I would still love to keep it in the report header if i could.