How to extract all the data in a ssrs report?

(0) Share

Report

Posted on by Community Member

Hello, I'm doing a ssrs report and have as parameters the vendors' regions to show sales, they ask me if I leave the empty parameter space, bring me all the regions consecutively, can you help me how to do it? Thank you so much

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello, thanks but when I refer to regions I mean parts or divisions of a country, where each division or region has a group of sellers, the report is to show sales of vendors by region. If the field of regions is left blank, you must bring me all the regions, if you understood me?

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

In your ssrs report you should have a query range to filter data by region, so just add new logic not to apply filter if region is blank.

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (1)

Report
Copy link

Link copied!

Carolina,

Is that region parameter from a query or data contract of a data provider?

If it's a query range, you can leave it empty, and that range will not be applied. If your report is using data provider, you need to make sure your logic of finding data skips that criterion when it's empty.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you Sukrut Parab, ievgen Miroshnikov and Andrew Xu, that's exactly what I'm doing, I'm using this sentence:

"where lineofBusinessId like + '*'"

so that if I leave the field empty I will bring all the data but it does not ...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you, is data contract of a data provider. I'm doing, I'm using this sentence:

"where lineofBusinessId like + '*'"

so that if I leave the field empty I will bring all the data but it does not ...

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report
Copy link

Link copied!

remove "lineofBusinessId like '*'" and try again.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

You would like to add the condition, if user provided the parameter then use that else no need to use the where clause for that particular column.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Andrew Xu

Thanks, I did it and it does not solve what I want...

Was this reply helpful? Yes No