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 gkittelson 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. angel00079

    Calculation From Various Tables

    Thanks for the info. I had forgotten about the interface. I think that I am going to concentrate on the back end if I decide to take it on. I have been doing some more reading. Am I right in thinking that I will need a stored procedure to calculate the cost and commission? I was going to...
  2. angel00079

    Calculation From Various Tables

    I have been asked if it would be possible to create a database in SQL Server. At the moment I can just create tables and join. I think that this would be a great way for me to learn more but I do not want to take it on if I am going to be out of my depth. I have included some examples below...
  3. angel00079

    Joining With Left Outer, Selection On Second Table

    Version : Crystal 11 Data source : JD Edwards I am trying to create a report that shows a certain type of item and if has any orders that have not been shipped. I have used an left inner join on the part number. There are some items that have orders against them but these are shipped so I...
  4. angel00079

    Record Selection

    Sorry, the version would help wouldn't it. It is X1. Reporting over JD Edwards. There is about 10000 records in the price file. I thought about using a subreport but would that give me three records (qty 15, 20 and 25) if the data selection criteria was the sales qty is greater then price qty?
  5. angel00079

    Record Selection

    I want to create a sales report to show how much a customer would pay. There is the sales file and the price file. Each item will have several records in the price file depending on the qty. If there is a sales order for 16 screws I want the report to pick up the price for 15. If I only want...
  6. angel00079

    Grouping a Crystal report

    Down the side is GH1, GH2 etc. I have about twenty users and ten different codes. I want to be able to click on a user and be able to get the codes for this user, then click on the code and get the detail. At the moment the there is a header for every code. I realise that the way I am trying...
  7. angel00079

    Grouping a Crystal report

    Thanks for that. It is still not working. I think it is because I have the header in the wrong section but I have tried putting it in different sections with limited success.
  8. angel00079

    Grouping a Crystal report

    Being very new to Crystal reports I am having difficulty with grouping and showing headings. If I just group on just one field that's fine, I can just supress it. I however want to have a report grouped by user, then users codes. The drill down works fine for the users but repeats the header...

Part and Inventory Search

Back
Top