Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Using N printing on demand Nprinting 17.6.x
Coming straight to the question
Lets say i have 3 straight table in my app Straight-1 straight-2 straight-3
instead of creating 3 different reports(lets say excel) i am using one report with th three table being in 3 different sheets.
What i want is to have 3 buttons 1,2,3 . When user click on button 1 and run the on demand task only sheet 1 and table 1 should be exported to excel. When 2 and run the same task sheet 2 and table 2 should be exported to excel and other needed to be hidden.
I tried using macro but seems n printing 17 doesn't allow macros. I tried using pagination as well but that didn't work out well in this case. Can anyone has any approach. I have like 15-20 tables and i don't want to create 15-20 reports. Any suggestion would be valuable. If you know who can help pelase tag them as well.
regards
Pradosh
Hi Pradosh
understanding on demand functionality is the key to implemnt this solution. Since On-demand can only pass user selections as a filter and then trigger report generation what you probably will have to do is:
Can you share your data or sample application?
Thanks.
Hi Pradosh
understanding on demand functionality is the key to implemnt this solution. Since On-demand can only pass user selections as a filter and then trigger report generation what you probably will have to do is:
Hi Lech,
That's what essentially i have done with one exception i have used getfieldselection(field) instead of only(field).
I am not so clear here.
- Put in cell (for example in Cell a1 a formula which would return value what report needs to be created)
- Based on this value created conditional formulas to display your report headers... see image...
- User needs to select which report he/she wants to receive and the selection will pass filter on cell A1
How this formula will control the appearance or disappearance of header. Till now i can hide the data but the header are still showing up.
I was trying to hide the sheets using this vba code. https://www.extendoffice.com/documents/excel/3561-excel-hide-sheet-based-on-cell-value.html
Using getfieldselection allows multiple selection values to be returned, so i don't think it is a good idea to use it. I would use rather binary condition!
Have a look at the screenshot:
regards
Lech
Thanks Lech .. I think this will do. Did you have a look at the vba code i attached for hiding tabs do you think that will work ?
I know this question is out of the scope of this discussion but can you please let me know the flexibility of on demand feature?
1: If the user size is more than is it a good option to go to ?
2: Let say 5 person ran different on demand report at a time is the execution parallel or one after another like in a queue ?
3: Which one is faster scheduling report or on demand?
4: is there is any drawback of using on demand.
We just started using on demand and these are the question we are being asked by customers. I tried to search these but cant get a full proof answer. Can you please answer these as well.
Regards
Pradosh
Hi VBA code will not work - unless you are using NPrinitng 16.X. btw - i can't see attachment neither...
Regarding other question please create new topic and we will discuss it there
thanks
Lech