pool

Hi all, I need to design such a report: - Report Title: Activities from start_date to end_date - Report details: Name , Activity_description , total number of those activities performed in the dates interval The problem I cannot solve is that start_date and end_date are stored in a parameters_table. So I have such a query: select Name , activity_description , count(*) from activities where activity_date between parameters_table.start_date and parameters_table.end_date group by Activity_description In this way I don't have the fields start_date and end_date that I should use in the report title. I need one more query: select start_date , end_date from parameters_table to define these fields. How may I do it? I cannot use parameters, because I need to schedule the report and I have no users to input parameters values; the dates interval must be stored in the parameters table. Thank you for your help. Andrea

Hi guys, I didn't receive any reply to this post. So I renew my answer; please reply! Thank you Andrea

Hi all, it seems that the only way to get documentation for iReport is to buy the 'Definitive guide...' (!?!?) But before paying for it, I'd like to know if iReport does what I need!. Is there any free documentation to begin with some tests about iReport capabilities? Could anyone post here the URL please? Thank you for any reply Andrea

Hi all, I'm new to Jasperserver and iReport and so I ask you if there's a feature I didn't find in user manual: I'd like to design reports with iReport and then schedule their production (hourly or daily) to files in the filesysyem instead of jasperserver database. Is that possible? The reason for this is that I'd like to make them available without asking password and without using jasperserver single sign-on services. They're public reports. Can you give me any suggestion to do it? Thanks in advance for any reply. Andrea