Hi i've got a couple of problems,
1st
is it possible to reference a sub query in its parent report,
I have severy queries in a report and i need to total the result of these queries (btw the queries count and only return a single number) was wondering how I can reference the sub query
2nd
the same report above, the criteria for the sub queries is generated by user input to a form, (Site Name, Start Date, End Date)
I need the title of the form (which is "site name" which is specified in the query form and passed into the reports openArgs) at the top of the report but because the Site name is generated by the lookup wizard it returns the ID instead of the site name e.g. "3" instead of "Lake District" is there anyway i can retrieve the name instead?
any help appreciated
thanks
1st
is it possible to reference a sub query in its parent report,
I have severy queries in a report and i need to total the result of these queries (btw the queries count and only return a single number) was wondering how I can reference the sub query
2nd
the same report above, the criteria for the sub queries is generated by user input to a form, (Site Name, Start Date, End Date)
I need the title of the form (which is "site name" which is specified in the query form and passed into the reports openArgs) at the top of the report but because the Site name is generated by the lookup wizard it returns the ID instead of the site name e.g. "3" instead of "Lake District" is there anyway i can retrieve the name instead?
any help appreciated
thanks