News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Add blank/empty values...

Dynamics 365 general forum

Add blank/empty values to SSRS parameter that get value from Query that using Microsoft dynamics 365 Fetch XML

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

1563.Untitled.png

I'm trying to write a report For CRM Online in FetchXML. I want to use pre-filtering to force users to run the report from the Account form so the results are limited to one account because my database is quite large and if they use the Advanced Find they are likely to break the report.
So ,

Building DS uses a query which includes a pre-filtering parameter, '@AccountNo' &
Floor DS uses a query which includes a pre-filtering parameter, '@Building' &

Room DS uses a query which includes a pre-filtering parameter, '@Floor' and so on.

My Issue for example if Floor not have any Room i need to add empty value to Room DS to get the result .

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Darshik 295 on at

Like (0)

Report

RE: Add blank/empty values to SSRS parameter that get value from Query that using Microsoft dynamics 365 Fetch XML

Hi Mina Tawdros,

In Dataset Query define the parameter on the top of the Query.

SET @startDate = COALESCE(@startDate,'1900-01-01')

SET @endDate = COALESCE(@endDate,GETDATE(

also in report parameter select option as pass null value in the parameter.

Regards,

Darshik

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans