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 2000 Forums
 SQL Server Development (2000)
 Analysis Services

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-09 : 08:28:52
Kishore writes "Hi friends,

I am working on a report generation project with SQL Server2000 analysis services. I am able to generate the report with required fields. But the problem with the report is it's showing the unwanted records also like i don't want to display the products with no sales in the report.

I tried in no.of ways to eliminate the records with no sales, but i am not able to. Please suggest me a answer for this.

Thanks
Kishore"

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-05-09 : 10:58:46
Kishore,

Post your table definition, some sample data, and the output you want.

Ken
Go to Top of Page
   

- Advertisement -