Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts

Tuesday, December 31, 2013

ssrs 2005

doesn't have quick totals - boo

Monday, November 26, 2012

'RSClientController' is undefined

I had to change the app pool managed pipeline to classic

Tuesday, June 26, 2012

setting reporting service identity

having big problems with that , as the text box was greyed out. First I changed the apppool. After that I had to restart the services (otherwise got bizarre error) :
System.Runtime.InteropServices.COMException (0x800706B3)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at System.Management.ManagementObject.Get()
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

Sunday, March 4, 2012

Reporting services divide by 0

RS handles ints differently than floats

regarder:
creat table thus
create table test3(a int,b int,c decimal(18,3),d decimal(18,3) )goinsert into test3 values(0,4,0,67)
BTW I use the following code to avoid issues

 Public Function Divide(ByVal first As Double, ByVal second As Double) As Double
        If second = 0 Then
            Return 0
        Else
            Return first / second
        End If
    End Function
I didnt have luck or time to figure out the other ideas I've found on the internet