Reports and Sub Reports

ACDC

I can get two standalone reports to work easily enough

but when I combine them into one report, as subreports then it all falls apart

The problem seems to come when I change the rules in the query.

The combined report will work as long as I don't change the query. (I have studied the sample in the Library app a 100 times)

Is this area limited, or are there some unwritten rules I don't know about.

Also, why does the report writer not have a proper save function as sometimes it saves and other times it does not - very painful ! I sometimes can only get it to save by inserting a blank field onto the page, this makes me think that my issue is bug related

Any Ideas?

ACDC

After a process of elimination to resolve this problem, I found:

In A report containing sub reports, if you insert in the query on any of the sub reports, something like AppointmentDate=CURRENT_DATE, then the report fails.

If you run the sub report on its own then it works fine

In fact any part of the query that deviates from the standard "Simple Form" breaks a combined report i.e. A report that contains sub - reports.

aware_support

There are many issues raised in your message but nothing specific. It is very hard for us to give any advice if people say that something "doesn't work" without providing specific details.

There are no limitations or known bugs in queries for sub-reports as far as we are concerned. You just need to know how it works. A sub-report is executed for a particular instance of data in the main report. For example if main report lists orders and a sub-report lists order items for each order, then the context of the sub-report execution is a particular order for which a list of items are being collected. This instance can be referred in a sub-report query with the prefix "This", for example:

FIND OrderItem WHERE OrderItem IN ThisOrder.Items

this finds all order items for the CURRENT order.

This is the typical scenario of using sub-reports.

Regarding save. If a report doesn't save it is possible that there is an error - check the output of the configuration tool for any hints.

ACDC

Hi Support ,

I will try and be more specific

The report in question relates to an Appointment object

In the report I have two sub reports. Each one of these sub reports is linked to an existing Query. ( BTW Both the sub reports run as they should, when run independently - its pretty much similar to the Library Member detail report )

The query in each sub-report is as follows :

Sub Report 1: FIND Appointment WHERE Appointment.AssignedTo.ID=LoggedInSystemUser.ID AND Appointment.Type='Meeting' AND NOT(Appointment.Status CONTAINS 'Completed') AND Appointment.ActivityDate=CURRENT_DATE ORDER BY Appointment.StartTime

Sub Report 2:FIND Appointment WHERE Appointment.AssignedTo.ID=LoggedInSystemUser.ID AND Appointment.Type='Phone Call' AND NOT(Appointment.Status CONTAINS 'Completed') AND Appointment.ActivityDate=CURRENT_DATE ORDER BY Appointment.StartTime

If I remove the "Appointment.ActivityDate=CURRENT_DATE ORDER BY Appointment.StartTime" from both of the above queries then the report works fine.

I also removed from 'Existing Query" to "Determine at run Time" and then inserted the query while in the main report Design, but this made no difference.

As to the "Save" problem, I did not quite get your response , but to simulate the problem, go into the Library sample and Design Member Detail Report, delete one of the Sub Reports and then exit. There is no save that takes place. Also the configurator does not know of the change either

aware_support

Questions:

What does the main report do?
What exactly is the problem - sub-reports show no data, missing data or what?
Is it a problem of CURRENT_DATE or ORDER BY? Have you tried removing ORDER BY and leaving CURRENT_DATE or vice versa?

ACDC

Answers

The main report contains two sub reports referencing the Appointment object. The only difference between the two sub reports is the Appointment.Type - 'Meeting' and 'Phone Call'
In the Main report the two Sub Reports show no Data - Just the Headings
The problem is, 'Appointment.ActivityDate=CURRENT_DATE'. If I remove this from the query then the report works fine

Hope that makes sense

ACDC

BTW, if I run either of the sub reports as a report on their own (including Appointment.ActivityDate=CURRENT_DATE) then the report works fine.

It seems to be that CURRENT_DATE query won't work when the report is a sub report

aware_support

We'll investigate this.

aware_support

Can you attach Aware IM Server output when the sub-report returns no results?

aware_support

This has been fixed in build 1035