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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not sure how to tackle this? 2 views in one report

Status
Not open for further replies.

ksbigfoot

Programmer
Apr 15, 2002
856
CA
I am using CR 10.
I have tried different ways to get this to work and I am not successful.

I have 2 views.
The first view is a simple view in which I want to show this information in the header file as it never changes.

The second view is a concatenation of 5 UNION queries.
This view will bring back some records or no records.

What I would like to do is always show the header information whether some or no records are returned in the second view.

I was thinking of putting the second view in a subreport. The problem I have is that for every record returned in the second view, I would like a new page to start with the same header information.

Can someone point me in the right direction on how I should tackle this.
Thanks
 
Sorry, figured it out. I was drawing a blank. Kind of helped to type out what I needed to do. I did us a subreport and it worked.
Thanks
ksbigfoot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top