After I complete reports for my clients, I want them to execute them directly without seeing the CR 8.5 screens and icons. They should just be able to see a list of reports, enter any parameters and select printer, screen, file, export to excel in a stored format and then just run. Can this be done
If this is truly an accounting, order entry, inventory application, have you considered one of the off-the-shelf packages? I haven't looked at them for a while, but Macola and Business Works by Manzanita, to name a few may still exist. And there must be others. Much cheaper than custom...
I've had the same problem so I tried chr(10) - with CRW32 8.5.0.217 exporting to excel 8/0 and8.5 extended.
It looks fine on the CR screen, but does not work on the import.
The ascii equivalents of Alt/enter are:
28 Hex, 1C Octal. There is no decimal equivalent. How do I insert Hex or Octal...
If I have 2 columns and one of them is null and I use them both in the same formula, for example,
formula = col_1 + col_2, then I get a null result when col_ 2 is null even if col_1 is not null.
When they are both not null, I get a result.
I have tried to test for null as the beginning of...
Tried your solution in Basic:
formula = leadingCaps ({FORM_PRF_ALL_V.PAYEE_ADDRESS1}) + chr(13) + leadingCaps ({FORM_PRF_ALL_V.PAYEE_ADDRESS2})
But excel does not recognize the break
More help, please.
I have 2 columns, Payee1 and Payee2. I want to export them to excel and have them appear in 1 cell, under each other:
Janice Smith
Smithsonian Museum
This would be the equivalent of entering them into a spreadsheet cell directly using Alt/Enter to break the lines. Can I insert the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.