Two Parameters are required in Paginated Report, pls help

[Ayyappa5678]

Hi Team,
I am new to paginated report develop using report builder.
Here my data source is azure databricks, and my query is
I need to create 2 parameters like track_id and barcode_id, If user enter track_id values or barcode values then data will shown in table visual, user will enter either few track_id or few barcode_values. Then results shown in table visual.
I have done below workout,

Azure databricks-> Power Query -> created 2 paramters in power query -> Making as List Type with passing any values for both parameters -> and same calling on the filter of IN and OR selected

Paginated -> Parameter -> created 2 paramters -> Same selected allow multi values 

Dataset properties -> calling created track_id paramter as value.

But in result I am getting exact values for track_id parameter, but barcode parameter did not works.
How we need to create 2 paramters in paginated reports?
Like user will enter track_id or barcode_id, it means for suppose few track_id shown blank so user will search with barcode parameter.
Kindly help me with this.

[DanieleUgoCopp · Accepted solution]

hello,

I think the fix is to handle null or empty parameters in your WHERE clause, so one can work when the other is not filled.

Try adjusting your query logic to something like “(track_id IN (@track_id) OR @track_id IS NULL) AND (barcode_id IN (@barcode_id) OR @barcode_id IS NULL)”, or similar depending on Databricks syntax, the idea is to not force both filters at the same time, also double check that both parameters are actually passed to the dataset, not just one mapped.

Best regards,
Daniele

[v-abhinavmu]

Hi @Ayyappa5678,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-abhinavmu]

Hi @Ayyappa5678,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[v-abhinavmu · Accepted solution]

Hi @Ayyappa5678,
Thanks for reaching out to the Microsoft Fabric Community forum.

I tried to reproduce a similar scenario and noticed that this behavior can sometimes occur depending on how the parameters are handled in the query. Since the requirement is to filter using either track_id or barcode_id, you might try adjusting the query to allow one parameter to work even if the other is not provided.

For example, you could try something like:

(@track_id IS NULL OR track_id IN (@track_id))
OR
(@barcode_id IS NULL OR barcode_id IN (@barcode_id))

And also check parameter settings, Right click --> parameter properties --> Allow Null/Blank values, do this for both id's.

Run the report with different inputs,

This approach might help in scenarios where users provide only one of the parameters. Please give it a try and let me know if it works in your case.

Thank you!

[DanieleUgoCopp · Accepted solution]

hello,

I think the fix is to handle null or empty parameters in your WHERE clause, so one can work when the other is not filled.

Try adjusting your query logic to something like “(track_id IN (@track_id) OR @track_id IS NULL) AND (barcode_id IN (@barcode_id) OR @barcode_id IS NULL)”, or similar depending on Databricks syntax, the idea is to not force both filters at the same time, also double check that both parameters are actually passed to the dataset, not just one mapped.

Best regards,
Daniele