• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

crystal report format

Hi all, i have a problem regarding format of Crystal report, where im displaying data from Sql Server 2000 table.
Table has following fields- date, col1, col2, col3.
Now, the data in report should be displayed as:-

Date1
col1      col2         col3
Date2
col1      col2         col3
Date3
col1      col2         col3
can anyone sort out this problem??
thanks in advance
0
Amritpal Singh
Asked:
Amritpal Singh
2 Solutions
 
peter57rCommented:
I don't understand what the problem is.

If these are individual records then you just lay out the detail section as you want it.
If you are trying to group by date then again you do that and lay out the 3 columns in the detail section.

Perhaps you can provide an example of what is not working for you.
0
 
frodomanCommented:
I think you need Report -> Group Expert.  Select {Date} as the field to group by and then drag the date field into the group header.  Put your other columns in the details section side by side and you'll have what you're asking for.

frodoman
0
 
MIKESoftware Solutions ConsultantCommented:
Group by DATE...Ascending...

MikeV
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now