Hi support,
Can you help me with the following please, as i think that there is an error in the software.
In a product_table i have to fieldnames (Group, Subgroup) both numeric values as they are connected with
a dropdown-box, linked by ID-number, Showing GroupName/SubgroupName and SubgroupName is depending on the value of the GroupName and Display-Field is the text field of the table.
For example
Group_Table: ID = 1, GroupName = Computers
Subgroup_Table: ID=1 SubgroupName=Pentium
Creating a html report:
Group by field 1: Group (numeric field which links to Group_table.ID)
Group by field 2: Subgroup (numeric field which links to Subgroup_table.ID)
Showing all the field names, all ticked
Layout: Blocked
click through to Build
After that you open the site up in your browser and the following is happening:
The report is showing only the numeric values in the report which have been saved in the table, NOT the GroupName(text) and SubgroupName(text) as stated in the field dropdown-box display-field.
Working with ASPRunnerPro v6.2 build 5482
The only way round it is creating text-fields instead of numeric-fields, but if you change the name of a subgroup, you have to edit 1000's of records by hand.
Could you please help ASAP
Many thanks
Maurits