Ok well tried…
you need to add this group in that form
check my xpo.
I,m fix these error my report is also work fine …
but my custom lookup for customer account field is not filter based on customer group… i will send you my both lookup method
// for custgroup look up
public void lookupCust(FormStringControl _control)
{
Query query = new Query();
QueryBuildDataSource qbds_CustTable;
SysTableLookup sysTablelookup;
sysTablelookup = SysTableLookup::newParameters(tableNum(CustTable),_control);
qbds_CustTable = query.addDataSource(tableNum(CustTable));
sysTablelookup.addLookupfield(fieldNum(CustTable,CustGroup));
sysTablelookup.parmQuery(query);
sysTablelookup.performFormLookup();
}
// for custaccount lookup method based on above custgroup value and my custgroup filed value is pass by these ((CustomerGroup.valueStr()))
public void lookupCust(FormStringControl _control)
{
Query query = new Query();
QueryBuildDataSource qbds_CustTable;
QueryBuildRange qbr;
SysTableLookup sysTablelookup;
if (_control != null)
{
sysTablelookup = SysTableLookup::newParameters(tableNum(CustTable),_control);
qbds_CustTable = query.addDataSource(tableNum(CustTable));
sysTablelookup.addLookupfield(fieldNum(CustTable,AccountNum));
qbr = qbds_CustTable.addRange(fieldNum(CustTable, CustGroup));
qbr.value(CustomerGroup.valueStr());
sysTablelookup.parmQuery(query);
sysTablelookup.performFormLookup();
}
if (_control == null)
{
sysTablelookup = SysTableLookup::newParameters(tableNum(CustTable),_control);
qbds_CustTable = query.addDataSource(tableNum(CustTable));
sysTablelookup.addLookupfield(fieldNum(CustTable,AccountNum));
sysTablelookup.parmQuery(query);
sysTablelookup.performFormLookup();
}
}
First you have to hardcore the cust group value in range query and check. If it is working fine then go to
qbr.value(“10”);
this Technics
qbr.value(QueryValue(CustomerGroup.valueStr()));
qbr.value(SysQuery::value(CustomerGroup.valueStr()));
try this.
thanks my report is completed implemented according to me and its work properly
but the actually concept for lookup is different , look up value is shown by edit method and in my edit method we use custAccount and custGroupId its automatically show lookup (by default nature of custaccount and custgroupid EDT) ,so my lookup method not call.
Then first of all we remove both EDT in edit method and Generally take edit of String20 which does not show lookup value after then we implement my look up code which are shown below…
// for custgroup
public void lookup()
{
Query query = new Query();
QueryBuildDataSource qbds_CustGroup;
SysTableLookup sysTablelookup;
super();
sysTablelookup = SysTableLookup::newParameters(tableNum(CustGroup),this);
qbds_CustGroup = query.addDataSource(tableNum(CustGroup));
sysTablelookup.addLookupfield(fieldNum(CustGroup,CustGroup));
sysTablelookup.parmQuery(query);
sysTablelookup.performFormLookup();
}
/// for custAccount.
public void lookup()
{
Query query = new Query();
QueryBuildDataSource qbds_CustTable;
QueryBuildRange qbr;
SysTableLookup sysTablelookup;
super();
if (CustomerGroup.valueStr() != “”)
{
sysTablelookup = SysTableLookup::newParameters(tableNum(CustTable),this);
qbds_CustTable = query.addDataSource(tableNum(CustTable));
sysTablelookup.addLookupfield(fieldNum(CustTable,AccountNum));
qbr = qbds_CustTable.addRange(fieldNum(CustTable, CustGroup));
qbr.value(CustomerGroup.valueStr());
sysTablelookup.parmQuery(query);
sysTablelookup.performFormLookup();
}
if (CustomerGroup.valueStr() == “”)
{
sysTablelookup = SysTableLookup::newParameters(tableNum(CustTable),this);
qbds_CustTable = query.addDataSource(tableNum(CustTable));
sysTablelookup.addLookupfield(fieldNum(CustTable,AccountNum));
sysTablelookup.parmQuery(query);
sysTablelookup.performFormLookup();
}
}
Finally Ganesh Thank you so much for your appreciate help …
Hello Ganesh .
I am facing a issues while using the customized lockup by run base that is when i open the report that give the error of "dorun "method … But as i have not used this method neither in form nor in report.
Thanks
Pushpendra
Hi pushpendra,
Have you done that report as i told in above steps?
If you done that report as above steps…
I think that is run time issue. So, check you properly and re -design once again. Because i am not facing that problem.
Regards,
Ganesh