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!

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

Comparing Group headers in the main report to names in sub-report.

Status
Not open for further replies.
Cydamac

Cydamac

Technical User
Mar 27, 2001
16
US
I am reporting on a Scheduling software database (SQL and Access 97). My company uses ttx files (I don't know why!). I have a group in the main report for "Room Names" whose details show events that take place in the room. I need to show unused rooms as well, so I made a subreport to do so. I want to compare the room names in the sub, to the room names in the main, and only print out the rooms (in the sub) which do not have a twin in the main. I am totally stuck. My algorithm seems simple enough, but our DB structure is such that it is designed to be dependant on events. This creates a big problem when I need to show what DOESN'T have anything scheduled in it. Any ideas?

Sincerely,

Cydamac
 
Status
Not open for further replies.

Similar threads

jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
264
jchewsmith
jchewsmith
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
574
hilfy
hilfy
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
276
doodledump
D
john432
  • Locked
  • Question
Crystal Report
Replies
2
Views
279
john432
john432
john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
283
john432
john432

Part and Inventory Search

Sponsor

Back
Top