Hi,

I need to email a group of data to one client and other goup data to another client. i need to automate this in crystal report.

Any idea how to do this?

cshark:

Hi,

I need to email a group of data to one client and other goup data to another client. i need to automate this in crystal report.

Any idea how to do this?

Desing your page like this. One dropdown list having customer list and button. Based on selected custer you show the list of records. Add another button is used to export all the data from Report to PDF file and send a mail with this PDF file attached to your client like these

 Hi,

    You can use a window service to schedule the report generation. Create a report using PUSH method(using datsets with crystal report).

First design the report.

        Create an service which can pull the data from the database and can call the report create method. In report create method write the logic of biding the dataset data into crystal report and convert that into any suitable format(best way is PDF ) and email the report to the required destination.

If you want the to be happened automatically on certain period go for windows service or you need just one time when you click a buttom or whatever event, instead of service just call the above mentioned methods in a loop.

Thanks for you suggestion. I will try the it.

However, the problem is: The data in the report is grouped by departments. Data related to particular department should be emailed to that concerned users (email ids to be read from database).

Dept1 --> Dept1Users

Dept2 --> Dept2Users

No user will get to see any department other than his.

Thanks,
S

Csharp thanks for your post. I already gave the answer in this thread.

jeyaseelan@ajsquare.net:

Csharp thanks for your post. I already gave the answer in this thread.

Thanks Jeya.

The problem is, the generation of the report is automated. There is no webpage where the user can go and select the department from the dropdown.

This report is scheduled to generate every month, which consists the data of all the departments.

I saw your thread, can we email the data of that particular dept to that dept only? not sending the entire report?

cshark ok...then you design your page based on your need but that link i have alerady given you in the previous post, that will help you.

On that link i explained how to export the report data without clicking Crystal Report toolbar button and how to save the data as a PDF file and how to sent to mail.

One more thing you want to send the data to that corresponding department only then you have to create the logic, otherwise my suggesstion is read that department employee e-mail id from DB and store it in a Array object then after exporting the data into PDF send the same to them.