Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > AFS/DDC/OLE: Function servers

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
6%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 65

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th January 2019, 09:44
tmannais's Avatar
tmannais tmannais is offline
Senior Member
 
Join Date: Jul 2017
Posts: 175
tmannais is on a distinguished road
Baan: LN 10.5 - DB: MySQL - OS: Windows
[AFS] How to print SSRS out to PDF file using AFS?

I have a device SSRS (SQL Server Reporting Services) that will print out the SSRS report. The device is setup correctly and is working fine in the system. It can be downloaded into several file types such as word, excel, and pdf manually.
Now I want to use AFS to get the SSRS report in the PDF format.
How can I do that?
I tried using

Code:
stpapi.set.report(session.code, report.code, "SSRS", error.msg)
to print the report in SSRS device, but cannot save it into PDF.
Reply With Quote
  #2  
Old 10th January 2019, 10:25
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 827
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
You can create a device in LN that stores a PDF in a location on the LN server. See the "Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting
Services Administration Guide" for that (the -path argument). Use that device in instead of "SSRS". If you want to display the PDF directly to the user, you can try to set spool.fileout to a temporary file as described in the AFS guide and use '-path $file' in your device definition. Then you know exactly the file that will be created and that file can be displayed with client.show.file().
Reply With Quote
Sponsored Links
  #3  
Old 11th January 2019, 02:30
tmannais's Avatar
tmannais tmannais is offline
Senior Member
 
Join Date: Jul 2017
Posts: 175
tmannais is on a distinguished road
Baan: LN 10.5 - DB: MySQL - OS: Windows
It works as expected now.
Thank you very much, JaapJD.
Case Closed.

Last edited by tmannais : 11th January 2019 at 04:11.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to rename pdf file generated through microsoft reporting for FP8 ERP LN nehagarg Tools Development 7 15th April 2015 15:45
Return value -2 on seq.open mmtmalone Tools Development 2 8th January 2014 22:03
Print Report with AFS in a job gentercz AFS/DDC/OLE: Function servers 1 9th August 2006 16:54
AFS - Print Order Documents BurghMan AFS/DDC/OLE: Function servers 5 29th October 2004 21:07
Printing to PDF file mbezdek Tools Development 1 3rd April 2002 01:41


All times are GMT +2. The time now is 23:42.


©2001-2018 - Baanboard.com - Baanforums.com