Solved

report within a report

Posted on 2013-01-03
12
276 Views
Last Modified: 2013-01-04
Using CR 8 Developer

We have, for example:

Record 1
Record 2
Record 3
Record 4

Records 1 & 4 can be selected directly but 2 & 3 require a second select based on Record 1. Is this possible ?
0
Comment
Question by:cehrnow
  • 4
  • 4
  • 2
  • +2
12 Comments
 

Author Comment

by:cehrnow
Comment Utility
..or is it possible to run two separate select statements from the same table and merge the results into a single dataset ?
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 200 total points
Comment Utility
Without knowing your data, a general response is it would be a lot easier if you could just write SQL to return the results you need, but your options with CR8 are extremely limited.  Why are you using such an old version?  Is it because you're support reports in a legacy application?

As to your second question, no you can't run two separate select statements, but you can add the table in twice and join it to itself.  Ex:  Add the "Customers" table, add it again and alias it as  "Customers2" and join Customers2 to Customers on the customer ID.

You might be able to get what you need from the second instance of the table if it's records are based on records from the first table.
0
 
LVL 22

Assisted Solution

by:Ido Millet
Ido Millet earned 150 total points
Comment Utility
You can append two result sets (two SELECT statements using a UNION or UNION ALL statement. But your description is a bit vague, so I don't know what precise logic you are looking for.

You can also insert a linked subreport...
0
 

Author Comment

by:cehrnow
Comment Utility
Apologies using CR 2008 v12 - Developer
0
 

Author Comment

by:cehrnow
Comment Utility
Thanks rhinok - have tried this but still not sure it will work out. Best to reorganise db but this is not an option.

Thanks IdoMiller - given that there could be 100s of Record 1s with several Record 2&3 under each one do you still think a sub-report is realistic ?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
Is this hierarchical data, such as an employee table where there are children (employees) and parents (supervisors)?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 150 total points
Comment Utility
Can you give a real example of how records 2 & 3 are related to record 1 or 4?
If so a linked subreport can certainly provide access and display of records 2 & 3.

With CR 2008 you can also use a Crystal command to select the records you need.  This command can be fairly complex.  You can also build a stored procedure or use temporary tables to create the desired recordset for the report.

mlmcc
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
Crystal Reports 8, not 2008.  The only SQL options are to use the Crystal SQL Designer (which I wouldn't recommend, since there won't be any support for it should an upgrade eventually be required) or to use Views/Stored Procs and stored proc support was extremely funky back then.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Author's comment above

Apologies using CR 2008 v12 - Developer

mlmcc
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
Ahh, cool.  Missed that, thanks :)
0
 

Author Closing Comment

by:cehrnow
Comment Utility
Thanks for all suggestions which I think covers options. However, it's such hard work even with these that I'm forcing through a db redesign.
0
 
LVL 18

Expert Comment

by:vasto
Comment Utility
It is not necessary to redesign the database. This is a classic tree structure and can be easily handled by recursive queries. What is your database type ?
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now