Using Parameters in DataSet

Using Parameters in DataSet

Posted by: duonghb53 on 3 July 2021, 4:54 am EST

• 

  duonghb53

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 July 2021, 4:54 am EST - Updated 30 September 2022, 4:38 pm EST

  Dear Support Team
  
  Now, I have a DataSource using SQL Provider and 2 DataSets:

  • A using queryA with return Fields are a1, a2, a3
  • B using queryB.
    
    Can I Add parameters using a1, a2, a3 from DataSet A in queryB DataSet B.(Please view image below to more details)
    
    Thank you very much.

  

  1350×1214 57.8 KB

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 July 2021, 12:55 am EST

  Hello,

  You can refer to the following link:
  
  https://www.grapecity.com/activereportsnet/docs/v15/online/add-a-cascading-parameter.html

  Thanks,
  
  Mohit

• 

  duonghb53

  • Post Options:
  • Link
    Copy

  Posted 5 July 2021, 1:42 am EST

  Dear mohitg
  
  Thank you for your answer, but I don’t want add a parameter. I want use used directly in DataSet Parameters by Field of another DataSet.
  
  Can I do this?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 July 2021, 1:36 am EST

  Hello,

  You can hide the parameter and set the default value of parameter to value of the DataSet1. Please refer to the attached report for implementing the same.

  Thanks,
  
  Mohitrpt_Cas.zip

• 

  duonghb53

  • Post Options:
  • Link
    Copy

  Posted 6 July 2021, 3:43 am EST

  Dear mohitg
  
  Thank you.
  
  Your answer help me very much.