values not reflecting in SSRS report
Hi, Any one pls tel me in datamart i have run the query im getting one answer. The same query im using in the dataset. But in the report showing less amount than same query runned in the datamart. select sum(FCJCP.Amount) from DBO.FactCJClientPayment(nolock) AS FCJCP INNER JOIN DBO.DimCreditor(nolock) AS DC on DC.CreditorID = FCJCP.OrgID and DateKeyPaymentDate between (select min(datekey) from DBO.[DimDate] where CalendarYear = cast(Year(DATEADD(mm,-1,getdate())) as varchar) and MonthNumberOfYear= cast(month(DATEADD(mm,-1,getdate())) as varchar)) and ( select max(datekey) from DBO.[DimDate] where CalendarYear = cast(Year(DATEADD(mm,-1,getdate())) as varchar) and MonthNumberOfYear= cast(month(DATEADD(mm,-1,getdate())) as varchar) ) and DC.creditorname in (@DimCreditorCreditorName) I have checked no filters used in the report. Why it is conflict between dataset query result and datamart query result. Pls help me. Thanks, abdul2010
October 22nd, 2010 10:22am

Do you still get differing results if you remove the (nolock) hints? Also have you tried it using hard-coded dates rather than using parameters? Sethhttp://lqqsql.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 4:21pm

Hi abdul2010, I get your meaning completely after reading the information. However, I could not get the datasource and dateset, so I couldn’t reproduce this issue, I could only give some analysis methods to this issue. Here I would recommend you: 1. Make sure the datasource in both side are same. 2. Have a check to see whether the report control has some groups. If there is row group or column group, it will not display the records as the same as records in the database. 3. Make sure you pass the same parameter values to the query in both sides. 4. Have a check to see whether the checkbox of Do not cache temporary copies of this report in the report manager page is selected. Steps are: 1) Click the report in the report manager page. 2) Click Properties tab -> Execution-> select the checkbox of Do not cache temporary copies of this report. If the issue still exists after trying these steps, please give the reply. If you have any ideas, please also give some update. Have a wonderful day J Challen Fu
October 27th, 2010 4:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics