Microsoft Edge - SSRS URL does not refresh result render as PDF from Asp.net response.redirect

The problem started when I upgraded my operating system to Windows 10. It comes with Microsoft Edge. My Application was working perfect before. It was returning fresh result from SSRS as PDF. I was using following URL in response.redirect

http://servername/Reportserver?/SSRSRPT2RDL/Main&rs:Command=Render&rs:Format=PDF&year=2018&source=Menu

After upgrade, I have started receiving results from cache. I was wondering what happened suddenly. so I started looking at web page Headers - Status Code. It was 304 (Not Modified). Which means it was not refreshing data and returning results from Cache.

To solve the problem, I have added "rs:ClearSession=true" in the URL. This solved my issue.

http://servername/Reportserver?/SSRSRPT2RDL/Main&rs:Command=Render&rs:Format=PDF&rs:ClearSession=true&year=2018&source=Menu

Thanks

How can i convert LookupSet result, which is in array, into comma separated? SSRS

You can convert array to comma separated string by using Join() function.

=JOIN(LookupSet(Fields!ID.Value, Fields!ID.Value, Fields!Name.Value, "Sections"),",")

Syntax:

LookupSet(source_expression, destination_expression, result_expression, dataset)

How can i find all matching values from other dataset based on current dataset field ? (SSRS 2008 R2)

You can find all matching values of another dataset by using LookupSet() function.

Syntax:

LookupSet(source_expression, destination_expression, result_expression, dataset)

How can i find a value from other dataset based on current dataset field ? (SSRS 2008 R2)

You can find a value of another dataset by using Lookup() function.

Syntax:

Lookup(source_expression, destination_expression, result_expression, dataset)

How can i show created by user in the report? or current logged in user in SSRS?

You can get current logged in user in SSRS by User!UserID property. This property gives you the user name of the person who is running the report.

How to check the time it takes to run a report in SSRS? SQL Server 2012

You can check that from executionLog3 table, if you do not have a dependency on an older view, for example ExecutionLog.

You can use Execution Log to find out how many milliseconds of processing time has spent on each processing phase.

Use ReportServer
select * from ExecutionLog3

Adding custom code or external assembly to Local Reports .RDLC in Visual Studio.NET causes error

Today i was working on console application which is generating automatic notices using .rdlc file. I was adding barcode into each page of dynamic generated N number of pages. which i have decided to accomplish by referencing external assembly which has one function from where i can pass the parameter and it's give me barcode in terms of bytes. but while adding that assembly i got following error.

"Error while loading code module: ‘Neodynamic.SDK.Barcode, Version=4.0.2000.0, Culture=neutral, PublicKeyToken=c6b33c3093a0d4cd’. Details: Could not load file or assembly 'Neodynamic.SDK.Barcode, Version=4.0.2000.0, Culture=neutral, PublicKeyToken=c6b33c3093a0d4cd' or one of its dependencies. The system cannot find the file specified. "

There are lots of options to solve on internet like adding into "private assemblies" folder of visual studio program files, or add localreport.AddTrustedCodeModuleInCurrentAppDomain etc....

but nothing works. finally i got the solution and it's very simple.

To solve, just do following:

Step 1. Add your external assembly into bin directory of your application, in my case, i am using console application so i moved there.

Step 2. Right click on your "xyz.rdlc" file and click on properties and change "Build Action: None" and "Copy to Output Directory: Do not copy".

That's it.
You can run the application and it will generate report smoothly.
some of the screen shots which i would like to share, so you can see and understand it visually as well.

What is SSRS? (SQL Server Reporting Services)

SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization. Reporting Services includes programming features that enable you to extend and customize your reporting functionality.

Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.

With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. Reports can include rich data visualization, including charts, maps, and sparklines. You can publish reports, schedule report processing, or access reports on-demand. You can select from a variety of viewing formats, export reports to other applications such as Microsoft Excel, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. You can also create data alerts on reports published to a SharePoint site and receive email messages when report data changes.