.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Report always fails, need description

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server

OK, this may sound like a total noob question:

I'm not too familiar with SSRS.  I've created stored procedures for report data sources, and I've built and deployed a few reports over a year ago.  Other than that, I haven't used it much.  Now we have a report that seems to always fail.  It is part of the CRM application, and was not created by us.  We are using SQL Sentry to monitor that server, so that's how I realized it was failing.  However, I can't figure out why it's failing.  I need to be able to see some detailed info regarding the failure (i.e. the kind of info one might see in a job failure step from SQL agent).  I'm not really sure how to proceed.  If someone could point me in the right direction, that would be great. 



View Complete Post

More Related Resource Links

A tsql report with multiple counts and pivioted description attributes

Hello,   I have an assignment in which I am to prepare a report displayed in excel to return counts of various attributes in the database. However, the count is a bit challenging because it requires counting certain attributes in a pivot format illustrated below. The counts for each category by recruiter, rolled up by Division, within the specified time frame.   The tables that I would have to deal with are as follows:   User: Has the number of Accounts…user accounts with no Recruiter are unassigned Recruiter: Has the recruiter information LoginHistory: Has a record of all logins EForm: Has the various forms, for example: Release and Authorization, Provider Service Agreement EFormUserXref: You can filter it to return the Physican AppForms                                                                       Surgery                                      &n

Report Output [12331] Description: Cannot open the datafile

I have a wired problem here,  I am getting the following error message when the job is executed by sql agent. "Executed as user: domain\user. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  5:15:01 PM  Error: 2010-09-16 17:15:58.67     Code: 0xC020200E     Source: DFT  FFD Report Output [12331]     Description: Cannot open the datafile "\\serverpath\MyList.csv".  End Error  Error: 2010-09-16 17:15:58.68     Code: 0xC004701A     Source: DFT My_List DTS.Pipeline     Description: component "FFD Report Output" (12331) failed the pre-execute phase and returned error code 0xC020200E.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  5:15:01 PM  Finished: 5:15:59 PM  Elapsed:  58.391 seconds.  Process Exit Code 1.  The step failed." This was working fine from years, but has started giving this error from past 3 days. When I run manually this SSIS package it works fine without any errors. Nothing has been changed. Please help. Thanks in advance.

Bug report: MouseMove on document fails over disabled objects.

I found a bug in the event handler code of the client library related to document-mousemove and disabled DomElements. Steps to reproduce: 1. Add an input button to the page and disable it:               <input type="button" id="Button1" value="Button 1" disabled="disabled" />  2. Attach a mousemove event to the document in the init event of the application:              Sys.Application.add_init(function() { $addHandler(document,'mousemove',function(e) { }); }); 3. Run the page in IE and move the mouse over the disabled button. An exception is thrown:             Microsoft JScript runtime error: Sys.ArgumentException: Value must be a DOM element. Parameter name: element This problem occurs because the event target is not null, but an empty object. The DomEvent handler tries to get the location of the element, but fails when it realizes that this is not a DomElement (Since MSAJAX doesn't check for argument types in non-debug mode, it there tries to get a property of the object that doesn't exist which fails too). Because of IE's buggy mouseover/out eventhandlers, attaching a mousemove event to the document is

report is stuck after addition of description to code column


Hey everybody

This is rather odd and anoying..

I have a simple report with one table and some 4-5 fields in its columns.

No groups,sorts or filterring.

Every thing goes well until i add another column to report with some desccription (lets say area name).

This addition makes the report stuck..

Running the data set alone in reports data section is fine as well.

Have anyone seen this odd behavior?

Any idea what mite cause it or how should i debugg it??

Data set contains some 10,000 rows.

Thanks alot for your attention



Programmatically generating html report using ReportExecutionService class fails


Hello All,

I am utilizing the ReportExecutionService class in MSRS 2008 to programmatically generate reports in a .NET Windows program. I have two Web References, one for ReportingService2005.asmx and one for ReportExecution2005.asmx. I am using ReportExecution2005 namespace to instantiate the ReportExecutionService object.

The problem is that generating report content using the ReportExecutionService.Render method is not working consistently. It works a few  times and then throws a 
"Client found response content type of '', when expected 'text/xml'. This is happening for reports that worked great on a prior test (same report name, same path, same parameters). Does anyone know if I need to change any settings in SSRS to correct this issue. Below is the code

ReportExecutionService res = new ReportExecutionService();
res.Timeout = System.Threading.Timeout.Infinite;
res.Url = url.vvlu_char_vlu_cd.ToString();

res.Credentials = System.Net.CredentialCache.DefaultCredentials;
// Render arguments
byte[] result = null;
string reportPath = @"../../../Stuff";
ExecutionInfo ei = new ExecutionInfo();
ExecutionHeader eh = new ExecutionHeader();
res.ExecutionHeaderValue = eh;

string format = "HTML4.0";
string devInfo = @"<DeviceInfo><Toolbar>False</Tool

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

ToggleDebugCompilation fails trying to perform "an unauthorised operation"



We're having a problem with the Visual Studio 2008 RTW version of the web deployment projects on a colleagues machine. The project works fine if I run it on my machine, but when he tries to run it on his machine he gets:

<SNIP : Most output removed>
  Task "Exec"
    if exist ".\TempBuildDir\" rd /s /q ".\TempBuildDir\"
  Done executing task "Exec".
  Using "ToggleDebugCompilation" task from assembly "C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.Tasks.dll".
  Task "ToggleDebugCompilation"
    Updating Web.config <compilation> element debug attribute to 'True'.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error : Attempted to perform an unauthorized operation.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: The "ToggleDebugCompilation" task failed unexpectedly.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: System.ArgumentNullException: Parameter "message" cannot be null.
    C:\Program Files\MSBuild\Microsoft\WebDeployment

How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


populate report viewer by code


Hi all

I have a button "Show Report" to show some data from table

what I should write under this button to populate the reports ?

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


May i use the collapse and expand feature (like tree menu) in Report ?


HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .


I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
If any one have experince before please share the ideas.


Best Regards

Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

Dynamic Report in reportviewer


HI I m sorry to say this But this task too urgent.

 Ex- i have two tables in my db name called Comdetails, deptdetails.

TCS is a one company name stored in ComDetails and Company_ID took as primany key,

TCS having 10 department stored in deptdetails and Company_ID as foreign key.

so now in DB we have available one company with 10 departments.

so now i need to generate report , i m using report.rdlc and reportviewer.

i hope upto now its clear.

my task-

1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Report viewer error


  • An error has occurred during report processing.
    • A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1".

  • i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help

Printing crystal report from webservice



I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in crystalreportviewer by passing the webservice call to datasource. However, is there anyway, I can print directly without showing the report?

Alternatively, I was trying return ReportDocument object from webservice, which would solve my problem, but I was unable to return the ReportDocument because of serialization issue. Is it even possible? Thank you


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend