I need a simple help on my SSRS reporting services I created as a stock report. Everything is coming out right except I need some help to write some condition for my report to show the records if the Quantity is 0. I am getting all the records but its not showing the the one with 0 quantity. Need help and any suggestion. I am having only 6 fields on my report coming from different 4 tables. Thanks and appreciate your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Show the records on 0 Quanity in Stock
- Thread starter MoeSSRS
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
The SQL Query and table layouts would come in handy here.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
- Thread starter
- #3
It seems I think I should split into 2 reports one is without zeros and the other one is only with zeros. So I write an expression within the Qty on Hand field as follows and it seems its showing me only 0 on the records but it also showing other records which is >0. What I need on this report to show only records with 0 not the other ones. Let me know I could do any changes on this expression. Thanks and appreciate your quick response. Here is the my expression and let me know anything I could add on this not to show other records except 0. Thanks!
=Iif(Sum(Fields!QTYRECD.Value-Fields!QTYUSED.Value)="0",0,"")
=Iif(Sum(Fields!QTYRECD.Value-Fields!QTYUSED.Value)="0",0,"")
- Thread starter
- #4
Good News! Just want to let you know I figured it out. I create 2 seperate reports one is to all the records with out 0 Qty and the other reports is only show records with 0 Qty.
The second I created as name Zero in Stock Quaity report and I put it on the Edit Group property section i.e. Visibility I put this expression as follows to show only records with 0 Qty. Here is the expression below is sombody needs it.
=Iif(Sum(Fields!QTYRECD.Value-Fields!QTYUSED.Value)="0",False,True)
This takes care to show only records has 0 Qty. Thanks!
The second I created as name Zero in Stock Quaity report and I put it on the Edit Group property section i.e. Visibility I put this expression as follows to show only records with 0 Qty. Here is the expression below is sombody needs it.
=Iif(Sum(Fields!QTYRECD.Value-Fields!QTYUSED.Value)="0",False,True)
This takes care to show only records has 0 Qty. Thanks!
- Thread starter
- #6
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question