Adding All to SSRS report parameters giving out of memory exception
SSRS report is failing while selecting the All parameter Now let me begin by giving a case statement whereby I have added 'ALL' to my SSRS report parameters dropdown. But whenever I select the ALL option I run into the out of memory exception because the report is executing in a never ending loop. Here are samples of the issue @ hand and how I went about fixing the same For example==> Let me say that I have a Country dropdown for the following SSRS report (using Adventureworks). The SSRS dataset Report Query is as follows: SELECT adr.AddressLine1, adr.AddressLine2, adr.PostalCode, adr.City, sp.Name, cr.Name AS Country FROM Person.Address AS adr INNER JOIN Person.StateProvince AS sp ON adr.StateProvinceID = sp.StateProvinceID INNER JOIN Person.CountryRegion AS cr ON sp.CountryRegionCode = cr.CountryRegionCode and (cr.CountryRegionCode = @country) As you notice the parameter I am using is @country. The @country parameter is populated initially by using the following q...