SSRS SQL 2019

Question

while running a ssrs report i am getting following error

An error occured during local report processing
error in the application
Object refrence not set an instance of object

how to find what is the offending object

this report contain code vba code (Two functions)

if the report is run from vs2019 application, it runs o.k., then why in development environment the preview is giving above error ?

Answer 1

Hi @Sushil Agarwal ,

Thank you for your feedback.

Currently the Microsoft Reporting Services Projects is not supported in Visual Studio 2022, which may lead to the situation.

For any suggestions about Microsoft Reporting Services Projects, please send feedback in the Q&A.

Sincerely,
Anna

• If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
  Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

It runs in visual studio means from application, it's not running in preview under report development of that rdl file in vs2019 ide

Answer 3

it run in application means , when i load my project and that project have an option to display that report it runs o.k. and barcodes, q.r.code in that report are shown ,which are dependent in that report on an external library (.dll)

it does not run in visual studio ide means in vs ide we open rdl reports as a report project and then from tht project we open the .rdl report to modify/decvelop it. when you open report in vs2019 id that report has option as design and preview. reports which depend on eternal library now after installing vs 2022 is unable to find the q.r.code/barcode (.dll) files which were earlier kept at path
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\SSRS
they are still there, rdl report is opened in vs2019, but post vs2022 install, i have started facing issue that in vs2019 report previed is not finding dll files and olny gibes error object not found, if i try to open that rdl in report designer app, it clearly show that it can not find barcode45.dll, gma.qrcode.dll but does not tell where to copy these dlls.
earlier on following locatons these dlls were used to be kept.
echo Barcode.dll File Copied Paths
C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin
C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\Microsoft\VisualStudio\v15.0\SSDT
C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin
C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PrivateAssemblies
C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\CommonExtensions\Microsoft\SSDTRS
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies
C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies
C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies
C:\Program Files (x86)\MSBuild\14.0\Bin

copy .dll in following folder only applicable for vs2017/vs2019 both
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\SSRS
BarcodeLib45.dll
Gma.QrCodeNet.Encoding.dll

vs2019 community
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\SSRS

for ssrs 2017 and above
https://learn.microsoft.com/en-us/sql/reporting-services/custom-assemblies/deploying-a-custom-assembly?view=sql-server-ver15
%ProgramFiles%\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin

for report builder put assemlies to
C:\Program Files (x86)\Microsoft Report Builder

but post vs2022 community edition we dont know where to copy these dlls, to know that this quesrion is asked here.

Answer 4

one thing i observed if my report name extention is .RDL ( in capital letters) in solution explorer it shows as red icon (i.e. of Microsoft reportviewer) and all other .rdl icons are diffrent , i dont know what to call them but their color is black

Weird observation is that i simply exluded report from project , changed the extention to lower case .rdl , re-included the report in project and now i could preview it and it could find all assemblies with out error ,

barcode and Q.R.code was displayed o.k.

additionaly i observed when the report extention is .RDL (capital) then show code (F7) in view is also disabled ,
can experts please explain the meaning of all these thing.