Search results for query: *

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...

Here is the chunk of code: Me!Dirty = FalseDoCmd.GoToRecord,acNewRec (I changed the Me. to Me! since the other Me's had the !) Anyway, I realized that I also did not put the right break, so I edited it to be: Me.Dirty = False DoCmd.GoToRecord,acNewRec That solved that...

I did this and saved the code and the form. But when I reentered the form and entered a new record, I got: Compile error: Syntax error.

I have added an OK button to an invoice form. Users enter invoices on this form. After entering an invoice on this form, I want the user to be able to click an OK button that not only saves the record, but also moves on to a new window where the user could enter the next invoice. My database...

Thanks, Duane for the advice on the criteria. My Sales Detail Dialog form does have controls on it. While waiting, I made a new report and made sure that the event code was correct on it. Once I did that, sure enough, the problem was solved. Now when I click on the report, the Sales Detail...

Please note that I chose the query as the Control Source of my report, and that the fields on the report came from the query. Yesterday, I was able to get the report to run properly on its own, before I created the dialog box and had the report reference this (the Location, Start Date and End...