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 |
|
Balage_Baju
Starting Member
8 Posts |
 Posted - 2009-01-14 : 23:39:28
|
| Hi, We have a requirement to display the Product sales report in line graph. Users can select any no. of products as input (no. is not fixed) against a particular time period. For all the selected products we want to get the sales for the selcted time period. For example,Consider products X,Y,Z are selected as input and the Time period is 2009, then the report should show 3 different lines in graph each one for each product. If the no. of products is fixed we are able to achieve the target. Here no. of products is dynamic hence we are not able to get the solution.Please provide your valuable suggestions.Thanks,Balaji. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 00:08:59
|
| have a look at STRTOSET() function in books online |
 |
|
|
Balage_Baju
Starting Member
8 Posts |
Posted - 2009-01-16 : 04:45:26
|
| Thanks Visakh, we will check this functionThanks,Balaji. |
|
|
|
|
|
|
Dynamic MDX Query with SSRS