Skip to main content

Hi,



I have a requirement to group the data and display in the read only form. 

 

I have two table one holds the experiments user have seclected and other holds the properties associated to the experiment user have selected. In the action form I would like to display the data in the following format.



experiment ID1
Experiment Date
Status
Property Name Current Value New Value

experiment ID2
Experiment Date
Status
Property Name Current Value New Value

experiment ID3
Experiment Date
Status
Property Name Current Value New Value

 

Looking for any solution

1. Custom Webservice will it work?

2. SQL query a view and subview??

3. Store procedure???
Any help for the above is appriciated

Hi,


 


I would write a stored procedure to join the tables and list the required fields then design a list view to display the data


when you design the list view, add one column only as displayed below:


 



 


then you can format the data using HTML, to do that you will need to add an expression on the data label column. for example:


 



 


Results:


 



Reply