Help, Scheduled a Cry. Rpt. in Seagate Info: no database output

[Tobbie]

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 report in Seagate Info, I receive no output from the fields being used. I am not to familiar with Seagate info, so I was wondering if I am skipping a step in the database connection. When I scheduled the report I filled in the correct logon, server, database, etc. information in the LOGON tab. Am I missing something else ??? Any help would be very greatly appreciated. I am trying to have this completed by the end of the week. This is very important, so please offer any help. Thank you !!!

 

[Nuffsaid]

Hi Tobbie,

Are you receiving any error messages at all? Or is Info just producing an instance(report) with no information?

When you right click the report to schedule it, check the "Properties" Option, (refresh the report), is all well?

Let me know...

Nuffsaid

 

[Tobbie]

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.

 

[rhinok]

To clarify, the report runs but there is no output?

Generally speaking, I'd say that the record selection statement caused no records to be returned, but there are alot of variables...

1) Double-check your record selection criteria
2) If you have parameters, did you enter those parameters when you scheduled the report from Seagate Info?
3) Did you leave a parameter field blank? Seagate Info will interpret a blank or null parameter as a literal value (unlike Oracle Reports, for instance, which interprets a blank or null parameter as a wildcard).
4) Did you build the report against a Test database that may have different data?
5) Are you using Case-sensitive SQL? Some databases do not acknowlege case-insensitive queries even if you've checked the option in Crystal Reports.
6) You say that the report uses database fields to perform calculations - are you using SQL Expressions? If so, is the same ODBC or Native DB driver resident on the Server Vs. your machine? The available SQL Expressions are limited to your driver.

Hope this helps.

 

[Nuffsaid]

Hi Tobbie,

Rhinok has provided some valid posibilities, check them out.

You say that you,re "New To Info" so please don't be offended by what follows.....

1) Is this the only report that you are haveing trouble with?

2) What type of DB are you feeding off of? And, how do you connect (ODBC, Native, Access)

3) What are your rights within "Info" (user, administrator?)

4) You say the report was created in Ver 7, was it created "Outside Info" then "Imported" somehow?

Anyways enough with the questions............

Here's what I would do.......

Log onto the Info Desktop, right click the report that's causing problems, select the first option, (open with designer, I'm working from memory here so excuse me if I don't get the exact terminoligy). This should launch the RDC (report designer componet...Crystal 7.?). Refresh the report, does anything come back?

If so, you're problem is occuring due to some ommission during scheduling, if nothing comes back.....futher investigation will be required.

Give it a shot, keep me posted.......

Nuffsaid