Joined: 31 May 2013
Location: United Kingdom
Online Status: Offline
Posts: 1
Topic: Selection Problem Posted: 04 Jul 2013 at 3:33am
Hi all I'm new to the forum and quite new to Crystal reports, I'm trying to build a bill of Materials report that allows the user to select by the parent item's category which then shows the child items for that parent.
I have tried to set up a parameter {?Category} and using the selection expert to set "{?Category}=OITM.U_Category" but this returns NULL.
What I want to be able to do is select the child items and the parent for all items where the parent item (ITT1.Father) is in the chosen {?category}. As it is I can happily choose a range of BOMs for parent items r a BOM for a single Parent item but not by category
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 09 Jul 2013 at 5:00am
one would think that you would just join/link tables to get the report.
if the child and the parent are different tables, it's easier conceptually to join them, and if they are in the same table, you would add the table into the report twice and link them (a self join in sql)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
