December 15, 2008 at 3:34 am
Hi
A report generated through SSRS is displaying duplication. The report contains tables and it is bound to a dataset related to a stored procedure(SP).
The duplication happens on certain periods, ie, after 2 weeks, 1 month, 1 week etc. This issue only happens to this particular report.
We checked the data retrieved through the SP with the same parameters and didn't find any duplication. But the report still showed duplication. There is no grouping in the tables, just fetching the data and displaying. Table variables are used in the SP.
Can any one guess about the issue or has any one undergone through similar problem?
December 15, 2008 at 8:44 am
Based on the limited information you have provided (no ddl or code), it is hard to answer this question. I would venture to say that you have something in the stored procedure that causes duplicate data to be returned. I know you say that you have tried just running the sp, but based on your information on when it occurs it sounds as if someof your data is duped based on a specific time.
If you provide more information someone, maybe me, may be able to provide a better answer.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply