ysovva
20th November 2011, 11:02
Hello,

We started to explore the MS Reporting and first problem we cannot solve is importing deployed report by ttrpi1200m100. Does not meter what I am trying to do, I am getting the message “zero imported, zero skipped and zero failed reports”.
What I am doing wrong?

JaapJD
21st November 2011, 08:56
To succeed with the import you need to have the following in place (based on your screenshot):
1. The 'classic' report tcmcs043911000 should be present in VRC B61O_a_dvl or in a lower one.
2. In your project you need a report design with the name tcmcs043911000.rdl.

ysovva
21st November 2011, 10:41
Hi Jaap,
Renaming the rdl file is helped to make the import. Thanks a lot.
Now during the printing I am getting the message that report is not present on the report server. From attached images you can see that the report indeed present on the report server. The U9656A US and U9657A US documents are not helping with this problem. What I did wrong?
Regards

JaapJD
21st November 2011, 10:52
Restarting bshell may help. Bshell is caching the information about the presence of the reports on the SSRS server. Instead of restarting bshell you can also kill the ttrpissrssrv process before printing again.

ysovva
21st November 2011, 10:58
Thank you, Jaap. I got the report
Regards
Yurry

ysovva
6th December 2011, 09:55
Hello,
I have another question about MS reporting.
Creating a main report with subreports: I'm using the same example that was used in Document code: U9657A US (Print Production Order Documents). According to this document I created 3 subreports and it worked fine with their view. The problem is the main report. The document says:
"Add these components to the report: • Header • Footer • Tablix" - when I'm trying to create tablix it is asking to define Dataset. But there is no dataset for the main report. When I'm pressing the "Cancel" button the new emty table is created and I continue with adding subreports to any first cell in every row. Totaly I have 3 subreports. At the end I'm getting the following error in the view tab:
"An error occured during local report processing.
The definition of the report '/tisfc040801000_main' is invalid.
The tablix "Tablix1" in the report body but the report has no dataset. Data regions are not allowed in reports without datasets."
Please advise.

JaapJD
6th December 2011, 12:16
If you print the order documents to a designer device you will get also a ier_<user>_tisfc040801000_main.xml. The query in the report should be tisfc040801000_main. In that case you will get a small dataset with a few fields that is a kind of TOC for the complete report.
But if you install solution 1055781 you would get the standard production order reports and you can modify those if you want, rather than starting from scratch.

ysovva
7th December 2011, 10:25
I got the ier_<user>_tisfc040801000_main.xml and trying to create the main report. I did not understand how to define the query for the main report.

JaapJD
7th December 2011, 11:39
The query must be "tisfc040801000_main".
Note that your attachement is not uploaded correctly.

ysovva
7th December 2011, 15:11
Thank you, Jaap. I got the report.
Yurry

ysovva
7th December 2011, 17:34
Now I am trying to add images to the report. I successfully added image for company logo, but can not add the image from additional files. Can you suggest some?

JaapJD
7th December 2011, 18:42
There is a solution for the plugin regarding additional file images. See http://www.infor365.com/espublic/Search/1042657.asp and http://www.infor365.com/espublic/Search/1051476.asp.

ysovva
8th December 2011, 09:08
There is a solution for the plugin regarding additional file images. See http://www.infor365.com/espublic/Search/1042657.asp and http://www.infor365.com/espublic/Search/1051476.asp.

The latest solution (1051476) is downloaded today and installed on client where I am trying to create the reports. No changes. The additional file image still appears as unfound image.

JaapJD
8th December 2011, 09:15
Two things to check:
- Did you restart BIDS after installing latest plugin?
- Are you sure you login to the correct package combination?

ysovva
8th December 2011, 10:21
If my current Package combination is: b61aodvl and the additional file is appearing as in previous attachment (Attached Thumbnails (http://www.baanboard.com/baanboard/attachment.php?attachmentid=5208&d=1323275592); VRC=B61O_a_dvl) what and where must be defined in BIDS?

JaapJD
8th December 2011, 10:30
If the correct package combination is in your user data on the LN side, it should work. If your user data contains another package combination (and you don't want to change that), you can set the PACKAGE_COMB in the command parameter of the Connection String.
You can also activate some logging to see what is happening. In C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies (or similar) you can find log4net.config. If you set the level to Info, you will find the logging in the ..\Logfiles directory.

JaapJD
8th December 2011, 10:31
If the correct package combination is in your user data on the LN side, it should work. If your user data contains another package combination (and you don't want to change that), you can set the PACKAGE_COMB in the command parameter of the Connection String.
You can also activate some logging to see what is happening. In C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies (or similar) you can find log4net.config. If you set the level to Info or Debug, you will find the logging in the ..\Logfiles directory.

ysovva
8th December 2011, 13:19
The logfile is attached to this message. I did not find any "getimage" (dll ttrpidllimage) call in this logfile. I hope you might be able to help.

anandpr1989
21st June 2012, 10:04
When I export the ssrs report design then following screen appears. Why report is not deployed on reporting server?

JaapJD
21st June 2012, 10:13
Probably there is no SSRS report design for report tibom141001000 present in the dictionary. You can check that in session ttadv3530m000. Is column SSRS checked for this report?
So, you can only export the designs that are already present. Infor delivered a number of SSRS report designs, see KB http://www.inforxtreme.com/espublic//EN/AnswerLinkDotNet/Solutions/ViewSolution.aspx?SolutionID=22947060 which report designs are available for SSRS.
You can also design your own SSRS report designs. See KB http://www.inforxtreme.com/espublic//EN/AnswerLinkDotNet/Solutions/ViewSolution.aspx?SolutionID=22944939 for the development guide.