report

I have a table a. It has the data of all the people in the county who represented in some event.suppose i have 100 cities in the county and i have values for only 64 counties.I dont have the values for the rest of 36 cities.Any how i want to display the othercities with zero values. means
city number
a 34
b 56
C 0
d 23
e 0,

But the cities c and e are not there in the table.
How can i get this report.

Thanksyou have to join the table with the data of the events (table a?) and the table with the cities. When you use right outer join you get all the cities.

Reponse to reporting service event

Hi,
Is there anyway to response when RS generated report? I need to do extra works such as encryption once report generated, before deliver to customer.

Thank you

Hi,

Can you give me a little more information on what you are trying to accomplish? Such as what are you trying to encrypt and at what event or time should the encryption happen?

Thanks!

|||Hi,
Thank you for reply.

Actually I am trying to protect report generated in PDF from editable. I did some research and found that RS doesn't support this.

Therefore, I am looking for any workaround. I know that is 3rd party tool which able do add "protection" to any existing PDF file. I was thinking to call this 3rd party tool to "protect" RS generated PDF before deliver to client.

Please advice.

Thank you