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...
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...
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...
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?
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.