Hi

Try this :

SELECT [UserName]

,[Data] , ROW_NUMBER() OVER (ORDER BY [UserName]) AS ID

INTO A FROM [EmployeeDB].[dbo].[User]

SELECT [UserName] ,[Data] FROM A WHERE ID IN (

SELECT...

Hi,

You can write one stored procedure and Call it through SSRS.

In SSRS you can display the data easily. So I dont see any issue in that.

Thanks

Hi

I created a table called User and inserted the records.

SELECT [UserName],[Data] FROM [dbo].[User]

This is the query which will give maximum value :

select UserName,MAX(Data) AS MaxValue from [User] group...

Hi

Check the following link this might help :

http://msmvps.com/blogs/martinpoon/archive/2006/12/08/installation-of-sql-server-2005-in-windows-vista-warning-message-on-iis-feature-requirement-during-system-configuration-check.aspx

Thanks

Hi,

Try installing .NET Framework first and then install SQL Server.

This can be done be using ISNULL() check.

SELECT

ISNULL(column_name1,'') AS "ColumnName1",

ISNULL(column_name2,'') AS "ColumnName2"

ISNULL(column_name3,'') AS "ColumnName3"

FROM table FOR XML PATH('Table'), ELEMENTS

The report shows the annual report of the sales for the company. We usually get around 65000 rows.

Is there a possiblity of connection timeout while generating the report?

Hi

I am facing an issue in page break when the report is rendered as web archive. I have applied PageBreak for the report on a group. This page break...