Problems creating reports in Crystal

[beerbsh316]

I am having a very difficult time creating which to me seem like simple reports with crystal. I am using the version that comes with VS 2005 PRO. Just as an example I am trying to make a report that will display all of the different machines that are in the shop I am working on and what is available be done on each machine. My DB is set up such that the item to be made has an ID which I will call Item_ID. This is a foreign key in my operations table. I will call the key for the operations table Op_ID. Then I have a machines table with an ID field called Machine_ID. Machine_ID is also a foreign key in the operations table. I want my report to list all of the machines and under each machine list the Item_ID and then a calculation of hours remaining to be worked on for that Item on that machine. The formula for the hours to display assuming the Machine_ID is 1 and Item_ID is 2 should be the sum of (Operation.Total_Time-(Operation.EstimatedTime * Operation.Quantity * Item.Quantity)) where Item_ID=2 and Machine_ID is 1 and Operation.Total_Time<(Operation.EstimatedTime * Operation.Quantity * Item.Quantity). To me while it takes a lot to write out it is not a very complex report which I should be able to make. I dont know if maybe options I need to make reports like this are only available if I buy a full version of crystal and not use what is included in visual studio. If someone could give me some pointers and let me know if what I am trying to do is possible or if I need to invest in a full version of crystal reports.

 

[beerbsh316]

Please disregard this thread and reply to http://www.vbdotnetforums.com/showthread.php?t=17395

When posting I received a message to log in and did not see any confirmation that my post went through so I posted again.

 

[beerbsh316]

Nevermind the other one has been deleted now.

 

[DavidT_macktool]

Did you get this figured out? You will need to do some grouping and sorting of the records but you should be able to do the calculations in the appropriate group footer section. Let me know if you require more direction.