×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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

Subreports with shared variables - I think?

Subreports with shared variables - I think?

Subreports with shared variables - I think?

(OP)
Hello,

I'm using CR2008 and I have three Remedy tables I need to join and use some shared variables in the final results.

The tables are as follows:

ParentTicket
ChildTicket
ChildTicketNotes

The database does not allow joins.

What I need in the final output is the ID# of the Parent ticket (along with some other information), the Child ticket ID#, and the User from the ChildTicketNotes table.

Table ChildTicket contains ParentTicket ID# for an easy subreport link.
Table ChildTicketNotes contains ChildTicketID for an easy subreport link.
There are no linkable fields between ParentTicket and ChildTicketNotes.

I’ve tried using the ParentTicket table as my main report with a ChildTicket and ChildTicketNotes as subreports. I’ve linked ParentTicket to the ChildTicket subreport, but I cannot link ChildTicketNotes to anything using this structure. So far I’ve had no luck using this method.

I’ve tried using ChildTicket as the main and then linking both ParentTicket and ChildTicketNotes via the subreport links. No luck this way either.

There are what seems endless ways to build this and if anyone has a suggestion on which direction I need to head, it would be greatly appreciated.

RE: Subreports with shared variables - I think?

What happens when you lead with the childticket table in the main report and then link to the parent ticket and childticket notes table in two subreports? What do the results look like if you place all in the detail section?

-LB

RE: Subreports with shared variables - I think?

Quote:

The database does not allow joins.

What database is that? I was under the impression you could always link two fields of the same type. And find work-rounds if the type was different.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

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