Hello,

I was hoping someone could help me out with an issue I'm having. As you can see from the image below, I want have a specific GL account's balance to display. That balance for that account only. This is a sub-report, so my anticipation of adding a sub-report into this one to simplify this task, has failed. Granted, I'm new to Crystal Reports, so maybe I'm just missing something in a formula to achieve what I desire, that would be easier than a sub-report.



Any help would be appreciated! Thanks!

-Butterfly_Joe

Unfortunately, the main report is not related to the subreport, hence the sub in the first place. I can link related tables in the subreport, but I just cannot figure out how to fix that formula to calculate/display the balance for that specific account only. Granted, I am very new to formulas, so it might be simple as pie. I just cannot think of another way to achieve what I need.

I enjoy your input though, it is greatly appreciated. :)

Thanks!

The way the report is set up is as follows:
Main Report - Simple report which displays company logo/info with on-demand subreport links up top (for A/R, A/P, etc. detailed info), while regular subreports are embedded into the main report, which displays YTD company information. I did not make this report, I am simply altering certain aspects of it.

That being said, I realize that normally, a subreport contains some sort of link to the main report, however it does not seem as such (see 1st img below). I also have two more images below that show the makeup of the subreport I want to alter. If this helps you visualize how things are set up, and you can offer any other help on how I can get it to work, I'd be thrilled.









Thanks!