473,414 Members | 1,563 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

SSRS report parameters are not wroking properly

55
I have a multi value Country parameter in SSRS which is populated by an Oracle dataset.There is also a province parameter which is populated based on the Country selected by the user.
These parameters are passed in turn to another dataset which the report is based on.
The problem is when the report is run,the first province and country are always in the report whether they were selected or not.
If I run the query in SQLPLUS with the parameter hardcoded in,the data is correct but in SSRS, the same query is inaccurate.
any help on this would be greatly appreciated...thanks

province dataset :
SELECT * FROM PROVINCE
WHERE PROVINCE.COUNTRYCODE IN (:PARAM_COUNTRY)
ORDER BY PROVINCE.PROVINCENAME

country dataset:
SELECT * FROM COUNTRY
ORDER BY COUNTRYNAME ASC

dataset 1:
SELECT
COUNT(DISTINCT SHSUBSCRIBERNR),
CUSTOMER_CLASS.DESCRIPTION,
ST.STATUSDESCRIPTION,
FP.DESCRIPTION,
P.PROVINCENUMBER ,
P.PROVINCENAME
FROM
SUHISTOR
INNER JOIN DEVICE_HISTORY dev_hist ON dev_hist.FK_SHSHNR=SHSHNR
INNER JOIN SUBSCRIB ON SUBSCRIB.CUCUSTNR=SUHISTOR.SHSUBSCRIBERNR
INNER JOIN SUSTATUS ST ON SUBSCRIB.CUSTATUS=ST.STATUS --GET STATUS
INNER JOIN v_products_per_customer V ON v.CUSTOMER_ID=SHSUBSCRIBERNR
INNER JOIN AGREEMENT AG ON AG.CUSTOMER_ID=SUBSCRIB.CUCUSTNR
INNER JOIN CUSTOMER_CLASS ON CUSTOMER_CLASS.ID=SUBSCRIB.FK_CLASS_ID
-- LEFT OUTER JOIN AGREEMENT_DETAIL AG_DET ON SUBSCRIB.CUCUSTNR=AG_DET.CUSTOMER_ID
INNER JOIN AGREEMENT_DETAIL AG_DET ON SUBSCRIB.CUCUSTNR=AG_DET.CUSTOMER_ID
INNER JOIN ADDRESS AD ON AD.ADDRCUSTNR= SUBSCRIB.CUCUSTNR
INNER JOIN PROVINCE P ON AD.ADDRPROVINCENUMBER=P.PROVINCENUMBER
INNER JOIN COUNTRY C ON C.COUNTRYCODE=AD.ADDRCOUNTRY
INNER JOIN FINANCE_OPTION FP ON FP.ID=AG_DET.FINANCE_OPTION_ID
WHERE
SHPRODUCTNR IN (26,34,41)
AND
dev_hist.STATUS_ID=30
AND
v.TECHNICAL_PRODUCT_ID=14
--AND SUBSCRIB.CUCUSTNR IS NOT NULL
--AND AG_DET.CUSTOMER_ID IS NOT NULL


AND
SUBSCRIB.CUSTATUS IN (:PARAM_STATUS)
AND
AG_DET.FINANCE_OPTION_ID IN (:PARAM_FINANCEOPTIONID)
AND
P.PROVINCENUMBER IN (:PARAM_PROVINCE)
--P.PROVINCENUMBER = ANY (SELECT PROVINCENUMBER FROM PROVINCE WHERE PROVINCENUMBER IN (:PARAM_PROVINCE))
AND
C.COUNTRYCODE IN (:PARAM_COUNTRY)
Mar 11 '09 #1
0 2249

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Chandrusekar | last post by:
Hi Everyone. My requirement is to create two Radio buttons in SSRS. The radio buttons need to be the parameters for the Stored Procedures pulling out the report. The Radio buttons will be for the...
4
by: Max2006 | last post by:
Hi, I am developing a web application on windows XP. A page within my application needs to access to SSRS running on the same machine. Once the web application tries to consume the SSRS web...
0
by: Wes Groleau | last post by:
Is there a reasonably simple way to dump an SSRS report into Excel format automatically at a scheduled time without using Report Manager/Report Server? Creating the report was easy, but we seem...
0
by: jobs | last post by:
Re: SSRS report viewer Execution ' ' cannot be found (rsExecutionNotFound) Reserved.ReportViewerWebControl.axd Every now and then, my users get this error while in the Reportviewer. Usually,...
1
by: bstevenson | last post by:
Hi I am trying to open up a report from ASP and export it to PDF.I need to create dynamic report names depending on the parameters I send in the URL.I have the following link that I create but it...
0
by: Aswanth | last post by:
I'm Working with Asp.Net with C#.. & I'm Generating Reports in SSRS-2005.. Till Now I'm Generating Reports in SSRS-2005 with Stored Procedure.. in Which I'm Generating Reports for One...
5
by: Aswanth | last post by:
I'm Using Asp.Net with C# & Working with SSRS 2005 for Generating Reports.. The Following Expression I'm using in Reports to Show the Percentage of Particular Items in REPORT.. ...
0
by: abidthayyil | last post by:
Hello, I was working on SSRS 2005 as part of SQL Server 2005 Express Edition with Advanced Services Sp1. I successfully developed a custom reporting application. It was working fine. Then I...
0
by: Mahain | last post by:
Hi all, i am working with SSRS 2005 i am using multivalue dropdownlist in my report if have three option in my dropdownlist box for ex "a","b","c" i have one another parameter(suppose...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.