Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th April 2017, 12:52
krushna's Avatar
krushna krushna is offline
Member
 
Join Date: Feb 2015
Location: Coimbator
Posts: 31
krushna is on a distinguished road
Baan: infor LN 6.1 - DB: SQL - OS: windows 8
Unhappy Ssrs
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: Both

Hello,

Can any one tell me how to create a SSRS Report using XML Data source.
I have already searched for the materials m getting some parts but it is not working properly.
Like Grouping, Sorting is working but while m trying for subtotal it is disable and not allowing me to add the Amount column and row wise.

And then I tried with Expression "=Sum(int(Fields!Inv_Amnt_USD.Value))" but that also giving the same issue, it is not showing the result it giving ERROR.

I am following the Process from here Please check the link once. Please check the 1st process:-
1. locally embedded in the report definition file ( the SSRS rdl ),

"https://www.mssqltips.com/sqlservertip/3148/sql-server-reporting-services-xml-data-source-and-data-set/"

and find the attachment for my xml Coding that m using in my Report.


Thanks,
Please suggest
Attached Images
File Type: png Capture1.PNG (24.6 KB, 10 views)
Attached Files
File Type: txt XML.code.txt (31.5 KB, 7 views)
__________________
Regards,
krushna

Last edited by krushna : 12th April 2017 at 14:25.
Reply With Quote
Sponsored Links
  #2  
Old 24th April 2017, 08:52
krushna's Avatar
krushna krushna is offline
Member
 
Join Date: Feb 2015
Location: Coimbator
Posts: 31
krushna is on a distinguished road
Baan: infor LN 6.1 - DB: SQL - OS: windows 8
I got this reply from MSDN Support.

Hi Kush93,

When we use aggregation function in SSRS with XML type DataSource, it is necessary to convert the data into relevant datatype.

Because by default, the rdl file assumes the binding xml data as string. That’s the reason why it shows error when you do the subtotal. So we need to use the expression:

=SUM(CDEC(Fields!Inv_Amnt_USD.Value))

The function CDEC() will convert the xml binding data to decimal type. Then you should be able to get the results you want.

Hope this helps.

Best Regards,
Henry
__________________
Regards,
krushna
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
Report Fields in LN are not displaying in SSRS report. nitin.rajput Third Party Products 0 25th September 2015 14:31
Microsoft SQL Server Reporting Services (SSRS) report design camilla Tools Development 5 3rd February 2015 11:14
SSRS Page Wise Data Sapna20 Tools Development 11 30th November 2013 07:54
SSRS Formatting ravin_singh Tools Development 5 23rd July 2013 18:49
Create SSRS Report eric.dizon Tools Development 2 19th July 2012 23:13


All times are GMT +2. The time now is 03:32.


©2001-2017 - Baanboard.com - Baanforums.com