If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lopsided report
I am trying to create a report which has Cash Contributors on one side of the
page with In-Kind Contributors on the other side of the page !! (Side by side each other) I have all the information i need in the same query. If I create a single report, I get the lopsided effect. One group of contributors is higher than the other, leaving blank spaces above one side. I tried creating a report with a sub report. I used the MonthYear as the link, as I could find no other common ground. Doing that, I have encounter two errors, the filter (I used a form filter with the MonthYear as the filter.) When I open the form, enter the monthyear that I want, exp, Jul 2007, I then open the main report, it asks me for the MonthYear again. The report opens with a mess. On the SubRpt_IKcontributions, it lists all in kind contributions, multiple times. On the main report side, Rpt_CashContributions, it will list one or two cash contributions then many in kind contributions, one or two cash, multiple in kind contributions. I've no idea what I've done wrong, does anyone else? I really hope so and that somene(s) can help me out. Christ's blessings, k |
#2
|
|||
|
|||
Lopsided report
"I have all the information i need in the same query" does this query contain
a field/column that identifies "cash" or "In-Kind"? IMHO, never use parameter prompts in queries. Always reference controls on forms. Open the form, enter the criteria in the controls, and then run the report. Are all contributions made to the same entity or are the grouped. For instance cash and in-kind contributions to "Project X" and cash and in-kind contributions to "Project Y". From you description, all contributions go into the same "pot". Are you really sure you want to group by Month and Year? Can we assume there are no contribution detail records in the main report's control source? -- Duane Hookom Microsoft Access MVP "znibk" wrote: I am trying to create a report which has Cash Contributors on one side of the page with In-Kind Contributors on the other side of the page !! (Side by side each other) I have all the information i need in the same query. If I create a single report, I get the lopsided effect. One group of contributors is higher than the other, leaving blank spaces above one side. I tried creating a report with a sub report. I used the MonthYear as the link, as I could find no other common ground. Doing that, I have encounter two errors, the filter (I used a form filter with the MonthYear as the filter.) When I open the form, enter the monthyear that I want, exp, Jul 2007, I then open the main report, it asks me for the MonthYear again. The report opens with a mess. On the SubRpt_IKcontributions, it lists all in kind contributions, multiple times. On the main report side, Rpt_CashContributions, it will list one or two cash contributions then many in kind contributions, one or two cash, multiple in kind contributions. I've no idea what I've done wrong, does anyone else? I really hope so and that somene(s) can help me out. Christ's blessings, k |
#3
|
|||
|
|||
Lopsided report
Duane,
First, what does "IMHO" mean? Second, I changed to frmDates and used my IncDate (Income Date) as my linking field on my subreport. Can not view my subreport at all. Third, The cash donations go to the bank, the inkind contributions go to sell in the thrift store. Fourth, because I got tired of double entering names, I decided to have just one table for Contributors. Fifth, there is a cash contribution control source in the detail section of the main report, as well as the amount of the contribution. Sixth, the Name of the sub report in the main report is SubRpt_IKContributions Seventh, perhaps most important, I will go back to all of my tables, etc. and change the MonthYear. I will use the Income Date, Check Date, etc. for a time period reference. Eight, all these talk about the main report and sub report. Is there no way to have side by side information without a subreport, which, at the moment, is not working. Question, could I use two child/master linkings? Contributor, since both the inkind contributions and the cash contributions come from the same list, and the Income Date? I've tried each by itself, and will try both together, can't hurt to give it a try. Hope thse are better answers than I've given in the past. Another question, have you completely given up on helping me obrain the ending balance for my financial report? Still have hope but need help. 54 postings. Boy, are we on diffeent wave links. I shall try to do better. Good night, good luck, and Christ's blessings. k The Name for the sub report is "Duane Hookom" wrote: "I have all the information i need in the same query" does this query contain a field/column that identifies "cash" or "In-Kind"? IMHO, never use parameter prompts in queries. Always reference controls on forms. Open the form, enter the criteria in the controls, and then run the report. Are all contributions made to the same entity or are the grouped. For instance cash and in-kind contributions to "Project X" and cash and in-kind contributions to "Project Y". From you description, all contributions go into the same "pot". Are you really sure you want to group by Month and Year? Can we assume there are no contribution detail records in the main report's control source? -- Duane Hookom Microsoft Access MVP "znibk" wrote: I am trying to create a report which has Cash Contributors on one side of the page with In-Kind Contributors on the other side of the page !! (Side by side each other) I have all the information i need in the same query. If I create a single report, I get the lopsided effect. One group of contributors is higher than the other, leaving blank spaces above one side. I tried creating a report with a sub report. I used the MonthYear as the link, as I could find no other common ground. Doing that, I have encounter two errors, the filter (I used a form filter with the MonthYear as the filter.) When I open the form, enter the monthyear that I want, exp, Jul 2007, I then open the main report, it asks me for the MonthYear again. The report opens with a mess. On the SubRpt_IKcontributions, it lists all in kind contributions, multiple times. On the main report side, Rpt_CashContributions, it will list one or two cash contributions then many in kind contributions, one or two cash, multiple in kind contributions. I've no idea what I've done wrong, does anyone else? I really hope so and that somene(s) can help me out. Christ's blessings, k |
#4
|
|||
|
|||
Lopsided report
IMHO, you should google it ;-)
I don't think you touched on these questions: "I have all the information i need in the same query" does this query contain a field/column that identifies "cash" or "In-Kind"?/ Are you really sure you want to group by Month and Year? / I'm trying to determine how you want to group the records displayed in your report. I assume your MonthYear field contains some expression like 200708 and 200709. Are you wanting to group your report by year and month? From you description, all contributions go into the same "pot"./ Since you didn't really answer this, I assume there is no additional grouping required in the report other than year and month. What are the exact field in your record sources and how do these fields relate? -- Duane Hookom Microsoft Access MVP "znibk" wrote: Duane, First, what does "IMHO" mean? Second, I changed to frmDates and used my IncDate (Income Date) as my linking field on my subreport. Can not view my subreport at all. Third, The cash donations go to the bank, the inkind contributions go to sell in the thrift store. Fourth, because I got tired of double entering names, I decided to have just one table for Contributors. Fifth, there is a cash contribution control source in the detail section of the main report, as well as the amount of the contribution. Sixth, the Name of the sub report in the main report is SubRpt_IKContributions Seventh, perhaps most important, I will go back to all of my tables, etc. and change the MonthYear. I will use the Income Date, Check Date, etc. for a time period reference. Eight, all these talk about the main report and sub report. Is there no way to have side by side information without a subreport, which, at the moment, is not working. Question, could I use two child/master linkings? Contributor, since both the inkind contributions and the cash contributions come from the same list, and the Income Date? I've tried each by itself, and will try both together, can't hurt to give it a try. Hope thse are better answers than I've given in the past. Another question, have you completely given up on helping me obrain the ending balance for my financial report? Still have hope but need help. 54 postings. Boy, are we on diffeent wave links. I shall try to do better. Good night, good luck, and Christ's blessings. k The Name for the sub report is "Duane Hookom" wrote: "I have all the information i need in the same query" does this query contain a field/column that identifies "cash" or "In-Kind"? IMHO, never use parameter prompts in queries. Always reference controls on forms. Open the form, enter the criteria in the controls, and then run the report. Are all contributions made to the same entity or are the grouped. For instance cash and in-kind contributions to "Project X" and cash and in-kind contributions to "Project Y". From you description, all contributions go into the same "pot". Are you really sure you want to group by Month and Year? Can we assume there are no contribution detail records in the main report's control source? -- Duane Hookom Microsoft Access MVP "znibk" wrote: I am trying to create a report which has Cash Contributors on one side of the page with In-Kind Contributors on the other side of the page !! (Side by side each other) I have all the information i need in the same query. If I create a single report, I get the lopsided effect. One group of contributors is higher than the other, leaving blank spaces above one side. I tried creating a report with a sub report. I used the MonthYear as the link, as I could find no other common ground. Doing that, I have encounter two errors, the filter (I used a form filter with the MonthYear as the filter.) When I open the form, enter the monthyear that I want, exp, Jul 2007, I then open the main report, it asks me for the MonthYear again. The report opens with a mess. On the SubRpt_IKcontributions, it lists all in kind contributions, multiple times. On the main report side, Rpt_CashContributions, it will list one or two cash contributions then many in kind contributions, one or two cash, multiple in kind contributions. I've no idea what I've done wrong, does anyone else? I really hope so and that somene(s) can help me out. Christ's blessings, k |
Thread Tools | |
Display Modes | |
|
|