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!

Register Log in
  • Congratulations derfloh 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. DavidSherring

    recursive sql call

    I have a table with a key, and a previous key. I need to recursively step through the table until I have the key with no previous key (i.e the original record). Is there an sql command I can use to do this, or do I need to program? Field Names are resource_bookings.resource_bookings_id and...
  2. DavidSherring

    Using Sql for temp tables or cursors to build up query

    I am currently working with Oracle, on a database that was very client/data driven. Users could set up practically what they wanted for collecting information, thus we ended up with lots of duplication, and lots of tables containing labels and data. To run reports, to gather all the data, many...
  3. DavidSherring

    Grabbing data field without linking table

    I know from previous work placements that it is possible to grab data from tables without linking, if you know the table, the field, type, etc, and call using a variable or value from calling report. I don't know if this has to be done in a programming environment, or can be done from crystal...
  4. DavidSherring

    Subreport select based on main report select

    I have a main report with data filtered by select. I would like exactly the same select on my sub report. But I want my sub report to have it's selects automatically mirroring the main report selects. Do I do this with shared variables? Anyone got an example anywhere? As per usual, I'm...
  5. DavidSherring

    Drill down different in Enterprise and Crystal environment.

    I can't seem to get drill down working for a certain report, within the crystal enterprise environment. It drills down in crystal, but not enterprise. The report has 4 groupings. In the 4th grouping footers, there are conditional printing, managed from the sections editor. The important thing...
  6. DavidSherring

    Connection to Oracle - Can't see tables, only procedures

    I am connecting to Oracle 10g, through ODBC drivers, from Crystal 9. When I am connected, I try to add tables to my report, only to find there are no tables there, only programming procedures and code. The previous person to use this machine and write reports here used to write solely in...
  7. DavidSherring

    Grouping on Text Field - Not building tree in Enterprise

    I have used the (very useful) tip of having dynamic grouping within a report by defining a parameter and then assigning it a field. See Example. select {?group} case 'COURSECODE': totext({MBDA_FREEZE_DATA.COURSECODE}) case 'CLOCK' : totext({MBDA_FREEZE_DATA.CLOCK}) case 'COURSE_TITLE' ...
  8. DavidSherring

    concatenating strings in crystal reports

    I am trying to concatenate two strings, with a comma and space in the middle. If one of these fields is a blank or null, then the whole string doesn't print. I have never come across this before. Anyone help, sorry it is such a pathetic question. {VENUES.VENUE_NAME} +", "+ {VENUES.LOCATION}...
  9. DavidSherring

    Filtering report by Parameter

    I am inviting user to input company codes that they wish to exclude from the report. I am then trying to execute the following lines in report record selection formula editor {COMPANY_ADDRESSES.COMPANY_ID} not in ({?Excluded Companies}) I keep getting error 'The remaining text does not seem to...
  10. DavidSherring

    Crystal v9 "Maximum processing time or maximum records limit reached"

    I am running Enterprise and Crystal Prof v9. I get this error message having posted and run a report on the enterprise server. I can find solutions to v11 but not 9, which seems different. Anyone can help ?

Part and Inventory Search

Back
Top