Recent content by gbuchman1

Hello, Hate to say it but I have not been able to get my budget amount (from subreport) to show on the main report (actuals), even after trying the solutions given. I must have missed something. If any of you would please assist, I would certainly appreciate it. I have the shared variable on...

oops.. I just ran the subreport and I am getting prompted for the Pm-tblDLTrans.sCodeIDf_1. Yet the main report still gets $0 for budget in each line in GH3b (report is in GH3a). please continue to help me with this. Thank you :)

Thanks everyone for your help, particularly lbass - thank you! Presently, I am not getting prompted for a value for {?Pm-tblDLTrans.sCodeIDf_1} when I run the subreport. Here is the Record Selection formula in the SUBREPORT: {tblBLTrans.sCodeIDf_1} = {?Pm-tblDLTrans.sCodeIDf_1} There is no...

Ooops.. Meant to say: group3 on each report references DLtrans_acctcode6 and BLtrans_acctcode6. Also, it seems like I am forced to link the subreport to the main report by a parameter and then I have to enter one value for the parameter for the subreport ; I cannot enter a range of values...

ok, I put the subreport in GH_3a and have the shared variable in GH_3b. Group 3 on the main report has fields from DLtrans and the subreport has fields from BLtrans. On main report, Group1 is the DLtrans_acctcode1 and on subreport Group1 is the BLtrans_acctcode1. Likewise group2 on each...

Is it possible to link a shared variable from a detail section of a subreport to a detail section of the main report? If so, do the tables on the subreport and the main report have to be the same? Do they have to be linked the same?

I used a SQL expression to get the total of the budget for each GL code combination and this only shows as zeroes on the main report. But I also took your suggestion, Madawc, and entered a formula and then a sum of the formula. However it is this sum that I now want to show on my main report...

Thanks for your reply, Kray. I do have the subreport in a section before the section where the shared variable will show, and I unsuppressed the section. I was able to get the shared variable to showup - hooray! However, it is giving the total amount of the first transaction and then...

Hello, I have 2 reports that I am working on in Crystal XI. The main shows the actual costs posted to a combination of GL codes, and the subreport shows budget amounts posted to the same combination of GL codes. The main report uses the DLtrans table, which is a list of all the actual...

I tried this formula and it is working beautifully! LB, you made my day...and weekend. Thanks so very much!

Ok, now I understand. I will insert a group on the suggested formula and try that. Will let you know how it turns out. Thank you! PS. The SQL expression that I use for the groups does not include parameters. What I showed in this thread was just a proposed addition to the SQL expression. I...

Thanks LB. This will work for the amounts, but I also have one other situation. It has to do with the labeling of the lines. Basically it is that I want to have two lines for the same grant - one line for last year's grant amount and a second line for this year's grant amount. Both of these...

Thanks for your reply, LB. Your second thought is true - the amounts that I have to distribute are per date and as such they can be easily attributed to grant periods. I have a record selection that only includes the transactions that posted in one fiscal year. More details: The records I...

Hi, I am doing a report which shows the totals of grants which were given within a fiscal year. However the grant years do not coincide with the fiscal year, and I must show how much posted to the fiscal year that is WITHIN the grant period (these amts are attributed to their respective grants)...

Ah ha! I caught my error. I corrected it and made the lines to be: Me.Dirty = False DoCmd.GoToRecord,,acNewRec ...then it worked! It saves the record and advances to the empty screen with the next invoice number. Beautiful! I ommitted the comma in an attempt to correct the first...