×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

crystal report 7 - linking to sub report

crystal report 7 - linking to sub report

crystal report 7 - linking to sub report

(OP)
i have main report whith columns invoiceno, date, customer, amount. Taking from table A with above columns.

i have created sub report with columns account, debit , credit. Taking from table B with these columns. (invoiceno is link between tables A and B)

Main report is grouped by invoiceno.

i want to link main and sub report by invoiceno and i want to show sub report in main report's footer.

i want to show total debit and credit for each account regardless of invoiceno or customer.

But sub report is taking invoiceno only from main report's last group .

Suppose my main report have inv1, inv2, inv3 then
my subreport is taking accounts only from inv3

Any idea what am i doing wrong??

RE: crystal report 7 - linking to sub report

Report is doing what you asked it to do winky smile
Placing Subreport in report footer and linking by invoice will always link on last record.

If you want a summary of CR/DR for all invoices and customers then do not link it at all.

If you have a date range make sure the SR has the same date range too.

Ian

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