How to increase Report header size

[baba]

I am creating barcharts in the report header section but i think there is some size restiction and I am not able to add more than 3 graphs in the report header section. I have to add 65 graphs. Is there any way to do that . Please help and let me know how !!!

 

[vbaInet]

65 graphs on one page???

What's the reasoning behind this. The section is as is.

 

[baba]

I have to run 65 different queries and create 65 different graphs .Everything has to be combined /merged into a single pdf as a deliverable. As we do not have an option to creeate all 65 reports in one report header section, I should create several reports and then try to merge them i guess . I am just trying to see if there are any other easy options.Please let me know if any other details are required.

 

[vbaInet]

65 queries too? Are they all based on the same data set with just differing criteria?

 

[baba]

Atleast 30 out of these 65 queries will be from same table (say for example Table 1)and each query will have a different criteria .The remaining 35 queries will be from another table (say Table 2). I think I may have to create subreports and try to merge them in the report header section so that all the 65 graphs will be in one final report.
Else,I might have to create 65 seperate reports/subreports and merge them finally into a single pdf as a deliverable .Please let me know if any other details are required.Thaks for your help !

 

[vbaInet]

Can you show me two SQL statements from two reports that are based on Table 1 and two based on table 2. Enclose them in code tags:

http://www.access-programmers.co.uk/forums/showthread.php?p=1009015#post1009015

And I'm guessing that you don't necessarily mean they should all be on the same page, but they have to be in that one pdf doc?

 

[baba]

Thanks for the help .I would like to have one bargraph per page in the final report with headings, subheadingsdate and few more values. Also,once the graph is generated,i would change the barchart values with vba code to change the color of each bar based on the xaxis value and I have the code working for changing the color set up.

Here is a sample of the queries that I would be running. Please note each of those 65 queries will be run with minor modifications like criteria will range per week,month or year and for different applications.
Thanks for the help and guidance.

QueryOne:

SELECT Table1.[Job Name] AS JOBNAME, Count(*)
FROM Table1
WHERE (Table1.[App Name]="App1" And Year([ArrivalTime])=Year(Date())-1) Or (Table1.[App Name]="App1" And Year([ArrivalTime])=Year(Date()) And Month([ArrivalTime])<Month(Date()))
GROUP BY Table1.[Job Name]
HAVING Count(Table1.Case)>2;

RowSource for the bargraph :

SELECT [JOBNAME],Sum([Expr1001]) AS [SumOfExpr1001] FROM [QueryOne]  GROUP BY [JOBNAME];

QueryTwo:

SELECT Table1.[Job Name] AS JOBNAME, Count(*)
FROM Table1
WHERE (Table1.[App Name]="App2" And Year([ArrivalTime])=Year(Date())-1) Or (Table1.[App Name]="App2" And Year([ArrivalTime])=Year(Date()) And Month([ArrivalTime])<Month(Date()))
GROUP BY Table1.[Job Name]
HAVING Count(Table1.Case)>2;

RowSource for the bargraph :

sELECT [JOBNAME],Sum([Expr1001]) AS [SumOfExpr1001] FROM [QueryTwo]  GROUP BY [JOBNAME];

Similarly two more queries for table 2 by replacing table 1 by table2 and the app Name values.

Please let me know if any other details are required and thanks for your help.

 

[vbaInet]

So for those queries that are related (i.e. same fields but different criteria), why not create just one query and pass - in code - the different criteria to the report running the graph?

And yes, you would use subreports to get them all in. This is where having one query and one report helps too.