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  Development Tools  Reporting Services Development  Dynamic Query

Author  Topic  bisc8 Starting Member 1 Post Posted - 2006-08-02 : 13:02:36 Hi!!! I'm having trouble with a dynamic query that involves 2 parameters: Teste and Day. With only the first Iif (testing Teste) everything was fine, but when I added the second.. I just can't get it to workSad I'm using the Visual Studio 2005 Reporting Services. Here's the query: ="SELECT DateDimension.Day, SiteDimension.TLD, sum(NetPanel.NrVisitedPagessNP) AS NrVisitedPagesNP " & "From NetPanel " & "INNER JOIN DateDimension " & "ON NetPanel.DateID = DateDimension.DateID " & "INNER JOIN SiteDimension " & "ON NetPanel.SiteID = SiteDimension.SiteID " & "INNER JOIN UserDimension " & "ON NetPanel.UserID = UserDimension.UserID " & Iif(Parameters!Teste.Value = "0", "", " WHERE SiteDimension.TLD = '"& Parameters!Teste.Value & "' " ) & Iif(Parameters!Day.Value = "0", "", " WHERE DateDimension.Day = '"& Parameters!Day.Value & "' " ) & " group BY SiteDimension.TLD, DateDimension.Day" Any ideas? Thanx!!! Kathy