0

Data Retrieval

Jet Reports Historic Posts

January 22, 2009 12:53

None

Follow

Hi there,

I am new to Jet and am connecting to a Nav and outside SQL DBASE.

I am currently retrieving data from the sql Dbase and only seem to be able to bring back all the individual values. I can then add sum functions or use filters on it but this is effecting performance as in some cases I am retrieving 50,000 lines. Can Jet just bring back the total columns so I get far fewer Excel lines? I have hidden the lines whch makes the report viable. The values I am retrieving are all numeric

Thanks for your help
:D

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 23, 2009 14:28

  Jet has a 'sum' function, that may be what you're looking for. Take a look at the help file for the NL function.
  
  If you're still stuck attach your example and we may be able to get you started.

• 0
  
  Jet Reports Historic Posts January 23, 2009 16:10

  Thanks Markl,
  
  Your hint has pointed me in the right direction and I have it now. I was trying to use the Wizard function which I do not think has the capability.
  
  Going straight into designer and using the sum button has done the trick.
  
  Thanks for your help