Formatting Report With Main & Subtable Data
SystemNumber is indexed and unique in main, indexed not unique in the other tables.
I'm trying to produce a report where the data from main is only printed once and all the related records from each of the related tables are printed.
I tried just putting into a post but the formatting was weird.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Basically everything works fine in Report View but conditional formatting disappears in print preview. Any ideas? (Back style is set to Normal
I've attached some pictures. The first shows one problem; It is repeating the subreport for each record on the main report. I just want to line these up side by side.
I had the subreport on the footer and it looked ok in Report View, but in Print Preview it places the subreport at the bottom of the main report which is not desirable.
The second picture shows how I have the reports set up in design view.
I want to be able to list several subreports on one main report so I can avoid e-mailing 10 separate reports with minimal amounts of data
I can't merge all queries since I get a lot of duplicates in the report.
My goal is to hide (visible = false) sub-reports that have no results. the problem is that those sub-reports show one line of labels with no data.
I have tried using VBA code on the Sub-report onLoad event & on the parent reports OnOpen event. but it did not work.
I have set the Sub-reports visible control to NO & I tried to check if the text-box of that sub-report contains a value to change visible to True.
If Not IsEmpty(reports![Parant report]![Sub-report].report.text-box) then reports![Parant report]![Sub-report].report.visible = True
I have tried with IsNull(), I have tried to hide & then show & the opposite, I have tried from the parant report & from the sub-report events. but could never get it to showwhen there is data & to hide when there is no data.
You can set conditional formatting for a text box or a combo box control. You can change the formatting based on the control's own value, or you can use an expression to change the formatting based on the values contained in other fields or controls. On a form, you can use conditional formatting to disable a control, and you can cause the formatting of a control to change when the cursor is positioned in that control.
What do you want to do?:
*Apply conditional formatting to a control based on its own value
*Use an expression to apply conditional formatting to one or more controls
*Change the formatting of a control on a form that has the focus
*Remove conditional formatting from one or more controls
*Create alternating row colors on a report
The reason I ask this is that I have a report with quite a few text boxes that currently all have some sort of Conditional Formatting on them (Not all have the same Conditional Formatting). I know that when you only have a few controls that require Conditional Formatting, the built in solution in Access 2007 should be sufficient, however when the number of controls grows and when the report has multiple records that require each control to be handled on each record, the Conditional Formatting becomes very slow (much like receiving 1000 paper cuts) and renders the report as pointless considering a user must run it for 10's of minutes to an hour to complete.
So, with that said, I am really just looking for anyone's suggestion as to whether I should invest some time in the VBA coding to do what the Conditional Formatting does, or do I just go back to the requestor and let them know that formatting all these fields is too much for the system to handle.
I want to stop the Sub Report growing beyond the Bottom & Right boundaries of the Main Report so that data does not spill over onto another label. But - I also want the Sub Report to be able to fill to the maximum that the Main Report [label] will hold.
I created this label report a year ago and it is only now running into the issue of multiple rows of data in the Sub Report . . . and I'm not even sure if I did anything specific to get the one text box in the Sub Report to show multiple rows . . . and then the second column.
I also created the same report (same queries, same ODBC data source) with 2 sub reports in MS Access 97 and it runs without any problem. Is there a known fault with sub reports in access 2002 or is there a property or something I'm not setting.
The naming convention is different on the smaller table but basically it contains key information I need in my main table. I have tried to use the Append Query wizard in MS Access 2010 and I've picked the fields I want from the smaller table to be inserted into my main table. The problem is the query creates multiple entries (repetitions) of the same set of information. (It creates 56 new records)
Can anyone tell me what I am doing wrong?
My main table also has 2 linked tables FYI. Could this be the problem