DISPLAY FIELDS 1

[urgent72]

HI,
I am kinda new to crystal reports. I am using crystal reports 8.5.In my report i am using Oracle Stored procedure to query the fields in my report.The issue is i have to display
Field1
Field1
field1
......
field2
field2
field2
field2
....
field3
field3
field3
but when i try to put these fields in the Detail section with new sections inserted for all 3 fields i am getting results like which i do not wan to
field1
field2
field3
Each field has like 200 records and i wan to display all the records for each field and then the records of the next field.Can any one help me please.I have dead lines by next week.Thanks in advance.

 

[synapsevampire]

That's not the way a table should work, nor the way SQL would work, and Crystal is designed using basic assumptions about how tables are designed.

I saw your other post, and this does help to clarify your intent.

Since the data is being returned by a Stored Procedure, the SP programmer should have returned the data as you need it, meaning that a Union type of query which had something akin to:

select field1 from table
union
select field2 from table
union
select field3 from table

This would present the rows how you intend.

I'm afraid that your alternative is to add 2 subreports in different report footers and display each field in each area, such as.

Main report has field 1 in the details

Right click the Report Footer and select insert section below

Select Insert->Subreport and create a new report which uses the same SP, but only select field 2

Do the same in the additional report footer section for the field 3 data.

If you stop to think about your requirements, if you had 200 rows, you're requesting Crystal to display 600 rows, each field by 200 rows.

Don't use the Details section to accomplish this, it's not a reasonable approach.

-k

 

[urgent72]

Thanks a lot for the reply.I am only the one writing the Stored Procedure and i used only one select statement and in that i am querying the all the three fields in it.these fields are coming from 5 different tables.The issue is these fields must be delivered as a record to the customers
for example header
details section
more details
trailer section
trailer record.
out of the 3 fields portion of the fields goes in different sections and the total length of the record is 553.

The Question i have is in the Crystal reports Data Explorer when i try to pull the Stored procedure i see the fields under the procedure name like any regular database table.I do not know if i put in different tables in the stored procedure and then try to pull the fields insted of 3 sub reports.i have never before used sub reports.

I was wondering how to UNION the Records in Crystal Reports any suggestions please??
Thanks again SYNAPSEVAMPIRE