Search results

This is really helpful, thank you for taking the time to create this tutorial for getting rid of the sub-reports. It will take me some time to digest this new construction, exciting that I get to learn something new (to me) and useful. I will think about how to combine the data into a single...

I was able to use your suggestion to build the SQL query to add all the tables to the report source. However this just seemed to confirm for me that the method used in report #1 will not work when there is more than one sub-report in the details section of the main report because of the...

Thank you. I'm trying to figure out the syntax myself, but having multiple inner join statements is tricky. I'm trying to follow the answer outlined on this page (sorry, I don't have permission to post links), stackoverflowdotcom /questions/7854969/sql-multiple-join-statement It would be the...

The main report looks the same as this one- same sections, the six sub reports in the detail section each look like the attached image. The main differences 1) Each of the six sub reports has a report header which serves as a title for that group of records and 2) each of the six has a 'Total'...

Thanks, I was getting an "Invalid Sorting and Grouping" error at first but I tried it again and it worked.

Would I need to somehow add the jurisdiction field to the report record source? Could I do it in the OnFormat property of the Details section? I'm trying various approaches but I don't really know what could work versus what is a dead end.

THANK YOU, I think could be a viable solution! As you mentioned the records are no longer sorted by jurisdiction name. In the actual db, the records are pulled from a query. If I change the sort options in that query (to sort by TST Num and JURISDICTION NAME Ascending) the sort looks good in...

This looks very promising, thank you. Let me work out how to apply these changes to the actual reports and test!

These are very helpful hints, I am digging to see why the number of records might be causing this issue. The report was originally designed to export as a PDF so the records per page are (as far as I recall) an artifact of the page format and section height.

I also posted this question on accessforums, but I'm unable to post the link as the anti-spam tools are preventing a URL posting.

Thanks, I did try googling various solutions but this is an odd issue and I did not find any relevant results. I already have a script that converts the Access HTML output and reformats it, consolidating the report pages. There are other reports with many more pages that work properly, so I...

I need to create HTML export of the report "rpt2024_Tst_summary_8_7_25" in the attached db. The export fails at about page 100 with the "Overflow" error. It is not specific to data in the table at that particular place in the report because I removed the data at the page of the overflow error...