Search found 164 matches

by JET-btr
Thu Oct 27, 2016 9:54 am
Forum: How do I?
Topic: Table Builder - Concatenate
Replies: 6
Views: 681

Re: Table Builder - Concatenate

The formula, when in Excel should be =NP("Formula","CONCATENATE([@[No.]],"" - "",[@[Name]])") with double quotes surrounding the -.
by JET-btr
Fri Jan 08, 2016 10:31 am
Forum: How do I?
Topic: Filter field with Data from a different field for each entry
Replies: 6
Views: 881

Re: Filter field with Data from a different field for each entry

Can you convert the dates to INTs to compare them?

Code: Select all

=NL("Count";"Table";;"=INT(NF(;""From Date""))";"=""<""&INT(NF(;""To Date""))")
Is it possible that the fields are at Date type in the database?
by JET-btr
Fri Jan 08, 2016 10:08 am
Forum: How do I?
Topic: scheduled task - missing Update
Replies: 1
Views: 358

Re: scheduled task - missing Update

Have you reviewed this KB article "Requirements to Run Scheduled Jet Essentials Task When Logged Off of Microsoft Windows" - http://kb.jetreports.com/article/AA-00490
by JET-btr
Mon Dec 28, 2015 4:03 pm
Forum: How do I?
Topic: Excel Tables in non-jet functions sheets get affected
Replies: 13
Views: 2090

Re: Excel Tables in non-jet functions sheets get affected

Neither of the attached have any Jet functions to them. Can you include the files with Jet functions?
by JET-btr
Mon Dec 07, 2015 9:37 am
Forum: How do I?
Topic: Empty Field (not filter) [SOLVED]
Replies: 2
Views: 452

Re: Empty Field (not filter) [SOLVED]

Hi Reid, If you could include a copy of your report that would be helpful to see what exactly is going on but my guess is that in cell E4 you have one of your report filters. If that is the case, I bet the report works fine if you have E4 equal to * or if you only have 1 item number listed as a filt...
by JET-btr
Mon Dec 07, 2015 9:30 am
Forum: How do I?
Topic: Date Filter Issue
Replies: 2
Views: 330

Re: Date Filter Issue

I would recommend using the .. to get an open ended range rather than doing a greater than/less than for a date. For example, if I wanted to get all records before (and including) December 11th, my date filter would be ..12/11/15 You can use the NP("DateFilter") to create this easily by entering in ...
by JET-btr
Tue Nov 03, 2015 11:53 am
Forum: How do I?
Topic: Disappearing formatting
Replies: 1
Views: 353

Re: Disappearing formatting

That is strange. To confirm, you are making the formatting changes in Design mode prior to running the report?

Are you able to upload the report in Report mode for review?
by JET-btr
Fri Oct 23, 2015 9:52 am
Forum: How do I?
Topic: blank filters
Replies: 1
Views: 304

Re: blank filters

Are you getting a specific error message? If you get a #VALUE, if you click on Debug, do you get a message?

Are you able to post your full function?

Have you tried using "@@" instead of "''"?
by JET-btr
Wed Oct 21, 2015 7:42 am
Forum: How do I?
Topic: Summarize with Pivot Table
Replies: 6
Views: 2494

Re: Summarize with Pivot Table

The "Summarize with PivotTable" only appears if you have created a table and have selected one cell within the table. When you create the table and select a cell, the Table Tools->Design ribbon appears in Excel. You can still create a PivotTable from other data, but using a table works best. If you ...
by JET-btr
Mon Oct 19, 2015 7:37 am
Forum: How do I?
Topic: Scheduler Pivot Group
Replies: 5
Views: 558

Re: Scheduler Pivot Group

If Jet is saying that it is now a known issue, then I would trust them on that. I've never used that functionality in previous versions of Jet which is why I was unsure that it worked outside of the newest version.
by JET-btr
Wed Oct 14, 2015 1:18 pm
Forum: How do I?
Topic: Cannot generate SSPI context
Replies: 1
Views: 539

Re: Cannot generate SSPI context

I would submit a ticket to the Support Site along with information about Excel/Windows/Jet versions.

Something like that, they should be able to help you or perhaps give insight to the source of the error.
by JET-btr
Wed Oct 14, 2015 1:02 pm
Forum: How do I?
Topic: Empty Filter Not Allowed
Replies: 8
Views: 856

Re: Empty Filter Not Allowed

Thanks for including the report. The problem you are having doesn't have to do with using the empty filter but that error message certainly could give that impression but the @@ can do other things. The @@ also signifies that there are could be special characters in the reference. That can cause pro...
by JET-btr
Wed Oct 14, 2015 8:30 am
Forum: How do I?
Topic: Scheduler Pivot Group
Replies: 5
Views: 558

Re: Scheduler Pivot Group

I just tested on my system with the newest version of Jet and if I have the pivot table take all my individual dates and Group them by month, when I refresh my report, it returns to the default state of each individual date.
by JET-btr
Wed Oct 14, 2015 8:13 am
Forum: How do I?
Topic: Scheduler Pivot Group
Replies: 5
Views: 558

