Weekly data across not down

[KrystlDuk]

I am working in Crystal 9, using a SQL Stored Procedure for the datasource.

I have 7 formulas like the following: (only change is the date in the IF statement, to meet the requirements of the day of the weeks' schedule)

IF {rsp_RoomSchedulingCalendar.ClassSessionDate} = 
{?@StartDateParam}+1
THEN 
TOTEXT({rsp_RoomSchedulingCalendar.ClassSessionDate},"MM/dd/yyyy") +
CHR(13) +
{rsp_RoomSchedulingCalendar.Class_No} +
CHR(13) +
{rsp_RoomSchedulingCalendar.CourseName} +
CHR(13) +
{rsp_RoomSchedulingCalendar.SessionTime} + 
CHR(13) +
{rsp_RoomSchedulingCalendar.Instructor} +
CHR(13) +
{rsp_RoomSchedulingCalendar.Instructor2} +
CHR(13) +
{rsp_RoomSchedulingCalendar.Instructor3}

Now I have it in the detail section, but when the report is run they display in a cascading down way, rather than straight across. Any way around this, without a pivot table, or subreports?

Thanks for any tips or advice.
Sincerely,
KrystlDuk

 

[satinsilhouette]

Without much more information, how about a multi-column version of the same report? You would do this in details, go to section and format your column that way.

 

[KrystlDuk]

okay...I'm sorry for not giving more information...I didn't think much more information was needed...but here goes.

The data in all 7 formulas are lines up left to right in the detail section in the design mode.
formula1 Formula2 Formula3 etc.

When the report runs, it displays:

Formula1
Formula2
Formula3
etc.

I want it to display the way it is in the design mode...straight across.

You mentioned the detail section multi column. With out much more information, I'm not sure I know what you mean.

If you mean just go into Section Expert and Format with Multiple Columns...Across then Down...etc. This did absolutely nothing. I tried every different configuration:
Format Groups, not Format groups, Across then Down, Down then across...all of them, and absolutely no change.

Thanks for the attempt, though.

Any other tips? Suggestions?

Thanks,
KrystlDuk

 

[lbass]

If there is only one record that meets the criterion in each formula, then insert a group on {table.date} and chooose "print for each week", and then insert a maximum on each formula and then suppress the detail section.

-LB