I'm making a HIS software using VB.Net and Oracle at the back end. I am facing a problem in creating a tabular report in Crystal Reports. The details is as follows:
The table structure is as follows :
Field_id.............. Param_id ....... Report_value
here field_id and Param_id togather form the Primary Key.
now i want to display report in this form:
............... param1........p aram2.........p aram3
field1......... .12............ ....23......... .........23 .......-> these are the report_values
field2......... .21............ ....25......... .........09
The values are the report_values and not aggregate or summary values.
by quering the table i can the data in the form of :
field1........ param1........v alue1
field1......... param2........v alue2
field1......... param3........v alue3
field2......... param1........v alue4
field2......... param2........v alue5
field2......... param3........v alue6
but i am not able to display the report in the tabular form. please help. The number of fields and the parameters are variable. It depends on the investigation done. so hard-coding the fields and parameters in reports is not possible.
The table structure is as follows :
Field_id.............. Param_id ....... Report_value
here field_id and Param_id togather form the Primary Key.
now i want to display report in this form:
............... param1........p aram2.........p aram3
field1......... .12............ ....23......... .........23 .......-> these are the report_values
field2......... .21............ ....25......... .........09
The values are the report_values and not aggregate or summary values.
by quering the table i can the data in the form of :
field1........ param1........v alue1
field1......... param2........v alue2
field1......... param3........v alue3
field2......... param1........v alue4
field2......... param2........v alue5
field2......... param3........v alue6
but i am not able to display the report in the tabular form. please help. The number of fields and the parameters are variable. It depends on the investigation done. so hard-coding the fields and parameters in reports is not possible.