Matrix in page header?

06-23-2009, 7:10 AM
I know I cannot put a matrix in the page header. Currently, I have of set of reports and the page header is essentially a matrix that has a various number of columns (based on the amount of data chosen by the user). The first matrix in the body of the report controls the column headings for the remainder of matrixes in the report. If my reporrt spans more than one page, then I need the column headings to repeat. However, since the column headings are simply in the first matrix in the body of the report, it does not repeat. And, I cannot put the matrix in the actual page header. What can I do? I have attached a sample report for you. Note that Description is only in the column headings in the first matrix.

Re: Matrix in page header?

06-24-2009, 2:52 PM
Hello,

I sincerely apologize for the delayed response.

I would suggest you to please re-design the report so that a single matrix is being used.
Thereafter, we may use static groupings in this matrix with AggregateIf.
This will determine if the Aggregate has to be displayed or not.

Please find attached a sample RDLX in which the desired functionality has been achieved.

Regards,
Amit

Re: Matrix in page header?

07-01-2009, 9:44 AM
Hi Sandeep - I do not think we can redesign our reports to use a single matrix. We have farily complex financial reports and are using various matrixes to organize the data in the report. For example, we need some data to display in matrix one and other data to display in matrix two. To do this, we use multiple matrixes and vary the filter per matrix. How can I acheive this using a single matrix?

If you look at the report I attached to the original posting, you will see the complexity of our report.

Re: Matrix in page header?

07-02-2009, 2:02 AM
By looking at the report you have attached, you only have a single DataSet. This same DataSet is shared among all of your matrices in the report. You use various filters to select which data to use in a particular matrix and then display the aggregate values.

The AggIf.rdlx sample report attached in the previous response demonstrates using a single matrix to perform a very similar type of report without the use of filters on the DataRegion but by using a condition to determine which values in the DataSet to aggregate (AggregateIf). Since the row groupings are known for the report prior to rendering, static groupings are used. The AggregateIf then only aggregates data (in the sample, using Sum) based on the groupings known value.

Again, I see heavy usage of parameters to define styles. I definitely think it would be much easier for you to define a single shared Theme file using our Theme Editor (Start Menu -> Program Files -> Data Dynamics -> Reports -> Data Dynamics Reports Theme Editor). If the report is used for multiple companies you could load up specific theme files at runtime prior to rendering the report.

-Jon

Re: Matrix in page header?

07-02-2009, 12:40 PM
Thanks for the detailed info. That helps explain the purpose of the aggregateif function. Here is my specific problem and why I don't think I can use the approach in the attached report. I need to be able to logically group items in the report. Using the attached as an exmaple, let's say that we have 12 months worth of movie rentals. Per month and per movie I want to print how many times that movie was rented. I want to list all the action movies, followed by a blank space, followed by all comedies, followed by a blank space, followed by all dramas. In between each category of movies (action, comedy, and drama), I may also want to put a heading above the seciton such as ACTION, COMEDY, and DRAMA. How can I acheive this using just one matrix? My approach was to use 3 matrixes: An action matrix that lists only action movies. This first matrix is the one that prints the months across the top. The second matrix lists the comedies (without the months being repeated). The third matrix lists the drams (with the months being repeated)

Re: Matrix in page header?

07-06-2009, 10:54 PM
Hello,

Thanks for providing detailed information about your requirements.

Unfortunately, currently there is no way through which we can create a report as per your requirements.

The ideal solution would be to use a Single matrix however it seems that your report might span across different matrixes.

I am sorry I could not provide you a better answer on this.

Regards,
Amit
Amit Pal
GrapeCity- DataDynamics

Re: Matrix in page header?

07-09-2009, 8:12 AM
Thanks for the reply. One question. This seems to be a problem because I cannnot put a matrix in the page header. Why? Why can't I put a matrix in the page header that is used just to make sure that the column headings are printed for every page?

Re: Matrix in page header?

07-10-2009, 6:02 AM
I can very well understand about your requirements however this is something by design as we cannot use any of the DataRegions inside Page Header.

Regards,
Amit
Amit Pal
GrapeCity- DataDynamics

Re: Matrix in page header?

07-10-2009, 7:59 AM
I thought I had a good idea. My thought was to put a banded list on my report and put all my matrixes inside of it. Then put a matrix in the banded list header to get the matrix to repeat on each page. But, I am getting the error message "Enumeration already finished". Why?

Re: Matrix in page header?

08-03-2009, 6:43 AM
Hello - any ideas on this one? the lack of ability to repeat the column headers on all pages continues to be a problem for us. Thanks.

Re: Matrix in page header?

08-18-2009, 6:35 AM
This continues to be a problem for us. When our reports span more than one page, this continues to surface. Any ideas?

Re: Matrix in page header?

08-18-2009, 10:44 AM
Are you still getting the error message in the banded list ?

Regards,
Gaurav

Re: Matrix in page header?

08-18-2009, 1:02 PM
Yes, i am still getting the enumeration has already finished message.

Re: Matrix in page header?

08-20-2009, 12:12 PM
Can you provide me the rdlx file in which you are getting this error message.

Thanks,
Gaurav

Re: Matrix in page header?

08-25-2009, 7:01 AM
Hi Gaurav - The report and the xml data source are attached. Thanks, Cyndi