How to solve it when Report Viewer Gives Authentication Problem

Not Found

The requested document was not found on this server.

---

Web Server at myreport.com 

 

 

To Solve this problem what we need to do

Add the following line of code in your Web.Config
"< identity impersonate=true> within < system.web>  < /system.web>"

It is applied on Both for Crystal Report as well as Sql Server Reporting Services too.

Sql Server Reporting Services - Know-How About HTML-CSS Implementation in Report

Supported Browser

• Internet Explorer 5.5 and later
• Firefox 1.5 and later
• Safari 3.0 and later
  
  

HTML-Specific Rendering Rules

• The renderer builds an HTML table structure to contain all of the items in each ReportItems collection, if there is more than one.
  
  Every item within the table structure occupies a single cell.
• Empty cells are collapsed together as much as possible to reduce the size of the HTML.
• A row of empty cells is added to the top edge and another column to the left edge to improve the speed at which browsers can render the table.
• Table rows or columns that contain no items, just gaps between items, are given fixed widths and heights.
• All other rows and columns are allowed to grow depending on the size of each report item.
• All coordinates and report item sizes are converted to millimeters. All other sizes, including style properties, retain their original units. Size and position differences smaller than .2mm are treated as 0mm.

Interactivity

Show and Hide

A report item whose visibility can be toggled is rendered with a +/- toggle image and is clickable. When the item is clicked, a call back to the server takes place in order to re-render the output with the changed show or hide state.

Document Map

Document map labels are rendered and can be navigated to by using the document map in the viewer control. For omitted data region headers, labels are rendered on the first child cell. If there is no child cell present, the label is rendered on the child that precedes it.

Bookmarks

Bookmark links are rendered and appear as hyperlinks. Bookmark targets are rendered and can be navigated to by clicking the bookmark links. When a bookmark link is clicked, the report goes to the first occurrence of the target bookmark label and, when possible, the browser is scrolled so that the bookmark link is at the top of the window. HTML anchor (<a>) tags are used to mark bookmark targets.

Interactive Sorting

If a text box has user sort defined, the HTML rendering extension renders the sort icons in the text box to the right of its contents. If a report contains any text box where user sort is defined, JavaScript is rendered that causes a postback to the server when the sort image is clicked.

Hyperlinks and Drillthrough

Hyperlinks and drillthrough links are rendered as hyperlinks on report items using the HTML anchor (<a>) tags around the item on which they are defined.

Search

The Search feature allows users to search for a string of text within the report.

Additional search and find functionality is provided by the ReportViewer Web Forms control.
HTML Supporting TAGS

• Hyperlinks: <A href>
• Fonts: <FONT>
• Header, style and block elements: <H{n}>, <DIV>, <SPAN>,<P>, <DIV>, <LI>, <HN>
• Text format: <B>, <I>, <U>, <S>
• List handling: <OL>, <UL>, <LI>

Limitations of Cascading Style Sheet Attributes

• text-align, text-indent
• font-family, font-size
• color
• padding, padding-bottom, padding-top, padding-right, padding-left
• font-weight

To add HTML from a field in your dataset into a text box

1 If the Toolbox is not visible, click Toolbox on the View menu.

2 Double-click or drag a Textbox report item to the design surface.

3 Drag a field from your dataset into the text box. A placeholder is created for your field.

4 Right-click the placeholder, and then click Placeholder Properties.

5 On the General tab, verify that the Value box contains an expression that evaluates to the field you dropped in step 3.

6 Click HTML - Interpret HTML tags as styles. This causes the field to be evaluated as HTML.

7 Click OK.

Placeholder Properties


Label

Type a label for the placeholder. The label will be displayed on the design surface only.

Value

Type the value of the text box. This should be a field expression, other expression, or a label. Click the Expression (fx) button to edit the expression.

Tooltip

Type text or an expression that evaluates to a ToolTip. Click the Expression (fx) button to edit the expression. The ToolTip appears when the user pauses the pointer over the item in the rendered report.

Markup type

• None - Plain text only Display the placeholder as simple text. HTML will be treated as literal text.
• HTML - Interpret HTML tags as styles Display the placeholder as HTML. If the expression value of the placeholder contains valid HTML tags, these tags will be rendered as HTML.

SQL Server 2008 Reporting Service

Features in Repoting Service

• “Grab and Go” reporting experience enabled through the Report Part Gallery
• Support for maps and geospatial visualizations with integration to Bing maps and support for SQL spatial data types

