RDL Generation without UI

Hello,
I've seen the RDL is schema and to say the least its quite massive.
We'd like to generate RDL files from a schema that leaves out UI definitions.
Is there a more light weight schema for this? Is there also a white paper
that describes the schema parts and what they mean?
Thanks
--
MCSD.NETYou can download a PDF document about the RDL 2003/10 schema used in RS 2000
here:
http://www.microsoft.com/sql/reporting/techinfo/rdlspec.mspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramzi" <Ramzi@.discussions.microsoft.com> wrote in message
news:44291661-066E-43E7-9140-892915E91495@.microsoft.com...
> Hello,
> I've seen the RDL is schema and to say the least its quite massive.
> We'd like to generate RDL files from a schema that leaves out UI
> definitions.
> Is there a more light weight schema for this? Is there also a white paper
> that describes the schema parts and what they mean?
> Thanks
> --
> MCSD.NET

RDL generation problem

Hi,

I am working with SQL Server 2005 Reporting Service from few days, though I am

not expert, for some reason I have to run on field without having sound

knowledge of RDL, but need your help, gys. I am using SQL Server Business

Intelligence Development Studio to design report.

Here is the procedure of my work to populate a RDL report

I used a stored procedure for the DataSet of my RDL

Then I drag and drop necessary field to my report layout.

Put required parameters to preview tab and then run report.

This is quite simple, I didn't face any problem with this process, even though

the process may not correct, but working perfect. My problem is

when the stored procedure returns multiple result set. The data tab only

shows the first result set though the SP returns multiple result set, I have

run the SP in the Query Analyzer. I don't want change my stored procedure.

And please give me some suggestions about the best procedure

to develop RDL report in real life.

Please reply me ASAP, it’s very urgent.

Thank youTareqe

Hi there,

SQL RS doesn't support multiple resultsets. You will need to either write a wrapper stored procedure to retrieve the dataset you want or modify your stored procedure.

regards,

Andrew

RDL Generation

Does anyone know of projects in development to create RDL files from HTML
and/or PDF files? I have to think that if Microsoft has created a render
from RDL to PDF that the reverse would be fairly simple to complete as well.I doubt there is such a thing currently...I certainly haven't seen it
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"rbowlin" <rbowlin@.discussions.microsoft.com> wrote in message
news:D9FFCD4B-845B-42DD-895D-7815E5E0828F@.microsoft.com...
> Does anyone know of projects in development to create RDL files from HTML
> and/or PDF files? I have to think that if Microsoft has created a render
> from RDL to PDF that the reverse would be fairly simple to complete as
> well.|||There is a *huge* difference in going from RDL to <format> versus <format>
to RDL. RDL is a data-driven template for producing a report, and is far
more succinct. Any <format> is the marriage of a template and a specific
set of data.
Reverse engineering an instance of a report into its template would require
a lot of pattern recognition. Some repeating groups like headings and such
could be easily determined, but depending on the flexibility of the source
report generator, some of the other patterns could be a bear to parse.
Also, depending on the set of data used to generate a report instance, you
may not get complete fidelity in the template generation as the data set may
not exercise all of the possible scenarios.
Teaching software to parse <format> would not be impossible, but it would be
difficult and would likely capture less than the full template in the end.
A better shot would be to convert a known product's template to RDL.
Hitachi Consulting (not my firm) has engagement software that takes Crystal
Reports and produces RDL, for example.
Cheers, Mark
"rbowlin" <rbowlin@.discussions.microsoft.com> wrote in message
news:D9FFCD4B-845B-42DD-895D-7815E5E0828F@.microsoft.com...
> Does anyone know of projects in development to create RDL files from HTML
> and/or PDF files? I have to think that if Microsoft has created a render
> from RDL to PDF that the reverse would be fairly simple to complete as
> well.