willywonka15

I have a report on jasper. It takes one parameter: user_name and than it shows all orders of this user. I need to schedule a job. I create the job but I want to ask a question: I want to send mail at 10:00 o'clock every day . It's OK but additionally, I want to send mail only the selected user. For example , At ten o'clock, the mail send to user_a with list of orders of user_a. At the same time a mail send to user_b with list of orders of user_b and etc. Can I achieve this in Jasper? I mean, special mail to special e-mail address ?

I want to adding dynamic columns to my select statement. Is it possible? If not can I achieve this with Jasper report? Which tool I have to use in JasperReport? Please help me. I am adding my current table and the wanted table. My table: order_id product_id alternative_id 1 12 15 1 12 16 1 12 17 1 13 1 14 2 18 19 2 20 21 2 20 22 2 23 2 24 25 I wanted to create this table in jasper report. Is it possible? order_id product_id alternative_id1 alternative_id2 alternative_id3 1 12 15 16 17 1 13 1 14 2 18 19 2 20 21 22 2 23