Hi
I am developing a departmental rota database. I posted a few questions in other places. Now I have a question regarding reports. I am going to have several reports. Unfortunately I can't see a way to create one report because some reports require cross tab queries and some are not. I need in the final report to have rows for each date of the rota and in this rows multiple activities. Is it possible at all to create such a complicated report? I had a try to insert one report into another as a sub report. That is not what I want. May be I have to accept the limitations and export each report into Excel and stitch the data there. But that would be disappointing.
I am attaching pdf samples of two reports as an example.
I am developing a departmental rota database. I posted a few questions in other places. Now I have a question regarding reports. I am going to have several reports. Unfortunately I can't see a way to create one report because some reports require cross tab queries and some are not. I need in the final report to have rows for each date of the rota and in this rows multiple activities. Is it possible at all to create such a complicated report? I had a try to insert one report into another as a sub report. That is not what I want. May be I have to accept the limitations and export each report into Excel and stitch the data there. But that would be disappointing.
I am attaching pdf samples of two reports as an example.