Re: Scheduler Pivot Group

Hi Clipif

My guess is that every time the scheduler runs the report, it is running and saving a new report so it is reverting back to the default state of the pivot tables.

What was the previous version of Jet you were using? Did you change versions of Office or anything else?
by JET-btr
Wed Oct 14, 2015 8:08 am
Forum: How do I?
Topic: Empty Filter Not Allowed
Replies: 8
Views: 856

Re: Empty Filter Not Allowed

Just a quick question, why is your sell-to customer no a range rather than just a single cell?

If you select just D11, does it work?

Including the full report in design mode so we can see cell references could also helpful.
by JET-btr
Tue Oct 13, 2015 2:16 pm
Forum: How do I?
Topic: Sort by Calculated cell [SOLVED]
Replies: 2
Views: 477

Re: Sort by Calculated cell [SOLVED]

Trying to post this for the third time. Take a look at this link to a previous post on how to sort by sum.

http://community.jetreports.com/viewtop ... 872#p10489
by JET-btr
Mon Oct 12, 2015 8:53 am
Forum: How do I?
Topic: Date Filter w/ exceptions
Replies: 6
Views: 589

Re: Date Filter w/ exceptions

You could put in cell I10 =NL("Sum","Item ledger entry","Quantity","Entry Type","<>Purchase&<>Transfer","Item No.","@@"&$F10,"Location Code",$D$5,"Posting Date",NP("DateFilter",I$3,I$4))+NL("Sum","Item ledger entry","Quantity","Entry Type","Purchase|Transfer","Item No.","@@"&$F10,"Location Code",$D$...
by JET-btr
Mon Oct 12, 2015 7:48 am
Forum: How do I?
Topic: Date Filter w/ exceptions
Replies: 6
Views: 589

Re: Date Filter w/ exceptions

Without seeing the report and how you are building it, my guess is that may need to do a grouping report for the two "groups" of document types for each item to get the sum of those transactions or you just have a Sum calculation with one date set and another Sum calculation with the other date set.
by JET-btr
Fri Oct 09, 2015 9:32 am
Forum: How do I?
Topic: Date Filter w/ exceptions
Replies: 6
Views: 589

Re: Date Filter w/ exceptions

If I understand your post correctly, you want the user to enter a start and end date but you want to modify the end date for the actual report? Meaning, they enter in an end date of 10/31/15 but you want the end date for report to actually be 08/31/15? If that is the case, you can have them enter in...
by JET-btr
Fri Oct 09, 2015 9:30 am
Forum: How do I?
Topic: Linking company name and LCY code to GL entry in a table?
Replies: 4
Views: 1009

Re: Linking company name and LCY code to GL entry in a table?

Is it possible to include your report or screen shots of what you are trying accomplish?

Are you using the Table Builder or are you building this using Replicators?
by JET-btr
Fri Oct 09, 2015 9:04 am
Forum: How do I?
Topic: Linking company name and LCY code to GL entry in a table?
Replies: 4
Views: 1009

Re: Linking company name and LCY code to GL entry in a table?

To be honest, I don't think it is possible to link that. This is directly from the MSDN https://msdn.microsoft.com/en-us/library/hh169173(v=nav.71).aspx : General Ledger Accounts You cannot link currency codes to general ledger accounts because amounts on general ledger accounts are in LCY. If you h...
by JET-btr
Fri Oct 02, 2015 9:55 am
Forum: How do I?
Topic: Using NL with specific dates
Replies: 8
Views: 852

Re: Using NL with specific dates

With your layout, some days may require more lines replicated than other lines and Jet can't independently run the rows replicator for each column without acknowledging and executing the other rows replicators for that same item. The only way I could think to do what you want is to separate your day...
by JET-btr
Thu Sep 24, 2015 11:10 am
Forum: How do I?
Topic: Option Field Not Returning a Value
Replies: 5
Views: 1487

Re: Option Field Not Returning a Value

If you are interested in learning how to export and import the language module, you can review this KB article:

Navision Language Modules http://kb.jetreports.com/article/AA-00511/0/
by JET-btr
Tue Sep 22, 2015 7:26 am
Forum: How do I?
Topic: Convert dateformula
Replies: 1
Views: 366

Re: Convert dateformula

Since that isn't really a number, you will probably need to do some sort of IF statement: =IF((RIGHT(D5,1)="D"), LEFT(D5,FIND("D",D5)-1)/30,"")&" Months" (Where D5 is my lead time, but you could put in a Jet Function in its place) Determine if the last character is a D, then find the number of Days ...
by JET-btr
Mon Sep 21, 2015 7:43 am
Forum: How do I?
Topic: summing the result for individual document no.
Replies: 3
Views: 367

Re: summing the result for individual document no.

My example was just to give you an idea of how you could build the report. Since I didn't know your filters, my example is built without filters. That said, you can add filters that you need. In the main grouping using the sales header, you can filter on the date and you can link to the sales line t...

Go to advanced search