Wednesday, February 25, 2009

VSDoc for jQuery 1.3.2

Another great news new version of Jquery 1.3.2 is released.

Key features:
1. Fixes some bugs include one involving selector performance in IE.
2. The 1.3 release adds exciting features such as selector performance improvements, "live events" where events can be bound to both current and future elements, and more.




Other related links
1. 1.3.2 (Release Notes)
2. List of all versions in single page to download
3. Jquery documentation Download.

Login name must be specified. (SqlManagerUI)

Problem

The login failed.
Login failed for user '[computername]\ASPNET'



Solution:
1. Create a new user '[computername]\ASPNET' in SQL database.
2. For particular database, add this user and give the permissions atleast dbo role.

This will solve the problem.

do not hesitate to leave a comment on any unsuccessful or successful config.

unable to start debugging on web server. Configuration system failed to initialize. Asp.net

Thursday, February 12, 2009

Error to read data from file : Access to the path ' ' is denied.

Hello,
I found the solution to this.
Give full control access to the user " IWAM_ "
that's it.




Select the IWAM_ user and give full control to it.

Tuesday, February 3, 2009

Null problem with many dropdowns in Reporting Services

By using this query to populate the dropdown you can insert null in the datasource

For one column
1. SELECT ColumnName FROM TableName UNION ALL SELECT '' AS Expr1 ORDER BY ColumnName

For two columns
2.
SELECT col1,col2 FROM T_TER_TERRITOIRE_FONCTIONNEL UNION ALL
SELECT '','NULL' AS Expr1 ORDER BY col1 ,col2

Monday, February 2, 2009

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

.. soon will give all the possible solutions to this.

Sunday, February 1, 2009

Reporting Services : Parameters in stored procedures. Step by step explanation.

Description:
* Step by step to make Reports using Stored procedures and parameters in Reporting Services.
* Going to explain how to use Reporting Services using parameters through Stored procedure.

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface. Reporting services features a web services interface to support the development of custom reporting applications.

In SSRS, reports are defined in Report Definition Language (RDL), an XML markup language. Reports can be designed using recent versions of Microsoft Visual Studio[1] with the included Business Intelligence Projects plug-in installed or with the included Report Builder, a simplified tool that does not offer all the functionality of Visual Studio. Reports defined by RDL can be generated in a variety of formats[2] including Excel, PDF, CSV, XML, TIFF (and other image formats[3]), and HTML Web Archive. SQL Server 2008 SSRS can also prepare reports in Microsoft Word (DOC) format.

For more information, you can visit microsoft web link here.
Description:
* Step by step to make Reports using Stored procedures and parameters in Reporting Services.
* Going to explain how to use Reporting Services using parameters through Stored procedure.

>>To create a new Reporting Services. Follow this.
a. Start>>Programs >> MS SQL Server 2008(5) >> SQL server Business Intelligence.




*Create a new project of Report Server Project, in our case "TestR".





* Add new Report to the project



* I took a sample db and a sample stored procedure which uses more than one parameter. Below given is the sample stored procedure.


* This is how you have to assign the stored procedure to the report


* Select your own report format and design.


*Design


*Report


*Usage of stored procedure and defining the parameters.


*In the preview of the report you will find the parameter controls to be entered or
to be selected.


* After entering the data into the controls and checking the report you will get the report.




So simple to create a report and have a professional look on the reports.