A.D. has a new admirer. I got farther towards my ultimate report. My requirement calls for groups. I added groups and all looks good to a point. I adjusted the heading size which caused the records per page to change. In doing so I was able to get a group header with no details underneath, bad. Also, I want to put a single column subreport in with this 2 column report. Attached example (access 2007/2010) below is my attempts, so far.
Anyone know how to have a 2 column report followed by a single column subreport?
https://www.dropbox.com/s/kvzmn4o7vis6u35/ReportTwoColBalanced_Group.zip
Overall, I was impressed and learned more about the on print events. I download A.D.'s subreportTwoColumnBalanced. It got overflow error using the example supplied. I plan to look into that, as well as try the other suggestions I got last night.
Thanks,
Bob
On Tuesday, November 5, 2013 3:42 PM, "wrmosca@comcast.net" <wrmosca@comcast.net> wrote:
I should have known! The man is incredible when it comes to doing what everyone thinks is impossible. And to think he just took up Access as a hobby after he retired.
---In MS_Access_Professionals@yahoogroups.com, <stoughy@yahoo.com> wrote:
Ah, but A.D. did this already. See http://www.rogersaccesslibrary.com/forum/reporttwocolbalancedmdb_topic39.html
On Tuesday, November 5, 2013 2:55 PM, Duane Hookom <duanehookom@hotmail.com> wrote:
The only solution I have found for this is to create a calculated column in the report's record source that would be the combination of page number, row number, and column number. You can then sort the report by this column/field and set the report to sort across then down.
Duane Hookom MVP
MS Access
________________________________
Duane Hookom MVP
MS Access
________________________________
> From: rlkhym@yahoo.com
>
> I have an access 2010 report with 2 Vertical Columns (down then
> across). There isn't enough data to fill the last page. But instead
> of the last page have 2 columns of equal height, I get 1 left column
> that fills up 3/4 ths the page and empty space on the right.
>
>
> How do I get the formatting on the last page to have 2 columns of equal
> height?
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar