Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
SQL Report Count issue
armela20
Member Posts: 71
Here is another SQL Reporting services issue that I am experiencing.
Your imput is appreciated.
I get the following error on the report that I am working on, as soon as I added a new item to my dataset.
The error is: An internal error occured on the report server. See the error log for detail.
I added a new item to the dataset with the following expression:
=iif(Fields!Posting_Date.Value>=Fields!monthstartdate.Value and Fields!Posting_Date.Value <= Fields!monthenddate.Value,COUNTdistinct(Fields!Document_No_.Value),0)
I noticed some posts on the Microsoft SQL reporting services web site in regars to the count issue that has to do with system resources. I followed all the instructions, but no luck.
Has anyone else experienced the same issue with the Count function and how were you able to resolve it ??
THanks
Your imput is appreciated.
I get the following error on the report that I am working on, as soon as I added a new item to my dataset.
The error is: An internal error occured on the report server. See the error log for detail.
I added a new item to the dataset with the following expression:
=iif(Fields!Posting_Date.Value>=Fields!monthstartdate.Value and Fields!Posting_Date.Value <= Fields!monthenddate.Value,COUNTdistinct(Fields!Document_No_.Value),0)
I noticed some posts on the Microsoft SQL reporting services web site in regars to the count issue that has to do with system resources. I followed all the instructions, but no luck.
Has anyone else experienced the same issue with the Count function and how were you able to resolve it ??
THanks
0