Print directly frm PDF format

hi,
is there any ways to print the reports directly frm the web application by
rendering the reports to pdf format?
regards
AngelaThe user will have to export the report to PDF first and then print. There
is no way for Report Manager to automate this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angela" <Angela@.discussions.microsoft.com> wrote in message
news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> hi,
> is there any ways to print the reports directly frm the web application by
> rendering the reports to pdf format?
> regards
> Angela|||hi,
in that case, there is no other way whereby i can call to print the report
directly from my application? because i have tried rendering my report to
html format and the print result is different from reporting services print.
because the page number is different.And i cant use the method
"&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it will
promt the user the option to select printer whereby my user will print multi
reports at a click. so this will result the active x to prompt multi print
dialog.
regards
Angela
"Daniel Reib [MSFT]" wrote:
> The user will have to export the report to PDF first and then print. There
> is no way for Report Manager to automate this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> > hi,
> > is there any ways to print the reports directly frm the web application by
> > rendering the reports to pdf format?
> >
> > regards
> > Angela
>
>|||That is correct. You would need to solve this in your application. Your
app could display EMF rather then HTML and then just print the EMF and the
user would be viewing what they would print, however you would loose
interactivity.
The problem with using HTML is it does not print nicely. This is why we
created the ActiveX control to print reports. The activeX control uses EMF
to print reports. Because this is a different format (different from HTML)
the pages don't always line up. RS does not expose any mechanism for
printing the current HTML page.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angela" <Angela@.discussions.microsoft.com> wrote in message
news:9E2C9F73-67EF-4D54-B294-61ADBA4A2FA1@.microsoft.com...
> hi,
> in that case, there is no other way whereby i can call to print the report
> directly from my application? because i have tried rendering my report to
> html format and the print result is different from reporting services
> print.
> because the page number is different.And i cant use the method
> "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it
> will
> promt the user the option to select printer whereby my user will print
> multi
> reports at a click. so this will result the active x to prompt multi print
> dialog.
> regards
> Angela
>
> "Daniel Reib [MSFT]" wrote:
>> The user will have to export the report to PDF first and then print.
>> There
>> is no way for Report Manager to automate this.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Angela" <Angela@.discussions.microsoft.com> wrote in message
>> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
>> > hi,
>> > is there any ways to print the reports directly frm the web application
>> > by
>> > rendering the reports to pdf format?
>> >
>> > regards
>> > Angela
>>|||hi,
so in that case can i say i jux format my reports to EMF rather den html to
get the issue solve?
or is there an example or smaple for this calling format?
regrads
Angela
"Daniel Reib [MSFT]" wrote:
> That is correct. You would need to solve this in your application. Your
> app could display EMF rather then HTML and then just print the EMF and the
> user would be viewing what they would print, however you would loose
> interactivity.
> The problem with using HTML is it does not print nicely. This is why we
> created the ActiveX control to print reports. The activeX control uses EMF
> to print reports. Because this is a different format (different from HTML)
> the pages don't always line up. RS does not expose any mechanism for
> printing the current HTML page.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> news:9E2C9F73-67EF-4D54-B294-61ADBA4A2FA1@.microsoft.com...
> > hi,
> > in that case, there is no other way whereby i can call to print the report
> > directly from my application? because i have tried rendering my report to
> > html format and the print result is different from reporting services
> > print.
> > because the page number is different.And i cant use the method
> > "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it
> > will
> > promt the user the option to select printer whereby my user will print
> > multi
> > reports at a click. so this will result the active x to prompt multi print
> > dialog.
> >
> > regards
> > Angela
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> The user will have to export the report to PDF first and then print.
> >> There
> >> is no way for Report Manager to automate this.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> >> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> >> > hi,
> >> > is there any ways to print the reports directly frm the web application
> >> > by
> >> > rendering the reports to pdf format?
> >> >
> >> > regards
> >> > Angela
> >>
> >>
> >>
>
>

Primary/Foreign/Identity keys & Encryption

Hi all!

I'm just getting my feet wet with how encryption works in SQL 2005. With regards to the encryption of primary / foreign keys, I'm not entirely clear on the best approach. Below are three examples of typical table structures I currently have:

== Customers table ==
CustomerID (PK, int, Identity)
CustomerName (varchar)

== Orders table ==
OrderID (PK, int, Identity)
CustomerID (int, foreign key)
CreditCardNumber (varchar)

== OrderDetails table (1 to Many) ==
OrderID (PK/FK, int)
ItemNumber (PK, int)
ItemDescription (varchar)

The Customers and Orders tables use identity values as their primary keys. From what I can tell, CustomerID in the Customers table cannot be encrypted and OrderID in the Orders table cannot be encrypted because they are identity values. In these cases, would it be safer (in terms of security) to create a separate, meaningless identity key column in the Customers table and then remove the identity attribute from CustomerID so I can encrypt CustomerID?

Similarily in the OrderDetails table, OrderID and ItemNumber form a composite key. These values are important in that I don't want them to be tampered with. Am I better off creating a separate identity key column which becomes the table's primary key ... then encrypt both the OrderID and ItemNumber columns in this table?

Any ideas are appreciated.

Thank you,
Ben

Hey Ben,

You have the principle behind encryption correct.

The tricky thing is when you use encryption on keys, a lot of the value of having these keys goes away. For eample, because encryption is non-deterministic, you won't be able to use OrderID as a FK in the OrderDetails table (unless if you encrypt once and then insert into both tables, but this leaks information. Then again, this might be acceptable in your application). You can still use PK, but they will behave differently. For example, because encryption is non-deterministic, just having the primary keys no longer guarantees that the columns will be unique. If you try to insert Encrypted("id1") and then Encrypted("id1") again, you actually end up with two different cipher values so the the table will allow both inserts.

Security basically destroys information (well encrypted data is indistinguishable from random data) while the point of using keys is to preserve information for reference. Consider, for example, the difficulties you will encounter attempting to do searches or joins on CustomerID and OrderID if they are encrypted (Laurentiu has a good blog entry on this here: http://blogs.msdn.com/lcris/archive/2005/12/22/506931.aspx).

You can also check Laurentiu's blog for an example of creating an application using encryption: http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx this doesn't completely solve your problems, but it might be useful in seeing one way to apply encryption.

Please let us know if you would like more information or have further questions.

Sung

sql

previous value in trigger

Hi,
Can I get previous and current values of row in trigger for update
operation.
Regards,
Shah Adarsh.The previous value is in the deleted table and the current value in the
inserted table.
"Adarsh" <shahadarsh@.gmail.com> wrote in message
news:1140679727.735390.38640@.i39g2000cwa.googlegroups.com...
> Hi,
> Can I get previous and current values of row in trigger for update
> operation.
>
> Regards,
> Shah Adarsh.
>|||The data is stored in the virtual INSERTED table:
Operation --> Virtual Tables
INSERT --> INSERTED
DELETE --> DELETED
UPDATE --> INSERTED,DELETED
HTH, jens Suessmeyer.|||Thanks Quinn. It solved my problem.|||Thanks Jens. It solved my problem.