Skip to Content
avatar image
Former Member

no data

I have an oracle database that I getting my data from. I created a report with fields.

wo, base_date, hours_1,hours_2,hours_3. I run the report and all is well. I get data in all 5 fields. I added a selction to my query for base_date = '13-jul-2008'.

Now I get the correct data, only data with base_date = '13-jul-2008', but I have no data in fields hours_2 and hours_3. I still have data in wo, base_date and hours_1.

has anyone ever had this problem?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Sep 04, 2008 at 04:31 PM

    In the Crystal Reports designer under the database menu there is an option that says "Show SQL query", select this and copy the query. Now download and run SQL Con, connect to the database and run the query from there.

    https://smpdl.sap-ag.de/~sapidp/012002523100006015092008E/sqlconn.zip

    Does it return the data? Perhaps there is no data for those fields for those dates.

    Trevor

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:42 PM

    Trevor,

    Thanks for the info. It does have data in those fields for that day.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 07:47 PM

    2008

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 08:21 PM

    Hi Tony,

    Is this happening in the stand alone CR 2008 designer or only in an application you have created?

    Jason

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 09:43 PM

    Tony, since this is specific to the CR designer, please post the query to the Crystal Reports Design forum:

    SAP Crystal Reports

    This forum is for users encountering issues with Crystal Reports in Visual Studio .NET.

    Thank you for your understanding,

    Ludek

    Add comment
    10|10000 characters needed characters exceeded