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 strongm 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: CRCRCR
  • Content: Threads
  • Order by date
  1. CRCRCR

    Rounding to 2 Significant Figures.

    Has anyone managed in Crystal to round to significant figures. (Not decimal places) I've tried replicating the old excel trick, from http://www.vertex42.com/ExcelTips/significant-figures.html which gives =ROUND(value,2-(1+INT(LOG10(ABS(value))))) In excel plugging in the value of 1.44...
  2. CRCRCR

    Create table and records macro..

    I'm not sure is this is really possible. I can do this manually using Excel and pasting the results back into Access, but would love to have a proper solution. I have an Access database of (scuba) dives. I create a report of the data using Crystal. I have created a whole new table, to...
  3. CRCRCR

    Charting summary information...

    Hi, I'm using CR XI, Oracle DB, via ODBC. I'm trying to chart analytical results, and struggling to find a complete solution. A simplified version of my data is Sample --> Test -- > Result. 3 tables. for the moment, I'm developing the report with just a small subset of results using record...
  4. CRCRCR

    Left Outer Joins not returning records in Right Table.

    Hi. I have a report with 3 Tables SAMPLE, TEST and RESULT. Samples have Tests and Tests have Results. "One to many" In each case. To hopefully illustrate my problem, say I have a SAMPLE which has the Weight TEST, which has Start, Finish and Difference RESULTS. The report works as expected...
  5. CRCRCR

    Cascading Dynamic Parameters

    I'm having problems with cascading dynamic paramters in CRXI. To aid with explaing I shall refer to Countries, and Cities. I have ~ 900 Countries, each country having ~ 10 cities in each. I have a country table, and a city table (which has a field City.country) which I use to join the tables...
  6. CRCRCR

    Stop rounding on numeric field

    Hi, I have CR10, on a SQLServer DB, through ODBC I'd like Crystal to return EXACTLY what is in the database for a numeric field. To illustrate, I have 2 fields. R.Formatted_Entry which is a string and R.Entry which is a numeric. The R.Formatted_Entry displays as it should, i.e exactly what...
  7. CRCRCR

    Grouping on a "non DB field" Parameter

    Hi, Finally managed to register with the best Crystal Forum out there. Hopefully I can start answering some questions myself. I have a problem, which I hope the attached picture may help to explain. I am trying to group on a parameter. This parameter is not a database field, just a plain...

Part and Inventory Search

Back
Top