Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Report with two Content Sections and one query

Report with two Content Sections and one query

Report with two Content Sections and one query

Sure hoping someone can assist me.  I'll give a little history first.  A while back, I created a very nice report with a couple different content sections.  This report utilized one query.  To keep it simple, we'll say this:

select item1, item2, item3 from tbl1 where item3 in ('A','B')

Very basic.

Well...I created an individual library for this report which stored the query.

As luck would have it, I now need to modify my nice report to add something to it.  Well...stupid me somehow at some point in time deleted the library.

I can pull up the report and have the structure laid out in front of me and have a copy of the query.  My issue is that for the life of me, I can't figure out how I set it up to where the Content Sections use that one query but only display information for that section.

Such as

Section 1 displays info on item3 ('A')
Section 2 displays info on item3 ('B')

Not asking anyone to write my code, I'm just hoping someone can help jar my swiss cheese memory to help me figure out how I did this the first time.

I was thinking the OnRead() to isolate just the 'A' for Content section 1 and 'B' for section 2, but I don't think that was it.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close