web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SRSS Report Query Data...
Microsoft Dynamics AX (Archived)

SRSS Report Query DataSet - Property Value is not valid

(1) ShareShare
ReportReport
Posted on by DMaria 285

I want to add new field from my dataset to my report, but when I pick the field I want a got this error. 

1185.Przechwytywanie.PNG

I tried everything (synchronize etc.) I'm using system query. And I tried different fields and still the same. I even try different datasets. 

Please help,

Best regards 

DMaria

*This post is locked for comments

I have the same question (0)
  • DMaria Profile Picture
    DMaria 285 on at

    To all my reports, I tried restart and it didnt help.

  • Keshav Kumar Profile Picture
    Keshav Kumar 220 on at

    Hi Maria

    What kind of field you are adding?You may have added the field whose property may not be valid.can you name the field?

    Regards,

    Keshav Kumar

  • DMaria Profile Picture
    DMaria 285 on at

    Hi,

    Field is not a problem, I tried to add different fields and even different dataset but still same error.

    Best regards

  • Keshav Kumar Profile Picture
    Keshav Kumar 220 on at

    Hi Maria

    Refresh your Dataset,clean your usage data and Restart AOS.

    Regards

    Keshav Kumar

  • DMaria Profile Picture
    DMaria 285 on at

    Hi,

    I still have the same error and now even when I try to restore my dataset.

    Best Regards

  • Keshav Kumar Profile Picture
    Keshav Kumar 220 on at

    Hi Dmaria,

    Did you start your reporting services,if not then please restart your reporting services.Before restarting your services you need to refresh your dataset.Try out.It might help.

    Regards,

    Keshav Kumar

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    Hi DMaria

    I am currently encountering the same issue. Have you found a solution?

    More details about my situation:

    1. I have a new report with a new query

    2. The report accepts other other queries, but not the above mentioned one - I get the same error as you specified in the OP

    Things I have tried

    1. Rebuilding & synchronizing query and it's datasources

    2. Drag the query in

    3. Specify the query through the wizard

  • Verified answer
    DMaria Profile Picture
    DMaria 285 on at

    I couldnt find solution. After many synchronizations.. aos restart etc. the rest of the reports started to work.

    I think there is a bug in that query. How I resolve the issue? The field I wanted to get from the query I picked in the XML document.. added it to design and it works for me ! :)

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    Thanks

    For interest sake: "...the rest of the reports started to work." What do you mean by that? Did you get the error for existing queries? I get the error when trying to specify the query in the report designer.

    I am not getting the error anymore - I don't know what did the trick. It just simply started working.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans