I want to create a report with multiple "Sample IDs" as column header in the report. I used a crosstab query to put all the "Sample Ids" (as records in the database) as columns in the heading of the report. Multiple analytical results are placed under each "Sample Id". At present I have 30 "sample ids" and there will be more in the future.
The problem is I get the following error message when I creat the report "the wizard is unable to creat your form or report because you selected to many fields, please try again with fewer fields."
My question is how do I get around this? As I said, I have numerous "Sample Ids" and would like to keep them as column in the header of the report.
The problem is I get the following error message when I creat the report "the wizard is unable to creat your form or report because you selected to many fields, please try again with fewer fields."
My question is how do I get around this? As I said, I have numerous "Sample Ids" and would like to keep them as column in the header of the report.
