Hi,
We have a strange problem when we try to create an main/sub report structure.
We copied the standard report session tisfc0408m000 to create a specific session with only 2 reports linked and less data on it (1 header on the first, and 1 detail on the second).
The idea is to have 1 product order (main) and x operations (sub).
The problem is that the generation of the XML files gives only 1 xml (and so, no main_xml file) if we delete some standard inputfields on the first report! Note that these inputfield are not on our layouts because we don't need them...
I tried to let them and the result is ok! (we have the main xml and the sub).
Do you have an Idea? what is the link between the presence of some input fields and the generation of the good structure XML based on a main and a sub file???
Thank you for your help :rolleyes:

There is no link between input fields and the creation of main and sub file. The main file will be created if there are multiple production orders in the range for which a document must be printed or there is only one production order, but with multiple documents. So if you print only one document for one production order, the main file is not created. You have to build your sub report in such a way that is can also be rendered stand alone.

:D
Thank you.
With a larger selection it works!

There's another problem:
In the same exemple:
We want to print a report based on project data (tppdm600) as main part of MS-report. and other data from specific tables linked to the project.
We designed a editing session with 3 reports like this:
Report 1 => based on tppdm600 data
Report 2 => based on specific table 1 linked to tppdm600
Report 3 => based on specific table 2 linked to tppdm600
When we print in D66 or printer it's ok: We have each project linked to his specific datas.
But when we export in XML format, the report 2 data for the 1rst record is missing! and so in the XML (main.xml file) the structure is like this:
Data 1
Data 3 (Data 2 is missing 1st time!)
Data 1
Data 2 (Ok)
Data 3
...
and so on...

We checked our script it seems to be ok (like tisfc0408 one).
The input fields in our reports too.
Note that, the second XML file generated is 100% ok.
Thank you for your help again :)

Can you also attach the second XML file, so the one without "_main"? If there is confidential data in it, I don't mind if you remove those elements.

Can you also attach the second XML file, so the one without "_main"? If there is confidential data in it, I don't mind if you remove those elements.
Here the 2nd file.
Thx

Just to verify... If your (pseudo)code is:

spool.open
for all selected projects
brp.open(report1)
... send data
brp.close
brp.open(report2)
... send data
brp.close
brp.open(report3)
... send data
brp.close
endfor
spool.close

it should work. If not... I would recommend to log an incident in InforXtreme.

Thx,
Our code is exactly the same as your example.

To answer our last request we have found a work around for the problem of XML_main that was not
well design by adding inputs fields on the first report. Now it is ok.
We have now a new problem :
I have designed a main report with sub reports (similary to session tisfc0408m000) but at execution only
the first report is displayed the others subreports are not shown). I join the Ms report project ans the XML files
to see if there is a design problem. No error message is displayed at design nether at execution.

Other question : is there an option or a possibilty with the SSRS device in baan to force the writing of the output
in an .xls file without openning Excel automatically. with the -EXCEL option

Thanks in advance for any help

Looking at the report design I see this (I have no BIDS available on the computer I'm on now):

<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="Détails" />
<TablixMembers>
<TablixMember />
<TablixMember>
<Visibility>
<Hidden>=(Fields!report.Value &lt;&gt; "tpafr141001000")</Hidden>
</Visibility>
</TablixMember>
<TablixMember>
<Visibility>
<Hidden>=(Fields!report.Value &lt;&gt; "tpafr141002000")</Hidden>
</Visibility>
</TablixMember>
<TablixMember>
<Visibility>
<Hidden>=(Fields!report.Value &lt;&gt; "tpafr141003000")</Hidden>
</Visibility>
</TablixMember>
</TablixMembers>
<Visibility>
<Hidden>=(Fields!report.Value &lt;&gt; "tpafr141001000")</Hidden>
</Visibility>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>

I assume the last visibility condition is on a level too high. So, the whole report part is only rendered for the first report.

For the 2nd question: Yes. You can create a device and specify in the argument "-server <your SSRS server> -format Excel -path "<a filename with possible holders to make it unique>". See the Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services Administration Guide (U9656E), downloadable from InforXtreme.

:D
Thank you for this precious help.
All is ok now!

Hi,
We have another problem when trying to create an xls file automaticaly (without screen display).
See in the attachment file...
The main goal is to generate multiple XLS files and then automatically activate a macro to group this files in 1 Excel file with multiple tabs. :confused:

For me a -format EXCEL and a -path <path> does work. You can get more tracing by setting SOAP_TRACE=1. This creates trace files in $BSE/log.

For me a -format EXCEL and a -path <path> does work. You can get more tracing by setting SOAP_TRACE=1. This creates trace files in $BSE/log.
Thank you.
We tryied to print tisfc0408m000 reports (standard). And we have the same problems. It seems not work in standard to...

For me a -format EXCEL and a -path <path> does work. You can get more tracing by setting SOAP_TRACE=1. This creates trace files in $BSE/log.
Hi,
We printed standard report tdsls1401m000 (Quotation printing) and for this kind of reports (simple report) it works (We specified a -path with a XLS file).
The same try with standard report tisfc0408m000 (Production order) doesn't work and gives the same message (cf. attached file in my previous message and the attached file in this message).
Do you think SSRS/Infor doesn't work if report is a main/sub report? Does Infor communicates about this problem?
Thank you,
:cool:

Seems to be a bug. I would recommend to ask the help of Infor support.

Hello All,

We also have the similar issue, our output is sent directly to SSRS Excel without any issues, but when I select SSRS_EXCEL device in JOB Management for a job that executes weekly once and the report output needs to be placed in a folder, now when I select my SSRS_EXCEL device it says "Device not allowed because this device does not support direct printing". So can someone help in getting some clues on how to add this device to job.

What did you specify in the Argument field of the device?