March 11, 2018 at 10:15 am
I am Configure SQL Server 2014 Reporting server. and i Developed and Deploy Reports using visual Studio 2013 and access these reports by using asp.net mvc application and ReportViewerWebForm.aspx as a Report Viewer.
Problem is that when i call same report with different parameters at the same time. From Same Client or From Different Clients. It Shows the last Processed Report at all clients. Means same data shown at all clients
Please guide me Thanks
March 12, 2018 at 1:14 am
shoaibhameed1192 - Sunday, March 11, 2018 10:15 AMI am Configure SQL Server 2014 Reporting server. and i Developed and Deploy Reports using visual Studio 2013 and access these reports by using asp.net mvc application and ReportViewerWebForm.aspx as a Report Viewer.
Problem is that when i call same report with different parameters at the same time. From Same Client or From Different Clients. It Shows the last Processed Report at all clients. Means same data shown at all clients
Please guide me Thanks
Please check at the data source, ie, the report is fetching the data from which database / source and required tables. Whether the table got refreshed or incrementally loaded properly ?
March 12, 2018 at 1:43 am
subramaniam.chandrasekar - Monday, March 12, 2018 1:14 AMshoaibhameed1192 - Sunday, March 11, 2018 10:15 AMI am Configure SQL Server 2014 Reporting server. and i Developed and Deploy Reports using visual Studio 2013 and access these reports by using asp.net mvc application and ReportViewerWebForm.aspx as a Report Viewer.
Problem is that when i call same report with different parameters at the same time. From Same Client or From Different Clients. It Shows the last Processed Report at all clients. Means same data shown at all clients
Please guide me ThanksPlease check at the data source, ie, the report is fetching the data from which database / source and required tables. Whether the table got refreshed or incrementally loaded properly ?
i have check the data source. It Work Perfect when call report with some time difference or when one report display then call it with different parameters. Problem is that when call it with no time difference
March 13, 2018 at 1:42 am
shoaibhameed1192 - Monday, March 12, 2018 1:43 AMsubramaniam.chandrasekar - Monday, March 12, 2018 1:14 AMshoaibhameed1192 - Sunday, March 11, 2018 10:15 AMI am Configure SQL Server 2014 Reporting server. and i Developed and Deploy Reports using visual Studio 2013 and access these reports by using asp.net mvc application and ReportViewerWebForm.aspx as a Report Viewer.
Problem is that when i call same report with different parameters at the same time. From Same Client or From Different Clients. It Shows the last Processed Report at all clients. Means same data shown at all clients
Please guide me ThanksPlease check at the data source, ie, the report is fetching the data from which database / source and required tables. Whether the table got refreshed or incrementally loaded properly ?
i have check the data source. It Work Perfect when call report with some time difference or when one report display then call it with different parameters. Problem is that when call it with no time difference
Then check for the NULL time differences in your db table. Please check whether NULL processing was properly handled!
March 14, 2018 at 12:10 am
Thom A - Tuesday, March 13, 2018 6:47 AMSounds like you have caching or snapshots enabled. What is the settings on the Snapshot Options, Report History and Cache Refresh pages on the report?
i also check the Snapshot Options, Report History and Cache Refresh Options. It has the default setting. i don't configure these options.
March 14, 2018 at 12:16 am
Again i explain the problem. i Deployed the report for single voucher. when i pass the primary key to report it display the complete voucher against that key.
Problem is that when that report call from different users with different parameter at the same time. for example one user pass '1' as a parameter (ID) and other will pass '2' with some seconds gap. Report display to both users with parameter '2'. and Result of parameter '1' not shown.
March 14, 2018 at 12:44 am
shoaibhameed1192 - Wednesday, March 14, 2018 12:16 AMAgain i explain the problem. i Deployed the report for single voucher. when i pass the primary key to report it display the complete voucher against that key.
Problem is that when that report call from different users with different parameter at the same time. for example one user pass '1' as a parameter (ID) and other will pass '2' with some seconds gap. Report display to both users with parameter '2'. and Result of parameter '1' not shown.
that means the report shows only latest selection of values from the parameter. We need to check the report datasets and how it has been configured.
Also please type clearly, very hard to understand.
March 14, 2018 at 5:45 am
subramaniam.chandrasekar - Wednesday, March 14, 2018 12:44 AMshoaibhameed1192 - Wednesday, March 14, 2018 12:16 AMAgain i explain the problem. i Deployed the report for single voucher. when i pass the primary key to report it display the complete voucher against that key.
Problem is that when that report call from different users with different parameter at the same time. for example one user pass '1' as a parameter (ID) and other will pass '2' with some seconds gap. Report display to both users with parameter '2'. and Result of parameter '1' not shown.that means the report shows only latest selection of values from the parameter. We need to check the report datasets and how it has been configured.
Also please type clearly, very hard to understand.
Yes the report shows only latest selection of values from the parameter.
March 14, 2018 at 6:09 am
shoaibhameed1192 - Wednesday, March 14, 2018 5:45 AMsubramaniam.chandrasekar - Wednesday, March 14, 2018 12:44 AMshoaibhameed1192 - Wednesday, March 14, 2018 12:16 AMAgain i explain the problem. i Deployed the report for single voucher. when i pass the primary key to report it display the complete voucher against that key.
Problem is that when that report call from different users with different parameter at the same time. for example one user pass '1' as a parameter (ID) and other will pass '2' with some seconds gap. Report display to both users with parameter '2'. and Result of parameter '1' not shown.that means the report shows only latest selection of values from the parameter. We need to check the report datasets and how it has been configured.
Also please type clearly, very hard to understand.Yes the report shows only latest selection of values from the parameter.
Kindly check how the parameter getting populated and try to test the report datasets separately.
March 14, 2018 at 6:24 am
subramaniam.chandrasekar - Wednesday, March 14, 2018 6:09 AMshoaibhameed1192 - Wednesday, March 14, 2018 5:45 AMsubramaniam.chandrasekar - Wednesday, March 14, 2018 12:44 AMshoaibhameed1192 - Wednesday, March 14, 2018 12:16 AMAgain i explain the problem. i Deployed the report for single voucher. when i pass the primary key to report it display the complete voucher against that key.
Problem is that when that report call from different users with different parameter at the same time. for example one user pass '1' as a parameter (ID) and other will pass '2' with some seconds gap. Report display to both users with parameter '2'. and Result of parameter '1' not shown.that means the report shows only latest selection of values from the parameter. We need to check the report datasets and how it has been configured.
Also please type clearly, very hard to understand.Yes the report shows only latest selection of values from the parameter.
Kindly check how the parameter getting populated and try to test the report datasets separately.
March 14, 2018 at 7:07 am
shoaibhameed1192 - Wednesday, March 14, 2018 6:24 AMsubramaniam.chandrasekar - Wednesday, March 14, 2018 6:09 AMshoaibhameed1192 - Wednesday, March 14, 2018 5:45 AMsubramaniam.chandrasekar - Wednesday, March 14, 2018 12:44 AMshoaibhameed1192 - Wednesday, March 14, 2018 12:16 AMAgain i explain the problem. i Deployed the report for single voucher. when i pass the primary key to report it display the complete voucher against that key.
Problem is that when that report call from different users with different parameter at the same time. for example one user pass '1' as a parameter (ID) and other will pass '2' with some seconds gap. Report display to both users with parameter '2'. and Result of parameter '1' not shown.that means the report shows only latest selection of values from the parameter. We need to check the report datasets and how it has been configured.
Also please type clearly, very hard to understand.Yes the report shows only latest selection of values from the parameter.
Kindly check how the parameter getting populated and try to test the report datasets separately.
Unfortunately I'm not sitting near a system right now, but I shall try to take a look at tonight. In between if you could progress and find something on your own, that would be great !
March 16, 2018 at 2:17 pm
shoaibhameed1192 - Wednesday, March 14, 2018 6:24 AMsubramaniam.chandrasekar - Wednesday, March 14, 2018 6:09 AMshoaibhameed1192 - Wednesday, March 14, 2018 5:45 AMYes the report shows only latest selection of values from the parameter.Kindly check how the parameter getting populated and try to test the report datasets separately.
It's likely related to caching as Thom already mentioned. And the report viewer can have issues with caching as well. In your app, try using ReportViewer.Reset Method () first to clear anything out.
Sue
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply