DataBase - Drawing a grid on a Report
Asked By Sarah
20-Mar-10 09:05 AM
greetings
I have a report based on a Crosstab query. Both the Query and the Report
work just fine. They have 2 row headers on the left side of the table and a
variable number of PivotField headers.
I have been asked to have the Report's table in a grid when printed. Normally
I would just use line segments to draw this grid. BUT, the number of
PivotFields varies from Report to Report, so I am having difficulty getting
the grid to work. My supervisor wants the grid to end with the LAST COLUMN.
I'd like to know:
a) What is the best way to compute how many Pivotfields a Query will have?
b) How should I approach the drawing of the grid?
thank you in advance for any tips. I am not experienced enough at coding to
know how to handle this properly.
Sarah
Report
(1)
PivotField
(1)
DuaneThe
(1)
Supervisor
(1)
Segments
(1)
Max
(1)
Duane Hookom replied to Sarah
First, how are you creating your report if your number of columns will vary?
Have you thought about just using the border of the text boxes to create the
grid?
It might help if you provided the SQL view of the crosstab.
--
Duane Hookom
MS Access MVP
Sarah replied to Duane Hookom
hi Duane
The number of columns varies because the table is based on a Crosstab query,
so the number of PivotFields can be more or less. In any case, I have found
that the max number of Pivotfields is 16, so I have decided to make the grid
that size and leave 'squares; blank if not needed. Thank you for your
assistance. -Sarah
on the forum for creating Page numbering to run sequentially over two different reports ie report 1 starts at page 1 and report 2 starts at the end of report 1 + 1. This works when I code reports to print, report 2 starts at Page 6 as desired. But when I code to preview the reports only (how they normally work) the page numbering is not correct in that report 2 starts at page 2 (instead of 6). Do I need something in between the preview commands calling the two reports, maybe some sort of time delay to wait for report 1 to finish processing? Or is it because I have not moved through the pages not triggered / looped through its formatting section fully? Thanks for any help. . . Code on each report is: Dim intLastPage As Integer Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) DoCmd intPagenumber = " & [Page] & ";" DoCmd.SetWarnings True End Sub Private Sub Report_Open(Cancel As Integer) ' only on report 1 reset PageNo to start at 0 DoCmd.SetWarnings False DoCmd.RunSQL "Update tblPage Set
Calculating page / report sums using calculated data from subquery DataBase Here is a scenario from my report: The report will grab data with a main query into a parent row Depending on the data, a child row may exist, if it does the report will display it The child row will use data from the parent row in order to do a calculation in the child All of this works just fine and the report data is correct. Now, what I am having issues with is doing the page / report sum calculations. The requirements dictate that I need to create a sum of both the the page totals, I am trying get something like this: = Sum([StdLabor])+sum( [Product - Pegged].Report![PegStdLabor] ) But, when I try to execute this, it prompts me for the [PegStdLabor] value because it is being referenced but the sub-report does not exist yet. I have also tried the HasData Report parameter (similar problem), and
How to rename a modified report DataBase GP 10 10.00.1193 Have a user that has created a modified report. Now I need to import this into the shared dictionary for everyone to access. Problem is when I went to import the modified report there is already a shared report named the same. So I need to change the name of the the user modified report then import it into the shared. How do I rename the user modified report? I have looked in report writer but do not see a place where I can do a simple rename. Thanks 1) Backup (1) David David Musgrave (1) Encoding (1) David Musgrave (1) Aaron Frank (1) Report (1) As far as I know, you cannot rename a modified report and use it
Report Status Window DataBase I am not certain if there is a "best" way to handle this, but I wish to display a "please wait" dialog on the screen before a report is fully rendered. By fully rendered, I mean that the first page of the report appears on the screen. It appears as if all of a report's events are triggered long before the first page of the report actually appears. Does anyone have an optimal way of handling this? Thanks. Vincent Access Discussions this is not working as intended. . . . The please wait window launches after which a "blank" report area opens as the report is generating. After this "blank" report area opens, my please wait window disappears (but it is still loaded). Is there any
Rate) + Shipping + Tax 4. Expense Quantity (miles) * Rate Background: I am working on an invoice report. The report has the main report and a sub-report. The report is grouped by invoice / work order number. I have a group heading called WOHeader and a group footing called WOFooter. The main report???s row source is the tblWorkOrder table. The sub-report???s row source is tblWorkOrderDet. The sub-report contains the following fields: txtTransDate, txtWorkDesc (which is built using multiple fields), txtQuantity, txtRate, txtTaxAmt