Search results for query: *

OK, The details are as follows> TABLE 1 (TABLEx-FK, PK1, COL11, COL12) TABLE 2 (TABLE1-FK, PK2, COL21, COL22) RECORD SELECTION: TABLE1.TABLEX-FK = 'nnnnn' GROUP1 on : COL11 GROUP2 on : PK2 (placed @ResetStringSharedVar1 here, placed SUB REPORT 1 on this group header section) Details SECTION...

I tried it , but it does not seem to work

I have a subreport placed in a group header (Group 2) which calculates a shared variable value.Depending on the shared variable value, I am able to suppress the Details section(immediately after Group2). Group 2 Header section has no other details to be printed. I need to suppress printing of...

Hi Nuffsaid,IdoMillet and Ngolem, The suggestion by Ngolem (to use a subreport) is giving me the required result. Thanks a lot. This is the first time I have discussed topics on this forum/site. All your suggestions were helpful and an eye-opener. I look forward to viewing all your replies...

Your statment said "should be in the record selection formula for the outer join from Location to Orders", How can I have a record selection formula specific to a link? Is the record selection formala not effective for the entire report? If not, could you please tell me how to set...

I did try these options above... Perhaps I will be more clear.. CUSTOMER TABLE (CUST_ID, NAME) LOCATION TABLE(ID,LOCATION NAME, CUST_ID_FK) ORDERS TABLE (ID,ORDER_AMT,ORDER_DATE,LOC_ID_FK) ORDER_DATE can be null. I need to group like this.... For All customers in the DB, For ALL location for...

I have 3 tables (CUSTOMER,LOCATION,ORDERS). The links are from CUSTOMER to LOCATION (Equal join). LOCATION to ORDERS(Left Outer join). I need to group data in the order Group 1-CustomerID Group 2-Location Group 3-Order Now, ORDER table has a field called ORDER_DATE(nullable). I need to print...

I have 3 tables (CUSTOMER,LOCATION,ORDERS). The links are from CUSTOMER to LOCATION (Equal join). LOCATION to ORDERS(Left Outer join). I need to group data in the order Group 1-CustomerID Group 2-Location Group 3-Order Now, ORDER table has a field called ORDER_DATE(nullable). I need to print...