SQL Reporting Services

• Using a SELECT statement with a searched CASE expression From sanjeevdas123 in SQL Reporting Services (130 days old)

  Using a SELECT statement with a searched CASE expression SELECT ProductNumber, Name, 'Price Range' = CASE WHEN ListPrice = 0 THEN 'Mfg item - not for resale' WHEN … more

• Reporting Services Tip From sanjeevdas123 in SQL Reporting Services (232 days old)

  Use UNION ALL rather than UNION wherever necessary. This will speed up the query exceution of the report… more

• Create row numbers based on the rows available in a table From sanjeevdas123 in SQL Reporting Services (232 days old)

  SELECT ROWID=IDENTITY(int,1,1) , EMPID, FNAME, LNAME INTO EMPLOYEE2 FROM EMPLOYEE ORDER BY EMPID … more

• Parse Numbers from AlphaNumeric strings From sanjeevdas123 in SQL Reporting Services (232 days old)

  CREATE FUNCTION [dbo].[ParseNumbers] ( @string VARCHAR(50) ) RETURNS VARCHAR(50) AS BEGIN DECLARE @IncorrectCharLoc SMALLINT SET @IncorrectCharLoc = PATINDEX('%[^0-9]%', @string) WHILE @I… more

• SQL Server: Convert to Proper case function From sanjeevdas123 in SQL Reporting Services (270 days old)

  create function ProperCase(@Text as varchar(8000)) returns varchar(8000) as begin declare @Reset bit; declare @Ret varchar(8000); declare @i int; declare @c char(1); select @R… more

• RS2005: Convert to Proper Case From sanjeevdas123 in SQL Reporting Services (274 days old)

  Public Shared Function ConvertToProperCase(ByVal s As String) As String If Not IsNothing(s) then Return UCase(Left(s,1)) & LCase(Right(s,Len(s)-1)) End If End Function… more

• DatePicker control for SQL RS2005 SP2 From sanjeevdas123 in SQL Reporting Services (472 days old)

  Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a UK locale http://support.micr… more

• Data migration in Oracle From sanjeevdas123 in SQL Reporting Services (1016 days old)

  PROCEDURE procDeptMigration IS -- -- Cursor to retrieve all the old dept data -- CURSOR cu_dept IS SELECT * FROM dept; crec_dept cu_dept%ROWTYPE; BEGIN FOR crec_dept IN cu_dept LOOP … more

• Identify and delete duplicate rows in a table From sanjeevdas123 in SQL Reporting Services (1016 days old)

  create table test (id int identity(1,1), code char(5)) insert into test (code) values ('a') insert into test (code) values ('a') insert into test (code) values ('a') insert into test (code) values… more

• Group total summary From sanjeevdas123 in SQL Reporting Services (1034 days old)

  To get grand total summary for individual group totals, add the group header or footer cells with the correct value,you may rename this cell as grpTotal.Then add a textbox in the Report Footer and use… more

• Export Data to Excel Using Template From sanjeevdas123 in SQL Reporting Services (1149 days old)

  Create PROCEDURE SP_ExportDataUsingTemplate @File_Name as varchar(50) = '' AS BEGIN SET NOCOUNT ON DECLARE @Cmd varchar(1000) DECLARE @fn varchar(500) DECLARE @provider varchar(100) DECL… more

• Export Data from SQL Server to Excel From sanjeevdas123 in SQL Reporting Services (1149 days old)

  CREATE procedure dbo.ExportData(@filePath as varchar(500)) as begin DECLARE @Provider VARCHAR(200),@ExcelString VARCHAR(200),@SQLString VARCHAR(200) DECLARE @Sql AS VARCH… more

• Switch function in reporting services From sanjeevdas123 in SQL Reporting Services (1577 days old)

  You can use Visual Basic functions to evaluate an input value and return another value depending on the result. The following expression also returns one of three values based on the value of PctCo… more

• Alter the query that is used to retrieve data for the report. From sanjeevdas123 in SQL Reporting Services (1577 days old)

  In some complex reports, you may want to vary the query that is used to retrieve data for the report. For example, you may want to provide users with a list of departments by which to filter data, or … more

• Hide parameters in the report From sanjeevdas123 in SQL Reporting Services (1577 days old)

  Use rc:parameters=false to hide the parameters. http://rsServer1/reportserver?/Commercial Analytics/Units and Net Sales&rc:toolbar=False&rc:para­meters=false&CategoryValueID=5­5… more

• SP2 print landscape issue From sanjeevdas123 in SQL Reporting Services (1577 days old)

  There is an oversight in the documentation of the new client print functionality of Reporting Services Service Pack 2. SP2 has a new behavior that extracts the page size and margin information at repo… more

• Clear Report Cache From sanjeevdas123 in SQL Reporting Services (1583 days old)

  To clear report cache in the browser user rs:ClearSession=true http://server16/reportserver?%2fApp+Reports+Development%2fSimplePlanningRpt&rs:ClearSession=true This will create a new version… more

• Convert Numbers or Currency to English Words From sanjeevdas123 in SQL Reporting Services (1583 days old)

  Public Function NumToString(ByVal nNumber As Currency) As String Dim bNegative As Boolean Dim bHundred As Boolean If nNumber < 0 Then bNegative = True End If nNumber = Abs(Int(… more

• RS Code sample From sanjeevdas123 in SQL Reporting Services (1583 days old)

  While SQL Server Reporting Services supports a variety of built-in aggregates, one of the things that people ask for is the ability to define custom aggregates. While this is not directly supported in… more

• print reports from url From sanjeevdas123 in SQL Reporting Services (1583 days old)

  there is a way to print directly from a URL (apart from having to select the printer!) The command is "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" Example: http://rsSe… more

|