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 TouchToneTommy 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: *

  • Users: diane55
  • Content: Threads
  • Order by date
  1. diane55

    Help with displaying lines on change of Group Header 2 data change

    I am working with MSSQL RS 2008 working with the new app for 6 months or so...migrating Crystal reports. I need to display a line to seperate a change in the group header 2 data. I have done several searches via google ect without result...any thoughts or direction would be appreciated. Thanks...
  2. diane55

    ORA - 1427 Correlated Query issue

    Thanks ahead of time for your review! I am on Oracle 9i trying to write an update query. Below is the query that returns an error: ORA-00913: to many values When I remove the p.case_id I get the following error: ORA-1427: single row query rturns more than one row. What i am trying to...
  3. diane55

    Supress Group Header w/supressed records present

    thread767-1068492 I need to inquire more on the response posted in the thread noted above by lbass. What if I want to supress the group header and there are records in the group they are just supressed? Crystal X Any thoughts D Thanks! :)
  4. diane55

    Compare resultant Date Time in subreport to UpDtTm column in main rpt

    First, thanks for taking time to read my post. I am not sure I have provided enough detail so let me know... I need to compare DateTime result in SubReport to Date Time in Main Rpt. I am using CR Dev. 10 Oracle Database I need to take the resultant Max Date from the subreport and compare that...
  5. diane55

    Wrong Day Name using WeekDayName()

    I am running Crystal 10 on an ODBC database. My question - In the Crystal Report I am creating I have created a formula and placed it in the page header. The formula is "weekdayname(dayofweek({tableName.columnName}))" The outcome of this formula is "Wednesday". The columnName (date) of...
  6. diane55

    Dates Entered in Parameter different In Display Tab view

    Crystal 10 Oracle Database ODBC connetion I have a report that has a parameter prompt for the Date Range (Begin and End) I enter the Date Range the report pulls the correct records using the date entered. The issue is that when I display the report via the Display tab on the record tree (on...
  7. diane55

    Suppress Blank SubReport

    I am developing a report in CR10 - I need to suppress a field in my main report based on if the subReport is suppressed (via no data being returned from subReport). Is there a function/command to check if the Suppress Blank subReport (checked in the format Editor subReport tab) is true. Any...
  8. diane55

    Default Duplicate Record Suppresion option?

    I have a SQL procedure that returns a record set that is passed to Crystal 9.0. The record set from my procedure includes two records that appear to be duplicate, but are actually different. However, the defining element is not a part of the actual SQL record set; therefore it is not passed on...

Part and Inventory Search

Back
Top