Hi,

I have a report which contains around 30 fields and hence, I have used the excel output to do the job using seq* functions and it doesnt use any rprt_send so no Baan report is generated. Now, I want to format the layout of this report in SSRS, but as far as I know, the SSRS works only with the report layouts created in Baan. My question is, how can I edit this kind of report using SSRS and connect it to my print session?

Following steps are needed:
1. Make the fields you currently write to the sequential file external in your program script.
1. Create a 'classic' report with the fields you want as report input fields. Make one detail layout with just one of the fields.
2. If you want the LN labels available in the SSRS report, add those labels also in the detail layout.
3. In the script: ensure the variables are external and change the seq functions to corresponding rprt functions.
4. Print the report to the 'designer' device as described in the developers guide.
5. Design the report in BIDS or SSDT
6. In LN make a device with the -format option to render directly to Excel.

Design the report in BIDS or SSDT

Can't I design in SSRS?

SSRS has 2 design tools:
- BIDS (VS 2009 based) or SSDT (VS 2010 based)
- Report Builder

With Report Builder you cannot design the reports for LN, because Report Builder does not support custom data extensions. The LN plug-in for SSRS is built as a custom data extension.

See also the prerequisites in "Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services Development Guide" (U9657E).

Oh, BIDS in Visual Studion. I got it. Thanks. I will try it. :)

Hi Jaap,

It worked. Thanks :)