Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Hi,
Does anyone know of a way to embed a query into a report without it becoming a subreport? I have a crosstab query whose column headings change each month due to the level of activity in the field.
Example: The query has a "Branch" field, and an "item" field. If a particular item had no activity for a given month, it will not show in the query.
I need to base a report on it, but reports look at static fields. A query whose information can change dynamically within the report would solve the problem.
Any ideas would be appreciated?
Thank you.
Does anyone know of a way to embed a query into a report without it becoming a subreport? I have a crosstab query whose column headings change each month due to the level of activity in the field.
Example: The query has a "Branch" field, and an "item" field. If a particular item had no activity for a given month, it will not show in the query.
I need to base a report on it, but reports look at static fields. A query whose information can change dynamically within the report would solve the problem.
Any ideas would be appreciated?
Thank you.