Hi
I have created quite a complex report built from over 20 sub reports (due to it having to be a document rather than a report). So I have some questions if someone could kindly advise or point me in the right direction....
1. How many sub reports can 1 main report handle?
2. Is there a way in the main report to make the sub reports miniscule but be able to highlight them when needed to move or change something? I have made them as small as possible because of restricted room but then have problems getting into them..
(I do need to add more pages in about another 6)
3. I can import word documents (certificates) but I cant find a way to import PDF documents. So I am creating the sub report, bringing in the word document as an image and then placing in the main report as a sub report.
4. I also need to redevelop all of this report including all sub forms another 3 times as we have potentially 4 kinds of reports with potentially slightly different data in all (text fields are driven from a table by reporttype id)
Is there an easy way to copy it all without having to re-create all sub reports and then redirect the main report to the other new sub reports?
5. And finally, eventually I need to create a report that needs to have hyperlinks from content page, also needs to have pictures in per record (record per page) and other information. I dont think access reporting can handle this, so could someone advise the best way to report in this way. This part of the project is some weeks away but I am trying to figure out the best way in advance.
many thanks
I have created quite a complex report built from over 20 sub reports (due to it having to be a document rather than a report). So I have some questions if someone could kindly advise or point me in the right direction....
1. How many sub reports can 1 main report handle?
2. Is there a way in the main report to make the sub reports miniscule but be able to highlight them when needed to move or change something? I have made them as small as possible because of restricted room but then have problems getting into them..
(I do need to add more pages in about another 6)
3. I can import word documents (certificates) but I cant find a way to import PDF documents. So I am creating the sub report, bringing in the word document as an image and then placing in the main report as a sub report.
4. I also need to redevelop all of this report including all sub forms another 3 times as we have potentially 4 kinds of reports with potentially slightly different data in all (text fields are driven from a table by reporttype id)
Is there an easy way to copy it all without having to re-create all sub reports and then redirect the main report to the other new sub reports?
5. And finally, eventually I need to create a report that needs to have hyperlinks from content page, also needs to have pictures in per record (record per page) and other information. I dont think access reporting can handle this, so could someone advise the best way to report in this way. This part of the project is some weeks away but I am trying to figure out the best way in advance.
many thanks
