Hello
I am accessing data from a SQL Server database and I am using Crystal Reports 8. When I access data from the database, 1 to 20 records may be produced.
Instead of listing the data from the records as:
Record1
Record2
Record3
I would like to list the records horizontally and then when the first row is done, go to the second row as such:
Record1 Record2 Record3 Record4
Record5 Record5 Record6
I am using a formula which appears not to work.
THe first formula for the first record is:
if {@Count_Records} = 1 then
ToText(DateTimeTODate({a_rpt_letter_transcript_sub_v.date_hearing}))
The second formula for the second record is:
if {@Count_Records} = 2 then
ToText(DateTimeTODate({a_rpt_letter_transcript_sub_v.date_hearing}))
Instead, I still get the vertical listing such as
Record1
Record2
Any ideas?
Thanks
I am accessing data from a SQL Server database and I am using Crystal Reports 8. When I access data from the database, 1 to 20 records may be produced.
Instead of listing the data from the records as:
Record1
Record2
Record3
I would like to list the records horizontally and then when the first row is done, go to the second row as such:
Record1 Record2 Record3 Record4
Record5 Record5 Record6
I am using a formula which appears not to work.
THe first formula for the first record is:
if {@Count_Records} = 1 then
ToText(DateTimeTODate({a_rpt_letter_transcript_sub_v.date_hearing}))
The second formula for the second record is:
if {@Count_Records} = 2 then
ToText(DateTimeTODate({a_rpt_letter_transcript_sub_v.date_hearing}))
Instead, I still get the vertical listing such as
Record1
Record2
Any ideas?
Thanks