Search found 8 matches

by dmc
Wed Mar 29, 2017 6:54 am
Forum: How do I?
Topic: NL function "LAST" in Universal DB not working
Replies: 1
Views: 113

NL function "LAST" in Universal DB not working

Hi, hopefully someone has a suggestion on how I can accomplish this. I'm using the following NL function that pulls from a Universal SQL data source (Oracle) NL("last","MBR_PLAN","EXP_DATE","DataSource=","Oracle","MEM ID",H10366,"MEM SFX",I10366) I'm trying to get the last record in the data source ...
by dmc
Thu Mar 02, 2017 10:07 am
Forum: How do I?
Topic: Linked table not returning correct value
Replies: 5
Views: 356

Re: Linked table not returning correct value

Would it be better to using the NP function so that it can return the correct PBN based on the exp date and plan type, and then use the NL function to return the correct value. Is it possible to nest these 2 functions together? Thanks for all of the help!
by dmc
Thu Mar 02, 2017 7:47 am
Forum: How do I?
Topic: Linked table not returning correct value
Replies: 5
Views: 356

Re: Linked table not returning correct value

No that didn't work, it's not picking up the correct PBN number, which should be 2 based on the EXP Date of 01-31-2016 and PLAN_TYPE(PLAN) of CI on the GRP PLAN table. I want it to automatically be able to pick of the PBN number based on all the other criteria in the function. The only issue may be ...
by dmc
Tue Feb 28, 2017 12:16 pm
Forum: How do I?
Topic: Linked table not returning correct value
Replies: 5
Views: 356

Linked table not returning correct value

I've attached what appears on the tables for the NL formula below which is not returning the correct value. I tried checking the knowledge DB but couldn't find anything that would give me the correct solution. I want the formula to pick up the correct PBN based on the set “EXP_DATE” of 1/31/16 so th...
by dmc
Wed Jan 27, 2016 11:28 am
Forum: How do I?
Topic: 1 Report with Multiple Companies (NL=Rows )
Replies: 3
Views: 670

Re: 1 Report with Multiple Companies (NL=Rows )

Yes, I'm using it for Navision. Here is an example of what I would like in one report. Is there a function or a way I can write the function to include these 2 companies to populate data to run on one report. I don't want to have multiple worksheets for each company. =NL("rows","Customer","Customer ...
by dmc
Wed Jan 27, 2016 8:09 am
Forum: How do I?
Topic: 1 Report with Multiple Companies (NL=Rows )
Replies: 3
Views: 670

1 Report with Multiple Companies (NL=Rows )

Does anyone know if it's possible to create a single report that pulls data from multiple companies. I'm looking to get a data dump from a specific table that reside in each specific company. Any ideas?
by dmc
Mon Aug 03, 2015 2:17 pm
Forum: How Do I?
Topic: NL Rows - various companies one table
Replies: 1
Views: 4045

NL Rows - various companies one table

Is there a way where I can have multiple companies pulling from one specific table. For example I would like to pull "active groups" from "X table" which is company specific for companies ABC Inc. & DEF Limited =NL("Rows","X Table","Field","Company=","ABC Inc.|DEF Limited","Active Groups","Filter") ...
by dmc
Tue Aug 20, 2013 11:13 am
Forum: Suggestions and Feature Requests
Topic: Drilldown - Universal connection
Replies: 1
Views: 918

Drilldown - Universal connection

It would be nice if Jet Reports would be able to drilldown into the data that gets pulled in with the Universal Connection. Currently our Universal connection pulls from our Oracle DB and it would be nice to be able to see what the sum amounts are comprised of. Similar to how it works when it is con...

Go to advanced search