Custom Tab Infomaker Question

Dean,

There may be other ways to do this that are more direct but the way I did it was to create a separate infomaker object for your drop down with a simple select statement as a data source, then referenced that object in the main report.

Dale

Dale,

I have a separate infomaker object set up, the issue I am having is that I want a where clause in that select statement to limit the drop down by the customer_no.  I have set a retrieval arguement for customer_no, but when I pull the custom tab it is prompting me for the customer_no as opposed to pulling it from the customer that the custom tab is in.

Does what I am trying to do make sense?

Dean

Dale,

I have a separate infomaker object set up, the issue I am having is that I want a where clause in that select statement to limit the drop down by the customer_no.  I have set a retrieval arguement for customer_no, but when I pull the custom tab it is prompting me for the customer_no as opposed to pulling it from the customer that the custom tab is in.

Does what I am trying to do make sense?

Dean

B-Dean,

You have to pass the customer_no argument from the primary custom screen to the dropdown datawindow.  In the properties of the dddw on the main custom screen there should be an arguments list where you can click the ... button.  That opens a new window (the computed fields window) find customer_no in the list on the bottom right, select and save.  That should pass the customer_no to the dddw.

Anna

awessely@tessituranetwork.com

Dean,

Its been a long time since I created this custom tab so I'm not sure I can be of assistance.  My main report is a simple select from a custom table:

SELECT a.id_key,
   a.customer_no,
   a.last_update_dt,
   a.last_update_by,
   a.access,
   a.affinity,
   a.gift_high,
   a.gift_middle,
   a.gift_low,
   a.wealth,
   a.ask_start_dt,
   a.ask_end_dt,
   a.interest,
   a.leadership,
   a.involv_desc,
   a.involv_dates,
   a.fdn_corp,
   a.sum_acc_aff,
   a.prelim_capacity,
   a.capacity,
   a.ann_gift_amt,
   a.ann_gift_dt

FROM LT_CUSTOM_SPEC_SOLICIT a

where customer_no = :a_customer_no

My dddw report is also a simple select that pulls ID and DESCRIPTION from a custom system table:

SELECT  L.id, L.description, L.inactive    
        FROM ltr_cust_solic_leadership L

ltr_cust_solic_leadership.id = leadership in LT_CUSTOM_SPEC_SOLICIT

I don't know if this helps or not.  I haven't done much work with custom tabs lately.  Sorry!

Dale

Anna,

I cannot find the arguements list in the dddw properties.  What properties tab would it be on?  I am trying to figure out how to dramatically change my look for Florida ;). 

Thanks
Dean