@nicksm hmmm interesting. You would need to be able to Access the Data Source data to identify the branch that column is filtered to?

@nicksm long time no speak 🙂 Don't think I've got those functions to work in the column attributes, only the Column headings. Haven't played ...

Found an example of this in the Sales by Profitability by Customer Class and Customer where when you select the customer class it then filters the cus...

Got this sorted and the Scenario looks like this

Thanks Nick I ended up doing something similar. I created a route called 'Unallocated' and then scheduled the creation of the Route Documents s...

@wyatt-erp thanks mate!! Wouldn't have got this one 😀

Thanks for this. Very helpful for a new client of ours

Have you tried the detail as a sub report? I've used the concept for other reports where I need to show data that doesn't have historical combos.

Thanks Tim. Would be a great addition 🙂

Cool

Thanks Tim. On another note, I updated my linkedin email as I moved jobs (still MYOB Advanced) and it create a new account when I logged in so now I...

SOrry Tim, I should've mentioned that I was only using it in the Header section of the column set 🙂 I think we would have to identify the SubID fiel...

Worked out how the GetDescription works in the Column set to get names rather than ID. As above they have added a specific function for GetBranchText...

I agree with your comments in the post that it is a people issue as well 👍

Legend!!! Thanks again Tim. I clearly didn't look hard enough for this post 🙂

Nice!

There is an Application function: =Report.GetBranchText(@StartBranch) This will give the Branch Name

Cracked it. I brought the condition into the Rowset and set the COlumnCode condition there 🙂 Right-click to Download

No but will have a look at it. Thanks

Got a little excited that @BookCode Parameter actually related to Ledger!! Can't get it to work the way I want though 🙁

Annoyingly this works on the lines I want but the group totals don't calculate those lines as zero

Hi Tim I did try what you suggested which makes logical sense but it appears that the Value conditions only work if the Column type is Calc 🙁

Right-click to Download

Thanks Tim, just heading off for the weekend but will send xml early next week and as usual really appreciate your input

Yep thats my thoughts too but just wasn't sure if there was something I was missing 🙂

Thanks Tim, I'll give it a go. Shame its so involved 🙂 It would be great if the system recorded on the SOline which Sales Price Worksheet was used t...

No worries. Tim has done a great job with the AUG and with advice, now we can share any tips we pick up on the way 🙂

We got it to work by adding the Images on the report (not the section) and using the Back Image

Yes Tim, the Assign was applied in a variable in the Group Header in the Main Report. When I have a chance I'll try the other suggestion as well and f...

Got it! If you use the Function>Program Shortcuts> Assign('$subReport1_Variable',0) at the group start it works

Thanks Michael, pretty sure I have tried all combos but maybe I forgot this one :).

Initially I had the reset group set on the subreport and the value would always be zero. It's like the timing of the reset cleared the value before i...

I was being lazy with the initial post as this was a Crystal report board question but the principle is the same with the attached reports. I am pull...