Please Help In designing the Reports USing SSRS

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dotnetdev1
    New Member
    • Mar 2008
    • 9

    Please Help In designing the Reports USing SSRS

    Hi Friends,....I am new to reporting and has been started developing the new reports and I am very much comfortable now...But In my table there is a list of codes like C,N,D,E, etc...and each worker has many number of codes...I have to count the codes for each Worker and Display the Report horizontally... Will anyone can please help...And also If any of the Worker is not having the Code then there Zero should be displayed...For example the report should be displayed as follows...

    Worker C D E N I
    XYZ 23 45 10 0 23

    For me Now its displaying as .....

    Worker C D E N I
    XYZ 23 0 0 0 0
    XYZ 0 45 0 0 0
    XYZ 0 0 10 0 0..

    I hope u guyz understood...I need to display one Worker instaed of displaying 3-4 times...Please help....If anyone has the Idea....

    Thanks.....
Working...