The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Please could any one help.
We are creating a paginated report and few fields are added as parameters. When we try execute the query in query designer, the blank values are showing.
When we close the query designer and run the report, it will not show these blank values. There is one field which is causing this trouble. When this field is added to the parameters, blanks values will not show for it as well as other parameter fields as well.
Sample data below:
The check box for show blank values and multivalues is enabled for all the parameters.
The report builder is connected to a dataset for which the source is SAP HANA. We create all the reports by connecitng to this dataset.
Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
ABCD | qwe | asd | AS1 | |
ABCD | qwe | asd | AS2 | |
ABCD | qwe | asd | AS3 | |
ABCD | zxc | jkl | AS4 | |
ABCD | zxc | jkl | AS5 | |
ABCD | zxc | AS6 | ||
ABCD | AS7 | |||
AS8 | ||||
AS9 | ||||
AS10 |
Kind Regards,
Vinod
Solved! Go to Solution.
The latest version (15.7.01678.0001) of the report builder is having a bug and hence this is happending. If we use the previous version, this issue would be resolved
The latest version (15.7.01678.0001) of the report builder is having a bug and hence this is happending. If we use the previous version, this issue would be resolved
Still the same issue is occuring for me now is the issue still not adressed.. or please suggest me a solution for this.. how to get the previous version of report builder.
Hi, @Vinod_V_12
You mean all the other parameters are working and only parameter 4 is not working as expected, is that right? I think it has something to do with your parameter Setting. Check your parameter Setting.