| mthompso 2005-06-08, 8:59 pm |
| I'm using VB6 SP6, CR 9, the report I'm having a problem with is a .dsr.
Data source is Access97, using Data Access Object.
This spring my client wanted a blank report which matched an existing
building_condition_report. The idea was toprint out the blank, then
field reps would fill in the data by hand.
I took the existing building_condition.dsr, exported it as a .rpt,
renamed it to "blank_building_condition.rpt", and imported it into the
VB project as a CR9 Object. Then I modified and renamed the default form
created during the import process, pasting in required code from the
original building report. Then all the data fields of
blank_building_report.dsr were suppressed and lines placed over them.
Worked OK.
Here is the problem: Now the original building report will display data
for only ONE building, and no others.
The work was done several w s ago, so some details may be faulty.
Before renaming the exported .rpt, I may have run it once, using the
building_id the source .dsr is now stuck on.
Does anyone have any suggestions? It would take days to recreate this
thing which has been steadily added to over the years.
Thanks in Advance - Miles Thompson
PS:
It is a simple report, reporting from two tables in the main report,
with 5 subreports, and everything is linked on the building_id. The
building_id is passed to the form which launches the viewer (and thence
to the report as its selection formula) from a textbox in the calling
form. Yes I have checked and verified that the building_id value are
passed correctly.
PPS: If I open the exported and renamed blank_building_condition.rpt it
will run only for the same property that the .dsr is now stuck on. No, I
did NOT reimport it under that name.
|