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...
Oh Oh (Jaane Jaana the song just came to my mind)..... Installing powerview on Sharepoint 2010 with SQL server 2012 turned out to be a nightmare. Since I was doing the install on my local m/c, things became more harder than usual as I do not have enough memory to scatter around. So let me explain the steps I went through and the effort I had to exert in playing around with PowerView. I had SQL Server 2008 R2 installed with Sharepoint 2010 on my machine. Just for folks out there who do not want to uninstall their current SQL server version and especially if it is 2008, ensure that you install SQL Server 2008 SP2 before installing SQL Server 2012 (I am going to refer to it with the term "Denali" from this point on). If you do not install SP1 and SP2 prior to the Denali install you are in for one heck of a ride. Mark my words please do the installs prior to installing Denali. If you do install Denali without upgrading SQL server 2008 to SP2, ensure th...
Bullies!!! Who want's them around??? Sometimes life itself can be the biggest bully. You tend to face severe trials and tribulations at every step and still try to keep some time in indulging in childhood fantasies. A lot of things have been creeping me out in the recent past. I am as pessimistic as ever about my chances out there in the real world. I feel better encapsulating myself from the melancholy of life and hide in my shell. My shell is the imagination and fantasies I have the power to create. The best thing about imagination is the ability to be in control of everything that surrounds you. Maybe life can bully me around but in my dreams I can hoodwink life as it is. Three cheers to my imagination. Hip Hip Hurrah!!!!
Comments