Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vancoug

    Find specific email addresses on scheduled crystal reports

    Hello, Does anyone know of a way to query for specific email addresses associated with scheduled instances, using the Business Objects Business Intelligence platform - Query Builder. I have a report object with hundreds of instances and I'm trying to find instances for specific email addresses...
  2. vancoug

    Only email Crystal Report if populated

    Hello, Is it possible with crystal reports/crystal server XI to set up a report that would only be mailed out if it was populated? I need to create a report for email distro. that would only go out if the query returned results. Thanks-
  3. vancoug

    Database Connector Error

    We are having trouble with scheduled reports failing with this error: Error Message: Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\phb.reportjobserver\~tmp3e05cce41f38015.rpt: Database Connector Error We are using Crystal Reports/Server 11.5...
  4. vancoug

    datediff with max function crystal reports

    I am using Crystal Reports XI with odbc driver to pull data from a remedy data source. 99% of our reports go against oracle and I can use the command object to build sql queries- which gives way more flexibility. The report I need help with (going against remedy with ODBC) can't use the command...
  5. vancoug

    Crystal converting varchar 254 to memo

    Hi All, We are still using Seagate Crystal Reports 7.5 for some of our reporting. I have a problem that hopefully someone can help with. One of our connections is to ODBC- AR System ODBC Data Source. In that data source there are fields defined as varchar 254 (confirmed by DBA), But Seagate is...
  6. vancoug

    Crystal Reports converting varchar 254 to memo data type

    Hi All, We are still using Seagate Crystal Reports 7.5 for some of our reporting. I have a problem that hopefully someone can help with. One of our connections is to ODBC- AR System ODBC Data Source. In that data source there are fields defined as varchar 254 (confirmed by DBA), But Seagate is...
  7. vancoug

    An error when I use InfoView to modify scheduled instances

    Is anyone familiar with this error: [b]An error has occurred: Object reference not set to an instance of an object[b/] In the past if I wanted to make a change to an instance of a report; i.e. change the when, database logon, filters, destination, format, etc. I could use the InfoView, click...
  8. vancoug

    get rid of .00 from field

    LB Thanks- I appreciate your time.
  9. vancoug

    get rid of .00 from field

    I have a field (data type number) that always ends in .00 There is always a number preceding it, but the length varies; e.g. 1234.00; 12345.00, 123456.00 In the past I have always been able to format the field with the format editor and export as xls file, but when I try to export as...
  10. vancoug

    need results of full work week two weeks back

    LB- after I posted last night in a couple of forums I could see it was being viewed but no replies so I reread the post to see if it made any sense and thought the answer was right in front of my face- as your post confirmed. But when I tried it I didnt get the results i thought I would. I...
  11. vancoug

    need results of full work week two weeks back

    I wanted to pull the results from two date fields and calculate the lapsed time. Both dates in the calculation are from the same field, so I used the command feature in Crystal to differentiate the two SELECT max("A"."CREATED_DATE") as installerContactCreatedDate, TO_NUMBER("A"."OBJECT_KEY")...
  12. vancoug

    help with converting DECODE Function in sql statment into formula fiel

    I know this will sound stupid, especially here, but I am having trouble with this. I know decode is like a if-then-else statement, but I am having difficulty converting this into a IF-THEN_ELSE statement to be used in a formula field in Crystal Reports. I am a new-B and any help would be...

Part and Inventory Search

Back
Top