Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Subreport

Status
Not open for further replies.

Yustrn

Instructor
Jun 19, 2002
42
US
Hello,

Using Crystal 10 and have a subreport to pull data. I have two questions.

A. When I run this new report in my software and then export the data out in a character seperated value file the sub report data is not showing.

B. The subreport is pulling fields based off of Tax Description and Tax Amount. These are the only two fields that I have.

What's it's doing when pulling these fields is listing them all horizontal and I need vertical so instead of

Federal 100
Social Security 300
Medicare 400

I need

Federal 100 Social Security 300 Medicare 400. How can I tell it to list the info it's pulling horizontal?

I'm a basic hack on crystal and I admit it. So please if you can help me I appreciate it and please make replies elementary.

Thank You
 
1. I'm not sure whether you can export subreport results to a csv file. You could try placing the subreports in a header section (and suppressing all sections within the subreport) and then passing the desired subreport fields to the main report via shared variables. I'd have to know a lot more about your overall report design to help you with this.

2. To display results horizontally, you could try either of the following:

a. Format the detail section in the subreport to "format with multiple columns" and then in the layout tab, set gap and width->across then down.

b. Create two formulas:

//{@accum} for the detail section:
whileprintingrecords;
stringvar x := x + {table.taxdesc}+" "+{table.taxamt}+" ";

Then in the subreport footer, use:

whileprintingrecords;
stringvar x;

Suppress all sections within the subreport except the footer.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top