General downloads
SSRS Helper 1.0 (CTP 1)
- Author
- STRYK System Improvement
- Category
- General downloads
- Date
- 11/05/2009
- Size
- 19,46 KB
- Downloads
-
2055
Detailed statistics
- Downloads today 0
- 30 day downloads 12
- Total downloads 2055
- Overall download rank #454 / 2082
- Today page views 0
- 30 days page views 2
- Total views 6212
- Rating
Detailed statistics- x 5 100,00%
- x 0 0%
- x 0 0%
- x 0 0%
- x 0 0%
- Popularity
- Downloaded 6 times in the last two weeks
When querying data from NAV/SQL tables - e.g. with "SQL Server Reporting Services (SSRS)" - there are basically two somewhat annoying issues:
1. The content of Option Fields is only shown by Value, not by Text
2. FlowFields are not available
This little tool converts the OptionString and CalcFormula of a NAV table-field into a [T]SQL Subquery (!) which could be used with dynamic SQL in SSRS, SSAS or any other Non-NAV application to select the data!
The current release is NOT a final version, but IMHO a good start; and you all are invited to share your ideas to improve this little thing further on. Meet you online ;c)
Please refer to the forum discussion about further details.
