The 1st
I have built a margins report and placed on scheduler for auto-running. My problem is we have 3 companies we use jet for and which ever company I was working last in will be the company that Jet runs the margin report for. I need a way to set jet to select the database of company XYZ and stay there…
The 2nd
These reports are also sent to bank auditors and I would like a report to be emailed in excel and stripped of all the jet commands.
Thanks
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment So with your second point, you will notice that when you use auto+hide+values in A1, the forlumas that result in the calculations, i.e. the NL and NFs will not be accessable. Run it with auto+hide to see the difference.
What you're essentially after is to clear the contents in column A and row 1, and I'm pretty sure that Jet can not do that. Perhaps a custom macro could help you? -
Jet Reports Historic Posts jmatulevich,
you will need to add "company=","yourcompanyname" in all of your NL() formula's. This will tell these formulas what company to use.
As to the second question, try using Auto+Hide+Values in cell A1. This will convert all of your formulas to values and hide the formulas. Only a Jet Reports Designer can retrieve the formulas. -
Jet Reports Historic Posts the 1st problem I will put in place your suggestion. Thanks
the second problem is that
" try using Auto+Hide+Values in cell A1" is actually done. When the report runs it does what it is told to do, however those columns are just hidden, my banker can unhide and see Auto+Hide+Values in cell A1 … I need to strip all the Jet commands from the report and export even as a CSV or whatever, just raw data so the banks can import into their own databases…
Thanks -
Jet Reports Historic Posts That is probably what I will need to do… is build an export function for the data…
Thanks everyone
jhm
Please sign in to leave a comment.