visual studio 2010 - SQL Server Reporting Services Returns Too Many Records -


I have 3 large tables in SQL Server 2012 that are related to all phone numbers. ..

"An error occurred during the local report process that occurred during the processing of an error during the processing of an exception occurred. 'System: When I create a report with Visual Studio BI reporting wizard I receive the following error The auto-exception was thrown "."

I think the report is returning too much records if it is run. How can I turn it on? Or other suggestions?

The query used in the report is given below 

  select table1.customer_phone, table2. PhoneNumber, table3.ANI LMIRSIONS from within table1 table2.PhoneNumber based on combination = table1.customer_phoneInbound table2.PhoneNumber = table3.ANI  join table3

Consider adding one or more add report to the returned SSRS to limit the number of records:

. By looking at

  • It may be wise to see the parameters -

    • A parameter may be considered below PhoneNumber value By limiting the results of the report by date and / or time also (table name LMIRSessions , which I can expect from columns such as SessionStart and SessionEnd ).

    • In the last (also the table name LMIRSessions ), there are probably the results of the report by the Session Type (narrow to identify by the potential criteria are ) Or result (s).

    It may also be wise to consider the report result even without domain-specific filtering parameters like I suggested above, To limit the number of records you can use (and require the necessary resources)


    • Comments

    Post a Comment

    Popular posts from this blog

    ios - How do I use CFArrayRef in Swift? -

    I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
    Read more

    eclipse plugin - Run java code error: Workspace is closed -

    To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
    Read more

    c - Error on building source code in VC 6 -

    When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
    Read more