Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page header info wrong when exported

Status
Not open for further replies.

bjornagin

Programmer
Dec 28, 2005
9
US
Hi all,

I'm having an issue with an old report that is being run with CR7. The report prints wrong information in the page header when the report is exported to RTF. The report works fine when printed or displayed to the screen.

The page header displays a "department" field in the page header that it gets from the table "table2". The report queries the data with a query similar to..

Select ....
From Table1 Left Outer Join Table2
Where Table1.Employee = Table2.Employee

The department field is also used to link a page header sub report. Since, the wrong department is displayed, the subreport shows incorrect results as well.

I'm assuming that I'm dealing with a glitch in the CR7 export. But if there is a way to work around this problem, I'd appreciate it.

Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top