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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Help in chart building

Author  Topic 

1sabine8
Posting Yak Master

130 Posts

Posted - 2007-10-27 : 10:14:44
Hi, i need to build a chart in reporting services, i need some help cos it's the first time i do it. i have a table with columns : date, service, comment_card_id and restaurant_name. the service values can be:"Superior", Excellent", "Good" or "Not Satisfactory" .I created three parameters :restaurant, from date and to date. I want to be able to show on my chart the percentage of Superior, Excellet, Good, Not Satisfactory service from the count of the all comment cards after having chosen the date range and the reataurant name. So i thought that my category should be the service and my data the percentage with filters on restaurant name and date range. Should the date be in the category or it can be in the filter? Can anyone give suggestions please?
   

- Advertisement -