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
Data source - Data set in Reports
Lefteyed
Member Posts: 43
Hi guys
I'm fooling around with some datasets in report builder.
First picture is showing "DataSet_result" which is standard. I have created Playlist and RadioShowLedger. Here I want to select only some of the datafields and I set condition on one of them as well.
My problem is that when I save the layout and then the report and runs it I get this error:
"A data source instance has not been supplied for the data source 'Playlist'."
If I have closed the report builder design view then the dataset is gone.
Is it not possible to create a dataset and use it?
I'm fooling around with some datasets in report builder.
First picture is showing "DataSet_result" which is standard. I have created Playlist and RadioShowLedger. Here I want to select only some of the datafields and I set condition on one of them as well.
My problem is that when I save the layout and then the report and runs it I get this error:
"A data source instance has not been supplied for the data source 'Playlist'."
If I have closed the report builder design view then the dataset is gone.
Is it not possible to create a dataset and use it?
0
Best Answer
-
Options
kaspermoerch
Member Posts: 43
By design NAV only supports a single dataset - you cannot create additional datasets. The feature of creating of creating datasets is related to reports built directly on the SQL Server.
If you want to split your dataset into multiple tables on your layout, you must add a filter column on the outermost level of your dataset in NAV Dataset Designer. Then in "Tablix Properties" in Report Builder you apply a filter, that filters to only the desired value of your filter column.5
Answers
I tried fooling around with this also
If you want to split your dataset into multiple tables on your layout, you must add a filter column on the outermost level of your dataset in NAV Dataset Designer. Then in "Tablix Properties" in Report Builder you apply a filter, that filters to only the desired value of your filter column.
I can live with that solution