Need SSRS format help
-
Hi Need to hide the Repeated District name only in SSRS I am getting Query output like this District Name Date count ------------------------------------- VSP TL 01/01/2009 20 VSP AM 01/06/2009 10 VSP TM 01/08/2009 100 Hyd TL 01/01/2009 20 Hyd AM 01/09/2009 10 TPT TL 01/01/2009 20 TPT TM 01/06/2009 190 Expected Output I need out put like this in SSRS District Name Date count ------------------------------------- VSP TL 01/01/2009 20 AM 01/06/2009 10 TM 01/08/2009 100 Hyd TL 01/01/2009 20 AM 01/09/2009 10 TPT TL 01/01/2009 20 TM 01/06/2009 190
-
Hi Need to hide the Repeated District name only in SSRS I am getting Query output like this District Name Date count ------------------------------------- VSP TL 01/01/2009 20 VSP AM 01/06/2009 10 VSP TM 01/08/2009 100 Hyd TL 01/01/2009 20 Hyd AM 01/09/2009 10 TPT TL 01/01/2009 20 TPT TM 01/06/2009 190 Expected Output I need out put like this in SSRS District Name Date count ------------------------------------- VSP TL 01/01/2009 20 AM 01/06/2009 10 TM 01/08/2009 100 Hyd TL 01/01/2009 20 AM 01/09/2009 10 TPT TL 01/01/2009 20 TM 01/06/2009 190
Why dont you modify the query for that ... .
Distinctkeyword is what you need I think... :doh: Does this question belongs to ASP.NET ?Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Windows7 API Code Pack
Simplify Code Using NDepend
Basics of Bing Search API using .NET -
Why dont you modify the query for that ... .
Distinctkeyword is what you need I think... :doh: Does this question belongs to ASP.NET ?Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Windows7 API Code Pack
Simplify Code Using NDepend
Basics of Bing Search API using .NETI have done through SSRS Grouping. Question is not related to ASP.NET But I could not find the SSRS Questions here? So Where can I post SSRS Related Queries?
-
I have done through SSRS Grouping. Question is not related to ASP.NET But I could not find the SSRS Questions here? So Where can I post SSRS Related Queries?
Yes This is the Right Forum..! But You Will get little help for SSRS..! so Better try this forum..! http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads[^] The above link is the best forum for ssrs i got very good help from tht forum try this link it may help..! http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f37b8965-b4ca-471c-ae24-f85b8176d51e[^]
LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.