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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by flmngldn

  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