Thanks in advance for your help.
I'm using CRV11.
QUESTION 1:
I'm going to have a report in the following format...
Region MetricName TimeFrame 8/5/05 8/19/05 9/2/05
Europe A Last 2 months Some % Some % Some %
Europe B Last 2 months Some % Some % Some %
Europe C Last 2 months Some % Some % Some %
Americas A Last 2 months Some % Some % Some %
Americas B Last 2 months Some % Some % Some %
Americas C Last 2 months Some % Some % Some %
Report will keep getting wider and wider - column will be
added every 2 weeks. Report as it stands will have about 30 rows for 30 different metrics. Number of metric rows will also grow.
I'd like to have an on-demand subreport available on all of the percentage values. Basically I'd like each percent to be a hyperlink that would kick off a subreport that would obtain the detail data behind the percentage calculation.
That will eventually be a lot of hyperinks. Not sure exactly how to do this.
I'm thinking one subreport with prompts that would ask...
what region do you want detail data for
what metric do you want detail data for
what date do you want detail for
This doesn't seem very user friendly though. But I don't want to create a subreport per metric. Any ideas?
QUESTION 2:
As the date columns in my source table get populated with more and more data and my CR report is going to be limited by the width of my largest size paper does anyone know of a way to roll the columns in my report. Basically after I reach the max number of report columns that I can display on whatever size paper I use I want the oldest date column to be purged off and the newest date column added.
Again... thanks for your help.
I'm using CRV11.
QUESTION 1:
I'm going to have a report in the following format...
Region MetricName TimeFrame 8/5/05 8/19/05 9/2/05
Europe A Last 2 months Some % Some % Some %
Europe B Last 2 months Some % Some % Some %
Europe C Last 2 months Some % Some % Some %
Americas A Last 2 months Some % Some % Some %
Americas B Last 2 months Some % Some % Some %
Americas C Last 2 months Some % Some % Some %
Report will keep getting wider and wider - column will be
added every 2 weeks. Report as it stands will have about 30 rows for 30 different metrics. Number of metric rows will also grow.
I'd like to have an on-demand subreport available on all of the percentage values. Basically I'd like each percent to be a hyperlink that would kick off a subreport that would obtain the detail data behind the percentage calculation.
That will eventually be a lot of hyperinks. Not sure exactly how to do this.
I'm thinking one subreport with prompts that would ask...
what region do you want detail data for
what metric do you want detail data for
what date do you want detail for
This doesn't seem very user friendly though. But I don't want to create a subreport per metric. Any ideas?
QUESTION 2:
As the date columns in my source table get populated with more and more data and my CR report is going to be limited by the width of my largest size paper does anyone know of a way to roll the columns in my report. Basically after I reach the max number of report columns that I can display on whatever size paper I use I want the oldest date column to be purged off and the newest date column added.
Again... thanks for your help.