Is it possible to do multiple NL(Sheets) functions in a single workbook? I am trying to create a report that will do a new tab for each G/L account and each Global Dimension 1. If not, does anyone have an idea of how I can create a tab for each of these filters?
Thanks,
Joy
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Joy,
It is possible to do multiple NL(sheets) functions within a workbook, but not within a single sheet. It's not possible to nest NL(Sheets) the way you do NL(Rows). So you could put an NL(Sheets) function for the G/L accounts on one worksheet and an NL(Sheets) for the Global Dimension 1 Code on another worksheet. However, you will only get one list of all the Global Dimension 1 codes, not a list of global dimension 1 codes that apply to each account. Is that what you are looking for? Or are you trying to get a list of global dimension 1 codes that applies to each account on a separate sheet?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I was looking to get a separate sheet for each global dimension 1 code that applies to each account on a separate sheet. So if I have 2 values in global dimension 1 and 5 G/L accounts, I want to end up with 10 sheets. I am assuming I will need to either create a separate report for each global dimension 1 value or each G/L account to get it to work as I want.
Thanks,
Joy -
Jet Reports Historic Posts Joy,
Well it is possible to do what you want. It's just a bit more complicated. You can use a calculated field to combine the values of the G/L Account number and Global Dimension 1 Code like this:=NL("Sheets","G/L Account","=NF(,""No."")&""|""&NF(,""Global Dimension 1 Code"")")
Then you could use NP(Split) to split out the actual values for account number and dimension code like this (assuming that the NL(Sheets) function is in cell C5):=NL("First",NP("Split",C5,"|")) =NL("Last",NP("Split",C5,"|"))
Calculated fields can be quite slow, so this probably won't run super fast, but it should accomplish what you want in one report. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts I decided to do a conditional hide for hidesheet. I think it will process faster than using calculated fields. Thanks for your help!
-
Jet Reports Historic Posts Joy,
I'm curious how you plan to get the sheets in order to hide them. Where will you replicate the sheets from without a calculated field? I'm just curious how you will get the sheets replicated in the first place.
Regards,
Hughes
Please sign in to leave a comment.