.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

Reports & Application Developemtn

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Okay I need some strong advice  here.. I have 2 queires.. One query gives the list of all the reports that we have and are scheduled to be delivered we use SQl agent job... 2 Query is a View which gives the list of all users who get the reports...What i am trying to do is May be combine both queries or link them so that i can control the reports level security. Each user has a Security level and based on that level we give access. These reports are viewed on our company portal...Any ideas ?FM

View Complete Post

More Related Resource Links

Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services


SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004

Crystal Reports: Add Professional Quality Reports to Your Application with Visual Studio .NET


Crystal Reports for Visual Studio .NET provides a comprehensive reporting solution for .NET developers that is thoroughly integrated with both the Visual Studio .NET IDE and the .NET Framework. Crystal Reports supports ADO.NET, XML Web Services, and ASP.NET server controls and caching. It also integrates seamlessly with the Visual Studio .NET Server Explorer, toolbox, and design environment. It has a rich programming model and flexible options for customizing and deploying reports. These major features and others covered here take the drudge work out of data representation in your own applications.

Andrew Brust

MSDN Magazine May 2002

Creating reports in a WPF application

I am trying to create a custom report in a WPF application but cannot find any way to do this as in WinForms. Does anyone know how to create custom reports in WPF?  I would even take exporting data to a Word document template using parameters. Does anyone know of any good information for accomplishing any of the two above?

Server Error in '/Reports' Application.


Hi All,

i have successfully deployed report in to sharepoint and it creates Reports folder automatically. when i try to click on that folder it gives me below error. Please help Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.

Source Error:

Line 186:  <machineKey validationKey="F771D052DF0BBA5CDA4B98FECA1F30645C7EFFB5A57CDFAF" decryptionKey="DB45B12512A41882B11FF4BD7E822B2456A375D48F3C8E15" validation="SHA1" />
Line 187:  <!--<sessionState mode="InProc" timeout="200" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=, Culture=n

Display Reports using a web application


I am using Windows server 2008 , IIS 7.

I am creating a web application and trying to display reports using a reportviewer.

But I am unable to view reports in the browser when tryig to run the application.

Configures the IIS with web application path.

Please suggest what i need to do to view reports.



Error while Rendering Reports(Reporting Services 2005) in .Net 1.1 web Application on IIS 6.0


I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or  something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

Client need to open auditing reports in excel application not in browser


Good day,
I encountered with this issue in MOSS 2007. Auditing reports was opened from common SharePoint auditing page.
This page contains hyperlinks to auditing reports.
When any user tries to open this hyperlink, "open file" dialog does not appear, instead of this a IE browser silently open in text XML format.
I suppose that common behaviour is when user open a hyperlink, report will open with excel application through "open file" dialog.
For example, hyperlink in SharePoint contains URL:

QUESTION: how build/create sql reports via a C# application using own user interface:


Hello all,

I would like to know if it is possible to create my own user interface, to enable me to print / create my own sql reports using the "sql reports builder". The C# user interface would simply add the various fields and parameters that one would normally add if you run the sql report builder by itself.

Is this possible? And if so could someone please point me in the right direction / site tutorials to do so/

Many thanks and kind regards





Cannnot load SSRS 2008R2 reports under app domain context of a web application


I'm a novice to SSRS 2008R2 and have SSRS 2008R2 reports which got upgraded from SSRS 2005. I need to load those reports from a web application. The reports use custom data processing extensions. Reports run fine from Visual Studio 2008 IDE. I'm running a Windows Server 2008R2 machine.

In order to load configuration information specific to the web application, underlying framework used as a data access layer utilizes AppDomain.CurrentDomain.FriendlyName to decide the name of the web application. The frame work is a separate assembly referenced in my web application project.

Previously, while using SSRS 2005, since IIS was used to host the report server virtual directories, the web application name was easily determined from the current application domain. With SSRS 2008R2, the virtual directories are hosted by the report server itself by making use of http.sys ( not quite sure how this works exactly yet). The friendly name I get from the app domain is not what I expect, i.e., my web application name. Instead, I get something like this: ReportServer_MSSQLSERVER2K8R2_0

Any suggestion how to resolve this issue?




Linking to Reports in Document Library from .net web application


I have a document library that contains some SQL Reports.  I have crearted a .net web application and I have a page that has links to the reports.  I got the following error message:

Reporting Services does not support anonymous user from a SharePoint site. To view Reporting Services reports, choose a SharePoint site that does not have Anonymous access enabled or sign in on an anonymous site.


So, I turned on Anonymous access for the site, and gave the document library view for anonymous access.  Now I can access the applications without an error message, but others are still getting this error message when they try to access from the link.  Does anyone know why this would happen?  Thanks.

Converting web application from 2005 to 2008 with crystal reports



I have a web application developed in Visual studio 2005. I need to convert it to Visual Studio 2008.  The problem is that the application is using crystal reports. When I'm trying to run a page with CrystalReportViewer I am getting the following error:

Could not load file or assembly 'System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

How do I solve this problem?


Microsoft's Collaborative Application Markup Language (CAML) Loop

discovered an interesting error recently while working with Microsoft's Collaborative Application Markup Language (CAML) that, surprisingly, had received no ink. Partly what surprises me about this is that the error may require you to rewrite large sections of your code if you haven't previously considered this SharePoint limitation. I'll start with some context, but first of all the error is:

Integrating a Legacy Web Application in SharePoint

This month we will continue with the theme of deploying Microsoft's SharePoint as a company intranet by describing a method for integrating a legacy Web application inside a SharePoint site.

In many companies the intranet site is not just a home page with announcements. It houses Web applications used by many different departments. In last month's article, I built a page to search the employee table in Northwind (the sample database included in Microsoft's SQL Server). This month, I will move the Web pages used to add/remove records from the table into the SharePoint intranet.

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

Application architecture in asp .net

Application Architecture is the most important process of developing a good application. Some people tends to jump into coding without any architecture laid. Later we see those people changing the architecture and finally the application had to be developed from the scratch with the correct architecture.

In this article I will describe some details about how you can improve the architecture of you application. This article is targeted to the beginner's audience.

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.
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