number of columns in jet report express

hery_halim
Member Posts: 53
Dear all,
is there any limitation in number of column in jet report express. I encountered error below :
Jet Express for Dynamics NAV
Invoking the web service failed with the following message:
Index out of bounds.
This happened when i change the formulas from :
=NL("Table";"Item";$D$24:$AA$24;"Headers=";$D$23:$BB$23;"TableName=";"Item";"IncludeDuplicates=";"True";"Filters=";Option!$C$5:$D$5;"Filters=";Option!$C$6:$D$6;"InclusiveLink=";D22;"InclusiveLink=";E22)
to
=NL("Table";"Item";$D$24:$AB$24;"Headers=";$D$23:$BB$23;"TableName=";"Item";"IncludeDuplicates=";"True";"Filters=";Option!$C$5:$D$5;"Filters=";Option!$C$6:$D$6;"InclusiveLink=";D22;"InclusiveLink=";E22)
Any help or information is really appreciate. Thanks
is there any limitation in number of column in jet report express. I encountered error below :
Jet Express for Dynamics NAV
Invoking the web service failed with the following message:
Index out of bounds.
This happened when i change the formulas from :
=NL("Table";"Item";$D$24:$AA$24;"Headers=";$D$23:$BB$23;"TableName=";"Item";"IncludeDuplicates=";"True";"Filters=";Option!$C$5:$D$5;"Filters=";Option!$C$6:$D$6;"InclusiveLink=";D22;"InclusiveLink=";E22)
to
=NL("Table";"Item";$D$24:$AB$24;"Headers=";$D$23:$BB$23;"TableName=";"Item";"IncludeDuplicates=";"True";"Filters=";Option!$C$5:$D$5;"Filters=";Option!$C$6:$D$6;"InclusiveLink=";D22;"InclusiveLink=";E22)
Any help or information is really appreciate. Thanks
0
Comments
-
Hi Hery,
There is not a limitation, so my guess is that it may have something to do with the content of the fields that you are specifying, but I don't really know. The best thing to do is ask this question on the Jet Express support forum (http://expresssupport.jetreports.com). There are more people who would know the answer there.
Joe0 -
Thanks Joe,
I think i use too many linksum to retrieve the data.
is there anyway, i can create aging report easily in jet express. I can't figure out how to repeat the column to the right.0 -
Hi Hery,
I was going to say that there isn't an easy way to do this with Jet Express. It would be quite easy if you could create a column with formulas, but this is part of Jet Essentials, so you need to pay for that. Formulas are super useful, and make lots of things possible like YOY comparisons, rising star reports, etc.
Luckily I checked the Jet Express report player so that I wouldn't embarrass myself with an incorrect answer and I found two A/R reports included. One summary and one detail. You may be able to use them out of the box, or you may want to modify them, but they should give you what you need. You can download this from http://jetexpress.jetreports.com. Just click the pre-built reports link. Once you download and install the player, you can just click on the reports and they'll open in Excel. You can save them off or add your own reports to the player if you want.
If you have other questions about that, the Jet Express forum (http://expresssupport.jetreports.com/index.php) is your best bet. There is an ask the community area and if you posted there, you wouldn't have had to wait for me to return from holiday for an answer.
Good luck and thanks for using Jet Express.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions