I have the problem on filtering in SSRS report only in browser. But, it works fine in Business Intelligence. Actually when i filter the Item group, the Test group is automatically refreshed and filtered in Business Intelligence (Please refer the picture 1). But, After deployment in browser, when i filter the Item group, the Test group is not refreshed. Nothing happened (Please refer the picture 2). But if i set From date and to date with in 2 months period it filtered. It works fine in browser. I don't know what is happening here. please suggest me a good solution. Thanks.
Sample code for Item Group filter and Test Group filter given below
SELECT distinct ITEMGROUPID from ADK_MY_QUALITYORDERDIMGRPVIEW where ((PRODDATE>=@FromDate and PRODDATE<=@ToDate) or (@FromDate is null and @ToDate is null)) and DATAAREAID =(select LEFT(@Company,CHARINDEX('-',@Company)-1)) order by ITEMGROUPID select distinct TESTGROUPID from ADK_MY_QUALITYORDERDIMGRPVIEW where ((PRODDATE>=@FromDate and PRODDATE<=@ToDate) or (@FromDate is null and @ToDate is null)) and ITEMGROUPID in (@Itemgrp) and DATAAREAID =(select LEFT(@Company,CHARINDEX('-',@Company)-1)) order by TESTGROUPID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip