Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Building Query Based S...
Finance forum

Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello!  I'm new to D365FO.   We are in the early stages of Implementation and I am using a LCS provided development environment  running Version 8.

I am a BI Architect exploring various options we have in D365FO for reporting.  One option (from several) was to look at SSRS reports.  While exploring a Query Based report, I have encountered a problem after I create a Query from a single table.  In this example, I am using VendTable.

QBrpt_2D00_Query.png

Next, I create the report item - VendTableReport - and attempt to drag the query from above to the report Datasets element.

QBrpt_2D00_Dataset.png

Upon doing so, I get the following message.

QBrpt_2D00_Error.png

I am able to view data in the VendTable from the AOT using the Open Table Browser option.  I know I can access the table and it has data.   I have attempted this on several tables and have yet to be successful but one time against the CustTable table where I was able to complete the listing of that table with a Query Based SSRS report as of last week.  This week I am striking out.

Has anyone seen this kind of behavior and can recommend a solution?

Thanks!

Shawn

  • RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    The problem is with the synchronization of database, I didn't face this issue after the synchronization is complete.

    Make sure to set "Synchronize database on Build" to "TRUE" and rebuild/build the project. Attempt the same issue again.

  • Jie G Profile Picture
    Jie G on at
    RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    Hi Shawn,

    After building the new created query, you can try to right click  "Report\Datesets", select "New Data Set", then set the "Query" property of the new data set instead of dragging the query to the datasets.

    0456.Capture1.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    Neither suggestion worked.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    Per your suggestion, I have executed a Build on the solution after I created the Query (VendTableSW1).  After that completed, I attempted to drag the query on to the Dataset in the Report resulting in - The query VendTableSW1 is not valid.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    I attempted this and it did not make a difference.  I still get - The query VendTableSW1 is not valid.

  • FahadAhmed Profile Picture
    FahadAhmed 205 on at
    RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    we tried that, it didn't work.

  • Jie G Profile Picture
    Jie G on at
    RE: Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid

    Hi Shawn,

    I met this error once when I tried to use this query before building it.

    You can try to build the solution after creating the query and before you use it in the report's dataset.

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,671 Moderator on at
    RE: D365FO - Building Query Based SSRS Report and Receive - - The query VendTableSW1 is not valid.

    Create a new data set manually and in properties select datasurceType = query and in query property select your query.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans