Recent content by Tobbie

How do a search a field that contains firstname and lastname for a space which seperates the two. For example the field "Name" contains the string "John Doe". I need a sql stmt that will search "John Doe" for the space. Also, in the result I would like to split...

I am scheduling a Crystal Report and using Seagate Info to send it via email. The report runs successfuly and can be viewed using Info Analyzer, however the email which is sent cannot be opened. The error states " The managed Software Installer failed to install the program associated...

Nuffsaid, Thank you for your reply. I am receiving no error messages, just an instance of the report. I tried refreshing the report and still no luck. I am ready to pull my hair out. Any help you can offer would be greatly appreciated. Once again thank you.

I wrote a Crystal Report in Version 7 and wanted to use Seagate Info to email it to various clients of the company. The report used database fields to perform calculations, etc. When tested in Crystal the report connects to the database and the report runs fine. However, when I scheduled the...

I am having problems scheduling a report written in Crystal 8.5 using Seagate info 7. I thought perhaps it was because Crystal 8.5 is a more advanced product and may be incompatible in some areas. The report runs fine in Crystal however I encounter formula problems when I run it in Seagate...

Once again the formula in the previous response was copied incorrectly, here is the correct formula: shared TimesIn as number TimesIn = timesIn + 1 formula = TimesIn

The formula in the previous response was copied incorrectly, here is the correct formula: shared TimesIn as number TimesIn = timesIn + 1 formula = TimesInshared

The formula I am using is as follows: shared TimesIn as number TimesIn = timesIn + 1 formula = TimesInshared TimesIn as number The formula was written in Basic Syntax. I have run checks on all the formulas in the report and have found no errors. None of the formulas are complex. The report...

I wrote a Crystal report using Basic syntax for my formulas. I have no problem with the report in Crystal, however when I try to schedule it using Seagate Software I keep getting this error &quot;PEStartPrintJob : Error in formula <PageCount>. 'shared TimesIn as number&quot; There is no...

I am tryong to use 2 different tables without joining them together because they have no correlation to each other. One table I get all the data but for the other everything is 0(No Data). How can I get around this?? Please help. Thank you very much.

When I save my Crystal Reports to my desktop or any folder they do not open. I receive a message stating that &quot;Cannot find file...Make sure filename and path are correct&quot;. However if I go into Crystal Reports and open the file from ther I have no problem ?? This just started...

I was hoping someone could tell me if the user has to have Crystal installed in order to run a Crystal report. Stupid question but I don't know the answer. Anyone who could answer I would greatly appreciate it. Thank you

I just installed Seagate Info on my computer and would like to schedule a Crystal Report to be sent via email once a month. Also, the report requires two date parameters. How do I set this up ??????? Any help would be greatly appreciated. Thank you

Can someone please help. I need to know how I can use the tablename as a paramaeter for my sql query ???? Do you have to specify the tablename when creating the report? What do you do if the user can use the same report but on different tables ?? I hope you can understand what my question is...