Hi everyone,
I'm having to use Infomaker to create some order confirmations for a few of my departments, and I was wondering- is there a magic way to add large amounts of static text (think Terms and Conditions) to the report, or am I really stuck to having to use a million fields of 255 characters at a time? I would like to *not* have to do a separate document in Word of the Ts&Cs that would get stuffed in with the infomaker document, but if it's that or my sanity... :-)
Thanks!Kathleen
I just bit the bullet and typed that stuff out line by line. Fortunately, I was able to get the final version of the copy (the 4th final version of the copy, after they had come back and changed it 3 more times) before I had to start putting it in there. It was not that bad in the end, and I have not had to go in and change it since then.
I suppose you could try storing that somewhere in Tessitura like a local system table as like a VARCHAR(8000) and then select that as a giant massive column into your form. But I have never tried that and am not sure how it would exactly work. Plus, your options for formatting would be extremely limited.
But such is the case with InfoMaker. Best of luck!
John
Hi Kathleen,
That 255 character limit is a pain! In cases like this, I actually have the text hardcoded into the stored procedure and returned as a text field - not elegant but it works pretty well.
As John comments, as the text is returned as a single string, formatting (italics, bold, etc) is not possible. I haven't considered a local system table as we don't have (not yet, anyway!) variables that need to be printed that are longer than 255 - although I can't see why this wouldn't work.
Martin
Just a suggestion, but I moved a lot of confirmation to constituent reports for the formatting flexibility. But, I do have some in Infomaker still and there this is simply a limitation of the software.