C1Report Parameters Filter SQL Data

C1Report Parameters Filter SQL Data

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

• 

  eduardo.cardia

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 March 2023, 8:07 am EST

  Hi!
  
  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?
  
  Tks
  
  Cardia

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  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:
  
  https://www.grapecity.com/blogs/custom-parameter-dialog-in-c1reports

  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:
  
  https://www.grapecity.com/componentone/docs/win/online-flexreport/Multi-valueParameters.html

  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

  Regards,
  
  Prabhat Sharma.