×
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

Combining Crystal Reports output into one file

Combining Crystal Reports output into one file

Combining Crystal Reports output into one file

(OP)
Hi,

I have CR2008. I currently have one report that based on a parameter selection will produce five different result sets. The report will run on a schedule for each parameter to produce 5 separate instances exported as txt files.

Is there a way to have all five combined into 1 txt file for use by the user?

RE: Combining Crystal Reports output into one file

Why not group on the field value you are setting the parameter to, and then limit the report to the five instances, either hard-coding them in the select statement or using a multi-value parameter?

-LB

RE: Combining Crystal Reports output into one file

Or build a container report and enter 5 copies of your report as a Subreport and set different parameter for each one.

Ian

RE: Combining Crystal Reports output into one file

(OP)
Hi LB,

thank you for your reply. the report parameter is actually used to perform the grouping by dimension, not select it. the BW query will limit data to 15 month. the CR Parameter will simply sum up and measure by the specific parameter.

if for example the total sum of measure for the query is 100 and the parameter is ?Person then it will show LB with 75 and Kristal with 25. If the parameter selected is country it would show Canada =60, US = 20 and Mexico =20... etc. So there can be only one group.

I think we've decided to just load the the 5 txt files individually.

RE: Combining Crystal Reports output into one file

Just in case you decide to try again to combine the text files.
As IanWaterman suggested you can add 5 reports as subreports. This will take just few minutes. Import the report to each of the subreports and link the parameters.
How you are going to use the result text file ? Obviously there will be some records for contries and some for people. It might be hard to distinguish the sections.

www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

RE: Combining Crystal Reports output into one file

(OP)
Hi.. i actually just say Ian and your suggestion. Yep. It's the great idea. but because the report contains 3 sub reports I can't imbed them into a frame report as sub reports themselves.

RE: Combining Crystal Reports output into one file

You can probably use a 3rd party tool. Some of the viewers listed on Ken Hamady's website can join result files from multiple reports (list is available here : http://kenhamady.com/viewerfeaturematrix.pdf). There are free options so no purchase is necessary.
You can see a sample use in this video:
http://www.r-tag.com/Pages/Preview_Demo.aspx - Select "Jobs(complex reports)" in the menu or jump to position 12:30.
(The sample is for Excel)

What are you going to do with the result file ? Are you going to import it , send it , save it as a backup ... ?

www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

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