Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Paginated Report with multiple of parameters as input

Hi!

 

I've created a rather simple paginated report connected to AAS, but I have a problem. I want to have a parameter with the order number value, and I want to be able to have multiple order numbers as input. For example I want to be able to insert "XXX, YYY, ZZZ" in the parameter field and then the report should give back the information from the three order numbers.

 

The problem is that we have A LOT of order numbers, therefore a multi-select option is not what I want since I can't scroll through a list of thousands of order numbers, when choosing my parameter. I just want to be able to insert a string with several order numbers. I can make it work with just one order number.

 

I think I'm rather limited since I have a connection to AAS, I can't make any customized queries to the data source. Any ideas on what to do? Thanks in advance! 🙂

 

/Ella

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous!

     

    My solution was to change data source unfortunately... I connected directly to our Azure SQL DB and then created a stored procedure which did the job. I'm sure your solution would have worked just as fine as the stored procedure did 🙂

     

    Best regards,

    Ella

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous!

     

    My solution was to change data source unfortunately... I connected directly to our Azure SQL DB and then created a stored procedure which did the job. I'm sure your solution would have worked just as fine as the stored procedure did 🙂

     

    Best regards,

    Ella

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

      Thanks for your answer 🙂 The problem is that I use a connection to Azure Analysis Services and think I'm rather limited in what I can do with my query... But I absolutely understand the solution, and will investigate what I can do with it. Thanks!

       

      /Ella

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

        Yes, the Azure Analysis Services data source is a problem and the method I mentioned in my previous reply may not work with this data source. Do you get the corresponding solution when your data source is Azure Analysis Services? If so, could you share your solution if it is convenient? Then the others in the community who encounter similar problems as yours can also get some clues or ideas or even solve their problems through the solutions you shared. Thank you in advance for your sharing and time. Thank you.

        Best Regards