Search results for query: *

I had a dot instead of a dash in one of my accounts. I did a "Text-to-Columns" and figured it out.

Victoria, Thanks for weighing in. I made sure there were no extra spaces. Any other thoughts? I wish it would tell me which account is causing the trouble. Very furstrating. Scott

I get the following error when running an integration. I've run it before and had no issues. DOC 1 ERROR: Non-alphanumeric characters were found in the 'Account Number' field of the 'Entries' recordset I can see no problems with my account numbers. Has anyone else run into this? Scott P...

What happened to the option to "Save As" to copy an existing integration? Is there a way to get it back? Thank you, Scott P. Dann

I want to summarize my data as follows: Donor|2007 Contributions|2008 Contributions|2009 Contributions What is the formula to put each year's summarized contributions in a column? Thank you for your help.

Victoria, Your answer was perfect! Thanks so much. -Scott

How can I pull it into FrX?

Does anyone know how to get a summary report of PO commitments by GL Number? I know how to look up an individual account by going Inquiry-->Purchasing-->Budget v. Actual & Committed. This is a great tool for a budget manager. The problem is us bean-counters need to know how much is committed...

The vendor told me where I needed to link the tables. So, it's fixed now. Thanks. Scott

I am using Crystal XI. The Zip code data base (drawing from Oracle) has multiple cities linked to the same Zip Code. When trying to pull records, a duplicate record is displayed for every City associated with each Zip Code. E.G. for Zip 44139, a record for Cleveland and Solon show up, for...

We have tried it both from a conversion to Excel from an FRD file AND directly from the output file. We finally, through the assistance of Microsoft, got it to work, but only if we didn't convert formulas. I would like it to do both the multiple tabs, and the formulas. It worked fine in Frx 6.5

This version of Frx doesn't have that option. Instead it says "formated excel".

We recently upgraded to Great Plains 9.0 and Frx 6.7 and we have been unable to export reports with multiple reporting units (and multiple pages in excel). Does anyone have any suggestions how to fix this problem? Thank you. Scott P. Dann, Jewish Community Center of Cleveland

It is taking an unbearably long time to read the records for this report. Is there anything I could do better in the record selection formula? {ARF.SQL_TRANS_DATE} in Date (2005,01,01) to Date (2005, 12,31) and isnull ({FAMILY.SQL_DEACTIVATION_DATE})and {ARF.SQL_BILL_CODE} in ["0001"to...

Thanks for your suggestions, but it didn't work. I am thinking the problem is in the data, as I have tried it in three versions of Crystal now. Any other thoughts?

It imports into Access fine. Universe/SQL Syntax error, Unexpected File name is the jist of the message.

Failed to Open a ROWSET

I am having trouble getting my IBM Universe ODBC data accessed in Crystal versions 9 and 10. Any thoughts? Thank you.

We recently upgraded our IBM/Informix Universe ODBC connection and the interface to Crystal no longer works. Does anyone have the same issues? Thank You, Scott P. Dann Jewish Community Center of Cleveland

What TABLES do I pull from?