Gasman
Enthusiastic Amateur
- Local time
- Today, 09:59
- Joined
- Sep 21, 2011
- Messages
- 14,287
Hi all.
Following on from this post https://www.access-programmers.co.u...ub-report-control-source.322708/#post-1820747 I am now trying to create the report.
The main report has three subreports, left, right and centre, which is below left and right.
I have managed to change the subreport control to load the correct report rptRest_By_Ship.
I have tested that report on it's own and it displays data. I have even added a label just to be able to see something if the data did not render correctly.
Yet now when I run the report for issue 44 26/09/1979, the report does not appear. This is the first Gazette issue that the changes should affect.
I have walked through the load of the main report and confirmed it does change the source object.
The essence of the reporting is that I need to identify the data, then concatenate the Rank (once) with all the names for that rank for that ship for that date/issue.
That I have got working via qryRankCrew and qryRankCrewConcat.
Then, my understanding is I need to concat RankNames into one control on the subreport. That works when in report on it's own. The report rptRest_By_Ship was copied from Rest_By_Ship.
The process is a little slow due to all the concatenates, but I could not think of any other way?
Would someone be prepared to have a look and advise where I have gone wrong please.?
Form frmReports is the starting point, and the Date entry combo needs to be 26/09/1979 issue 44 at least. At present I only have about 3 entries for the report, as I was using the old layout for the last 43 issues, but that should be enough for testing?
The main report is Main_By_Date, which uses Deck_By_Ship, Engineer_By_Ship and now the expected rptRest_By_Ship in place of Rest_By_Ship.
Once I have that working I can duplicate the process for Main_By_Ship.
I think that is enough to go on to see my problem, but if anything else is needed of course please ask, rather than having to go looking (Unless you prefer to?). Although it has been quite a while since I first created this (it was my very first DB back in 2011) it might be quicker, than you trying to work out my thought processes at that time.
Many thanks for any assistance.
Following on from this post https://www.access-programmers.co.u...ub-report-control-source.322708/#post-1820747 I am now trying to create the report.
The main report has three subreports, left, right and centre, which is below left and right.
I have managed to change the subreport control to load the correct report rptRest_By_Ship.
I have tested that report on it's own and it displays data. I have even added a label just to be able to see something if the data did not render correctly.
Yet now when I run the report for issue 44 26/09/1979, the report does not appear. This is the first Gazette issue that the changes should affect.
I have walked through the load of the main report and confirmed it does change the source object.
The essence of the reporting is that I need to identify the data, then concatenate the Rank (once) with all the names for that rank for that ship for that date/issue.
That I have got working via qryRankCrew and qryRankCrewConcat.
Then, my understanding is I need to concat RankNames into one control on the subreport. That works when in report on it's own. The report rptRest_By_Ship was copied from Rest_By_Ship.
The process is a little slow due to all the concatenates, but I could not think of any other way?
Would someone be prepared to have a look and advise where I have gone wrong please.?
Form frmReports is the starting point, and the Date entry combo needs to be 26/09/1979 issue 44 at least. At present I only have about 3 entries for the report, as I was using the old layout for the last 43 issues, but that should be enough for testing?
The main report is Main_By_Date, which uses Deck_By_Ship, Engineer_By_Ship and now the expected rptRest_By_Ship in place of Rest_By_Ship.
Once I have that working I can duplicate the process for Main_By_Ship.
I think that is enough to go on to see my problem, but if anything else is needed of course please ask, rather than having to go looking (Unless you prefer to?). Although it has been quite a while since I first created this (it was my very first DB back in 2011) it might be quicker, than you trying to work out my thought processes at that time.
Many thanks for any assistance.