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

  1. flmngldn

    Help looping thru arrays

    Working with 8.5 Crystal reports I have written a report that gives me the data I have published below. The subreport data (SN and RATIO)is from an excel file and I am passing the cost over to the subreport for EXTCOST calculations. What I need to do is group on the SN from the subreport and I...
  2. flmngldn

    Looping thru excell file

    I am trying to create a report(8.5) where I have database and an excel file. The database format: Part# partdesc Qty cost ref 12345 Trays 5 10.00 535/538/537 78901 Pencils 8 0.80 123/456 56789 Paper 20 1.50 567 excel format: serial# %cost 535 30 538...
  3. flmngldn

    Extract multiple values

    Thank you for the information. The database is pervasive. Sorry for the spelling error. I tried this and I got the message "The result of a formula cannot be and array". I am new at this and I know I am missing something but not sure what. I need help in writing this code. Thanks
  4. flmngldn

    Extract multiple values

    I am working on Crystal 8.5. database is Persive and excel file I have a record of Purchase order that contains parts and its cost. There is referencce field containing the following: 735/736/737 ( This could be multiple numbers with "/" as deliminator) Excel File) 70035 ( project#) 735(SN) 20...
  5. flmngldn

    Adding DB field on summary report

    I am using Crystals 8.5 and accessing data from Access database. I went to Database->Show SQL Query and this option is greyed out so I cannot see the SQL code.
  6. flmngldn

    Adding DB field on summary report

    I created a report that summerizes data ( with drill down). All the data on the report looks fine. Now I want to add the description of the project. As soon as I insert the field on the group level my total field changes. I am not sure what is going on but I need help
  7. flmngldn

    Help with formula

    Thank you. Worked like a charm
  8. flmngldn

    Help with formula

    I am trying to create a report in 8.5 I have database table for labor tracking. I want to create two columns where 1st is week(prompt) and then the 2nd is rest of the data. This is going to be a summary report (with drill down)based on project# and task#. Here is an example: Database: Project#...
  9. flmngldn

    How to add text in crosstab reports?

    Could you please share how you did that?
  10. flmngldn

    How to add text in crosstab reports?

    How do I add row heading in the crosstabs? Using Crystal 8.5

Part and Inventory Search

Back
Top