Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
Would you like to see a separate forum on Baanboard for the ION product?
No
14%
Yes
86%
Total votes: 80

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st August 2012, 00:35
camilla camilla is offline
Junior Member
 
Join Date: Jul 2004
Posts: 11
camilla is on a distinguished road
Baan: LN FP7 - DB: Microsoft SQL Server - OS: Windows
Microsoft SQL Server Reporting Services (SSRS) report design
Baan: ERP LN 6.1 FP7
C/S: Both

Hi everyone,
i have a problem with Microsoft SQL Server Reporting Services (SSRS) report design.
I did all the steps to create a new project in SQL Server Business Intelligence Development Studio. I checked the report with "preview" and everithing is ok.
Then i used the LN configurator under tools to prepare the report to be deployed in LN. No errors found.
I modified the Solution Explorer / Properties, as shown in document U9657
I copied the file under:$BSE/application/tf<vrc>/btfgld
Then i went in LN to see if the rport works. But the message is that thre is no report on report server. I didn't know how to set the field "SSRS design present" in "Maintain reports" session.
How can i run a report using SSRS? How can i "import" the report in LN ( i tried also to import it using ttrpi1200m000 even if i know that it's not necessary).
Thanks in advance for your help
best regards
Camilla
Reply With Quote
  #2  
Old 21st August 2012, 08:48
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 473
JaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Quote:
I copied the file under:$BSE/application/tf<vrc>/btfgld
This is something you should not do manually, but leave it to session ttrpi1200m100 (Import SSRS Designs). Then also the flag "SSRS design present" is set in "Reports".
Use session ttrpi1200m000 (Export SSRS Designs) to send the designs to your report server.

Summarized the steps are:
1. Develop the design in BIDS
2. Prepare for Deployment
3. Import with ttrpi1200m100 from client project folder
4. Export with ttrpi1200m000 to report server
5. Print the report to the MS Reporting Services device which has your report server as the -server argument.

You can do an alternative route for step 3 and 4. Actually you don't need to have the report designs in the LN dictionary. This is only needed if you want to distribute the designs to other environments by means of a patch or PMC solutions. You can also deploy the report designs from BIDS directly to the report server. In the project properties in BIDS you need to define your report server and the target folder (the same folder you defined in ttrpi1500m000, but the placeholders like $pacc must of course be substituted by the real values). Then you can deploy from BIDS. After that you will be able to print the report from LN. Note that it may be necessary to restart the bshell in this case, because the result of the check whether a report exists on the report server is cached within the bshell.
Reply With Quote
  #3  
Old 21st August 2012, 08:53
camilla camilla is offline
Junior Member
 
Join Date: Jul 2004
Posts: 11
camilla is on a distinguished road
Baan: LN FP7 - DB: Microsoft SQL Server - OS: Windows
Solved

Hello to everyone,
i solved the problem!
I imported the report from the project itself, selecting "client" in the session:
ttrpi1200m100.
After the import i was able to print the report using the printer MS_SSRS1
Thanks in any case!
Reply With Quote
Sponsored Links
  #4  
Old 21st August 2012, 08:55
camilla camilla is offline
Junior Member
 
Join Date: Jul 2004
Posts: 11
camilla is on a distinguished road
Baan: LN FP7 - DB: Microsoft SQL Server - OS: Windows
Solved SSLS report

Thanks a lot,
you helped me very much!
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
Application Support Analyst - India, Chennai Jothilingam Jobs and Resumes 1 27th March 2010 15:18
calling a SQL Reporting Services Report tnzabo Tools Development 3 29th August 2008 13:55
Calling Baan DLL in SQL Reporting Services Rita Kotecha Third Party Products 0 10th May 2005 15:45
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11


All times are GMT +2. The time now is 08:06.


©2001-2013 - Baanboard.com - Baanforums.com