You’re offline. This is a read only version of the page.
562
Hi All,
I have to display the only duplicate value on SSRS report (customize report ).
In the below image Duplicate values is 10001, This Particular values I Want to show on SSRS report.
Please give share any code to solve this error
BR
Tony
*This post is locked for comments
Hi Tony,
you can do "Group by" for that Num column. and within the while statement you can check the duplication by checking the count of the record and insert. Now it will insert only the result having more than one line(which means duplicate).
For Example:
SalesLine _salesLine ;
TestTempTable tempTab;
while select count(RecId) from _salesLine group by ItemId where _salesLine .SalesId == "SO12345678"
{
if(_salesLine .RecId > 1)
{
tempTab.SalesId = _salesLine .SalesId;
tempTab.ItemId= _salesLine .ItemId;
tempTab.insert();
info(strFmt("%1 - %2",_salesLine .ItemId,_salesLine .RecId));
}
}
Hi Tony,
say table name is SSRStmpTable
SSRStmpTable SSRStmpTabletemp,SSRStmpTableloc;
while select SSRStmpTabletemp
where SSRStmpTabletemp.Num == SSRStmpTableloc.Num
&& SSRStmpTabletemp.RecID!= SSRStmpTableloc.RecID //recid will be always different
{
//insert record
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