• Additional visualizations including indicators, sparklines and data bars
• Support for consuming SharePoint lists and PowerPivot models as data sources
• Support for Madison and SQL Azure data sources
• Render any report as a data source to PowerPivot or other applications through ATOM data feeds
• Deliver reports more efficiently with the re-engineered report engine
• Limit memory usage and conflicts with non-memory bound reports
• Optimize report performance with on-demand processing and instance-based rendering
• Reach users across the organization with reports rendered in the format that makes the most sense for them
• Rendering options offer a variety of formats including HTML, PDF, CSV, XML, and Image (TIFF) as well as Microsoft Office Word and Excel
• Use subscriptions to deliver reports at a specific time and/or location
• Deliver reports through e-mail or post them to a shared folder on your network
• Enable business users to subscribe to reports, or create data-driven subscriptions to centrally manage automatic multi-recipient report delivery
• Use the Microsoft Report Viewer controls in Visual Studio to embed reports directly into your business applications or leverage the Report Viewer Web Server control to host reports in ASP.NET projects
• Publish reports to a Microsoft Office SharePoint report library or embed reports directly into portals by using the Reporting Services Report Viewer Web Part for renderings within SharePoint
• Schedule report execution, manage report subscriptions, and control access to reports through the Web-based Report Manager
• Integrate Reporting Services with Microsoft SharePoint Technologies for central manageability of reports in a familiar Office environment
• Deploy and manage all of your Reporting Services configuration options by using Reporting Services Configuration Manager

Small Script for resetting the identity column value in MS SQL Server

Normally on Microsoft Technologies we use Access or MS- Sql Server as a database. In a Software development scenario we use

Development Server ->Testing Server -> Production Server -> Client Server .

Now in this given scenario if people use Idendity Column in SQL Server Database then they come accross the problem of reseting it's value atleast i faced it and come to a solution as a script which can solve my problem at any stag as i need to reset all my identity columns on every stag. see it below

use <db_name>

DECLARE @reset_id varchar(200)

DECLARE reset_cursor CURSOR FOR

select Table_schema+'.'+Table_Name as tname from information_schema.tables

where Table_Type='BASE TABLE'

OPEN reset_cursor;

FETCH NEXT FROM reset_cursor

INTO @reset_id;

WHILE @@FETCH_STATUS = 0

BEGIN

DBCC CHECKIDENT(@reset_id,RESEED,0)

print @reset_id;

FETCH NEXT FROM reset_cursor INTO @reset_id;

END;

CLOSE reset_cursor;

DEALLOCATE reset_cursor;

Linkedin Change Password Issue

I am using LinkedIn from past 3-4 years a very good site to connect to professionals.

But here is a Scenario i am using LinkedIn from two places

(1) Office

(2) At Home

At both the places I never logged off from LinkedIn I use to just close the browser so that next time I will start browser and go to LinkedIn site and I don’t have to logged on again and again.

Two days back i have changed my password from the home computer when I went to office and started the site it is opening my account directly without asking me the new password.

It looks there is some problem in Cookies stored on my computer it has not checked whether the password is changed or not.

In my view who so ever done work on this should check the password too if it got changed.

RIA Tool LightSwitch

Visual Studio LightSwitch, it is a VS product tailored for easy creation of Line of Business applications.

* Light switch is a good product for small developments.
* With LightSwitch you can create custom applications for the way you do business. Keep your technology and business options open, while building a practical yet scalable application that matches your current needs now and in the future. The pre-built templates and components in LightSwitch are fully extensible, so you can get the specific functionality your application demands.
* Its Easy to handle as well deploy
* Get Rid of cumbersome installation processes.

* Basically you can create RIA Application though it and very fast & easy development tool.

Some Tips to work with Visual Studio

Couple of weeks back i was facing a problem as i have developed a independent Application which i need to deploy in a sub folder and run it. It is Windows based web application which need to be deployed in a subfolder. Now the problem start with Web.config file it was taking the root Web.Config but as i created an indepenedent applicaiton which has things related to the application in web.config i tried to search on google for does not find anything related to it then i tried to see resources related to Web.Config on Micorsoft and found that it is possible. How This is how you can run your application in a sub folder and use its own web.config file too on IIS Server. I have used the given code in Main Site's Web.Config file <location path="." inheritInChildApplications="false"> <system.web></system.web></location> There was another problem related to App_code folder which has some classes which i have defined for the project. Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0433: The type 'SiteSettings' exists in both 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\4af4b811\75e627a5\App_Code.i77upflw.dll' and 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\4af4b811\75e627a5\assembly\dl3\3e7d3859\c2b075c9_a13ecb01\?????????.DLL' Source Error: I tried to find the solution for it and it was prity simple what i need to do is the put all my app_code folder files in App_LocalResources this folder when you right click the Visual Studio UI automatically ask if you want to create folder like this.