I want to design a report which can be saved as a text file. Based on a set, the main table 'produces' a header text line; there are then various individual text lines in the detail section on the number of filtered records in the linked table; and a footer text line containing totals from those individual lines.
The problem is that each of the lines in the detail section of the report is 773 characters long. Various fields are used for the first 157 characters plus 14 other sections of 44 characters each- again extracted from comprised of various filtered fields.
I can probably achieve the 773 characters in one text line by increasing the report width but I have to split the detail line into various calculated text fields because the size of these is restricted to 256 characters - can't use a calculated Memo fields since this is not an available option.
I experimented with one field of 157 characters and some more of 44 characters each. This creates a problem of spacing between the fields because about 5 spaces appear between each of them in the final text file and I don't know how to overcome this in the report line design.
Obviously I could prepare the file in xbasic using write_line etc routines but the coding is complicated and difficult to make error free. I also tried a summarise operation for the header/footer line details (works well) and a crosstab operation to simplify collecting the data needed for the detail lines but I would need 14 of these creating different tables due to differing filter problems!
Has anyone any suggestions please, preferably to help me overcome the spacing problem mentioned above? Mike Vance
The problem is that each of the lines in the detail section of the report is 773 characters long. Various fields are used for the first 157 characters plus 14 other sections of 44 characters each- again extracted from comprised of various filtered fields.
I can probably achieve the 773 characters in one text line by increasing the report width but I have to split the detail line into various calculated text fields because the size of these is restricted to 256 characters - can't use a calculated Memo fields since this is not an available option.
I experimented with one field of 157 characters and some more of 44 characters each. This creates a problem of spacing between the fields because about 5 spaces appear between each of them in the final text file and I don't know how to overcome this in the report line design.
Obviously I could prepare the file in xbasic using write_line etc routines but the coding is complicated and difficult to make error free. I also tried a summarise operation for the header/footer line details (works well) and a crosstab operation to simplify collecting the data needed for the detail lines but I would need 14 of these creating different tables due to differing filter problems!
Has anyone any suggestions please, preferably to help me overcome the spacing problem mentioned above? Mike Vance
Comment