Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lemondash
Posting Yak Master
159 Posts |
 Posted - 2009-10-20 : 11:46:18
|
| Hopefully some can help a rather confused beginner; I’ve just started using SSRS on a Sql 2005 box.The report I’m trying to generate I thought was quite simple but I seem to be struggling.I have a flat table that consist of three columns, ID, EnteredOnDate and LTypeID. Now I would like to return the results with LTypeID on the left hand and enteredOndate across the top and the ID count value in the middle.But I really need the month of the date across the top, going horizontally.Any ideas?Regards lemondash |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-20 : 12:19:57
|
| Would love to help. Can you post the actual SQL you created to get your rows? Would help me understand a little better.I am guessing that each page will have the date and then for each LTypeID a count. When date changes, you want a page break?I am not a purist (like many here) and am not ashamed to use the report wizard to generate the rough beginings of the report.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-20 : 14:00:42
|
| what you need is to use a matrix container in your report. add rowgroup as Fields!LTypeID.Value, column group as Fields!EnteredOnDate.Value (provided it doesnt have time part, else you need to strip time part off before retrieving in report) and expression inside matrix as =Count(Fields!ID.Value) |
|
|
|
lemondash
Posting Yak Master
159 Posts |
Posted - 2009-10-20 : 17:35:15
|
| Visakh16 that sounds exactly what i'm trying to do. But am really have trouble getting it to work.I want to use a a matrix so i can have the ltypeid as the row and then use the date(but only the month part) across the top. Then the count/group in between.So if it dosne't make sense, but am realy struggling with SSRS.Regards lemondash |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-21 : 12:45:42
|
| then wats the problem? give row group as Fields!LTypeID.Value, column group as DatePart(DateInterval.Month,Fields!EnteredOnDate.Value) and data part as Count(Fields!ID.Value) |
|
|
|
|
|
|
Help with report