Rapid Reporting Services Reports
www.ExpressReporting.com
BETA
Home
|
About
|
Donate
Home
Report Builder
Recall Your Report
Show Demo
Step 1 - Import
Step 2 - Configure
Step 3 - Report
Step 1 - Paste XML
a)
Create a VIEW in your SQL Server database that joins and selects all the feilds you want to contain in your report.
b)
Enter the name of your VIEW here:
.
c)
Reporting Services version:
d)
Copy this SQL SELECT statement and run it in your Query Analyser:
------------------------------ -- www.ExpressReporting.com -- -- SCRIPT SQL Server 2005 -- ------------------------------ SELECT '1.0' as XMLVersion, '<View, string,>' as Alias, @@Language as language, substring(@@Version,0,26) as Version, SERVERPROPERTY('ServerName') as [Server], db_name() as [Database], (SELECT count(*) FROM <Scheme, string,>.<View, string,>) as TotalRecords, (SELECT sch.name FROM sys.objects sob LEFT OUTER JOIN sys.schemas sch ON sob.schema_id = sch.schema_id WHERE sob.object_id = obj.id) as [Scheme], obj.name, '' as logoUrl, rtrim(obj.xtype) AS objType, col.name, col.name as Alias, 'true' as Display, '' as Filter, col.colorder, col.length, col.xtype FROM dbo.syscolumns col INNER JOIN dbo.sysobjects obj ON col.id = obj.id WHERE (obj.name = '<View, string,>') ORDER BY obj.name, col.colorder FOR XML AUTO
e)
Copy the query result (XML) out of Query Analyser and paste it here:
Required
Terms of use