Monday, July 21, 2014

SQL Server Reporting Services "An error occurred during local reporting processing. Object reference not set to an instance of an object."

SQL Server Reporting Services "An error occurred during local reporting processing. Object reference not set to an instance of an object."


"An error occurred during local reporting processing. Object reference not set to an instance of an object."

when I try to Export the report output to PDF it gives the following 


SOLUTION can be. 


This error message indicates the object reference is not set to an instance of the object. It can be caused by one or more of the following reasons.


  • There are soft page breaks within empty lists in the report.
  • There are hidden groups within the report and you tried to export it to PDF.
  • The report has a link to a subreport that is not published on the report server and you tried to export it to CSV.
  • There are text boxes with a width and/or height of zero in the report.
  • A text box is either hidden or the NoRows property is set to true.
  • A text box spans table cells where some cells have a collection of null values.
  • The report has static columns and/or rows and, in the Visibility properties, Hidden is set to true.
  • The report has static columns and/or rows and there are grand totals in the report.
  • The report has static column headings and, in the Visibility properties, Hidden is set to true.
  • The matrix report has multiple columns and rows and, in the Visibility properties, Hidden is set to true and you tried to export to PDF or TIFF.




Saturday, July 19, 2014

HTML/HTML5 Input type=“file” Accept Attribute File Type


Valid Accept Types:

For CSV files (.csv), use:
<input type="file" accept=".csv" />

For Excel Files 2003-2007 (.xls), use:

<input type="file" accept="application/vnd.ms-excel" />

For Excel Files 2010 (.xlsx), use:
<input type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />

For Text Files (.txt) use:

<input type="file" accept="text/plain" />

For Image Files (.png/.jpg/etc), use:

<input type="file" accept="image/*" />

For HTML Files (.htm,.html), use:

<input type="file" accept="text/html" />

For Video Files (.avi, .mpg, .mpeg, .mp4), use:

<input type="file" accept="video/*" />

For Audio Files (.mp3, .wav, etc), use:

<input type="file" accept="audio/*" />

For PDF Files, use:

<input type="file" accept=".pdf" />