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.

RDA Push to a table that has an INSERT Trigger

Hello,

I posted under the Smart Devices VB and C# Projects forum as well, but since my question relates to SQL Server Triggers, I thought I might get some help here too. I apologize if this is not the correct forum.

I am using SQL Server 2005 Standard.

On my PC, on the table that I Push to from the device, I have a Trigger that sends an e-mail upon INSERT.

This trigger works (sends e-mail) when I run an INSERT against the table within management studio, or when I run an INSERT against the table from a web app on the same PC. (I also tested using an UPDATE, and the trigger worked.)

Here is my problem:

The trigger does not kick off after I successfully Push records from the device to the table on my PC.

Here is my c# Push code on the device:

rda.Push("tablename", rdaOleDbConnectString, RdaBatchOption.BatchingOn);

NOTE: I am not having a problem with the actual Push itself. That is working just fine.

On the surface it seems like an INSERT is happening (a new row appears in the table with the trigger), but does the Push do some other kind of action other than a true INSERT?

I can't seem to find anything about what exactly the Push is doing behind the scenes.

Can triggers be set for anything other than UPDATE, INSERT, DELETE?

Any insight would be appreciated.

Thank you.

Patrick

According to this article: http://msdn2.microsoft.com/en-us/library/aa225639(SQL.80).aspx it should work, but you might have to use SET NOCOUNT ON in your trigger (if you already haven't)

If that doesn't work, try using profiler and see what commands are actually being sent.

|||

I realized that the Trigger on the table was causing problems. I decided to remove the trigger on the table I Push into. I then wrote a stored proc to INSERT INTO another table that contains a trigger. This trigger successfully sends the single e-mail.

Now, I want to send multiple e-mails. I'll enter another post.