C1Report Parameters Filter SQL Data

Posted by: eduardo.cardia on 9 March 2023, 8:07 am EST

  • Posted 9 March 2023, 8:07 am EST


    Im my Sql Table there are a columm with the informations RJ , SP, PR … per line of register and others columms with another information.

    I need to create a paremeter to filter three condicions:

    1 - All the registers (parameter blank maybe)

    2 - Only one information - examplo “RJ”.

    3 - More than one information as (“RJ”,“SP”,“PR”) IN(,)… maybe too.

    By SQL Select Where or VBscript. Could anybody help me?



  • Posted 9 March 2023, 11:04 pm EST

    Hello Eduardo,

    The C1Report has been a legacy product and has been in maintenance mode for a very long time. There is no direct way to create a multi-value parameter in C1Report but you can check out the following blog to see how you can create a custom parameter and achieve your requirement:


    FlexReport is the new flag-shipped report control, and you can easily create multi-value parameters using it. Please see the following doc link for the same:


    You can check out the “MultiValue DataBound Parameters” report in the FlexCommonTasks.flxr at the following location of your machine.

    …\Documents\ComponentOne Samples\WinForms\v4.5.2\FlexReport\CS\FlexCommonTasks


    Prabhat Sharma.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels