Recent content by AKPolarBear

I figured it out. I also have a lot of screenset modifications and user groups that I did not want to loose. My solution was to create the view only company, create a single user for it with restricted view created through visual menu builder and then changed all the current users passwords so...

I want to preserve the data of a company and still allow users "view only" access. In other words, they need to see the data, run the reports but not be able to manipulate any of the data in any way. This is a company that is no longer to be used but the historical data needs to be visible for...

No, but it sounds like a possible workable idea. I don't know how they would feel about the extra step however. We do use quotes for our returns. In Macola, returns or credits are immediately applied to a customers account. We sometimes have to wait for it to be shipped back and inspected...

Andy, From what I have read in SQL forums, it sounds like skipping SQL2005 and going to SQL2008 is a better choice especially if coming from SQL2K. That didn't answer your question but if you have to upgrade, once is better than twice. Curious, why only 4 users and not all?

I would also find out who has access to the System Maintenance and find out if they tried to delete the user. Generally, users don't just get deleted without some sort of user intervention. Did you try to remove the user from the module maintenance and then delete it from the non-group? Also...

We won't be upgrading. Other plans are in progress. The real issue is Macola's lack of OE number control. It doesn't take too long to figure out how to circumvent the system. As I said, we discovered this problem on the second day and its still not fixed by Macola, at least through this...

Just off the top of my head, I think you can run your checks by the currency type. If so, then create two check formats, one for each currency type and modify the check format as needed. One for "US Funds" and the other for "eh? Funds". Might also be useful when reconciling the checks if the...

I forgot to mention we are on 7.6.100a and use SQL 2000. We are a terminal Server based operation. No PC's with Macola.

I have discovered an anomaly that is partially known but have never seen it used (abused) in this way. This is more of a comment than a question but maybe somebody has seen similar and knows why it did what it did. A customer called yesterday about an invoice they received. The billing info...

After a short, unplanned distraction (the company was bought out), I am back to chasing this problem. If a user runs a CR to screen and then wants to print it, when they click on the printer set up icon, the entire crystal screen vanishes away. No trace, nothing left behind. Same as closing...

-Some reports run without error -Some reports run but only return field information and no data (zeros') for any formulas used in the report -Some reports do not run The above applies to some users but not all. This may be because not all users run the same reports. Admin can run reports...

I copy the Crystal folder into the users profile location on each of the terminal severs. Same as with NT TS. I am wondering if it's just the a version incompatibility between Crystal 7 and Server 2003? The Crystal program files are on a W2K server with the Macola Program and are accessed...

A copy of the Crystal directory is in each user folders under their windows directory. I did notice a report failure under admin but I'll need to confirm that first. It was from the server and not through a session. I'll check the dll paths.

Both Kevin and dgillz are correct, that is information that is not appropriate in this forum. That said, I've been in the same boat and dgillz helped me out then and I would recommend him now. And for the price paid to JD Ewards, they can't help?

Does anybody access Crystal 7 from W2K3SP1 Terminal Server? Our Macola 7.6.100a/Crystal 7 run on W2K servers but are accessed by users from the W2K3TS. Macola & CR7 we set up on the Terminal Servers per the normal Macola instructions. Macola users have no issues and so far, nor do queries from...