Hi,
Is there anyway for us to define lookup for Data Source on the report?
Also is there anyway to retrieve the name of database & data source used?
This is more on using with NAV.
With Regards,
Jason
Date
Votes
3 comments
-
Jet Reports Historic Posts Below are 2 lookups that related each other allows you to select the defined data sources and following the available companies:
D3 = NL("Lookup";NP("DataSources");"Data Source") D4 = NL("Lookup";NP("Companies";;D3);"Company")
Nearly every report I create starts with these 2 lookups…
And asfor the question of current datasource and company I am also curious if this is possible…
Suggestion that the NP("DataSources") and NP("Companies";;DATASOURCE) default returns the default company… -
Jet Reports Historic Posts My 2 cents for our Dutch readers…
The Lookup of the What argument of the NP function does not list "Datasources" as one of the options. You have to enter it manually. The Help text does not mention this option either.
Also, you have to enter "Datasources" - it is not translated into Dutch.
I think this is what software people call an Easter egg ;) -
Jet Reports Historic Posts I too would be very interested in finding how to report the default Data source and Company in my reports.
We use multiple data sources and I would like users of my reports to primary use their default Data source and Company but also have the option to override them & enter another Data source & Company.
Has anyone any idea how I might achieve this?
Please sign in to leave a comment.