Search results for query: *

Don't know how to attach files in here. The problem is the data that comes up is pulling both invoices and payments on them - credit and debit entries for a vendor. I need to somehow specify just one - either debit or credit in their ledger.

most of the fields are from Jrnl.Hdr. The connections right now are inner joins. I tried changing it to outer left or right - one of them comes up the same and the other shuts down my Crystal, some database error. If you know how to select only invoices please let me know. There is no field...

I am trying to create a report to show how much we spent per each vendor during a certain pariod. I am using tables JrnlHdr, JrnlRow and Vendors. I am pulling fields Name, Reference, TransactionDate and MainAmount. For some reason it is coming up double - it is showing invoice and payment on...

After I create them how do I pass them over? And mainly, how would I remove the date range parameter from subreport so it does not show up? Thank you.

I have main report with subreport in it. Both have the same parameter prompt to enter date range. How do I pass it from main report into subreport instead of entering in twice? I was looking at the solutions online that say to link through the prameter field and then remove the parameter from...

Thanks again, please disregard my previous post, I found your previous answer to the similar question and it worked!

Here is what I am doing. I have main report and subreport that are structured the same way - details and one group level by product line with summary. I have inserted subreport into the group and it is linked through product line. All the details in both main report and subreport are supressed...

Thank you so much! It did work. Is there a way to summurize that data? I was trying to put var in the group and declare it as a summary, but it comes up with 0. And I can't put subreport into group due to not being able to link properly. The formula editor says that my var is can't be...

I mam grouping by item type. The subreport goes into details section, and I created the second details section below for variable. In the subreport I have totals calcuated per item type, when I try to transfer those totals through shared var it comes up with 0. It only transfers numbers if I put...

Thank you for responding. I've put it in, but now it turns eveyrthing to 0. Also I have subreports showing per item, but trying to tansfer group summary and it transfers only the last item, not the totals.

I am using shared variable to transfer data from subreport, I have some null subreports and in that case the variable shows up with the value from previous line instead of 0. How can I fix this? IsNull function soesn't seem to work on variable. Thank you for your help

I am trying to create a report showing sales revenues and COGS. If I create two separate reports - it works. But when I am trying to combine two together then only one calculates and the other shows $0 values (depending which one is added first). I am pulling information from the JrnlRow.Amount...