We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Datetime problems in report designer

Thread ID:

Created:

Updated:

Platform:

Replies:

141330 Dec 6,2018 09:50 AM UTC Dec 11,2018 10:44 AM UTC WPF 3
loading
Tags: ReportDesigner
Unknown
Asked On December 6, 2018 09:50 AM UTC

Hi , how are you ? , today I have two question if you could help me the first I think is commun problem in Report Designer is Datepicker , one I choose two date from same month and same year data show and also the tablix show but if i choose from other month the data no show let's tak exemple
I have my facture in date 10-12-2018 if i choose stard date is 01-10-2018 and end date is 20-10-2018 the data show and facture show in tablix if i change same paramter to
01-10-2018 and end date to 20-12-2018 the data not showing any more this my picture to make u understand
https://ibb.co/LPYkNRP
https://ibb.co/xHhCGJD
the second problem is the sum so I have tablix with contain father group with footer called facture date in left and I put child group my problem is with the column "Total"
when i make expression Sum of it is always give me wrong result I think is calucled it more than once in my exemple so I want to make correct to became same behavie like "SellerPrice" , so keep in mind that "Total" field is child Group and "SellerPrice" is just column this my picture I hope u understand what I mean the problem is in red color
https://ibb.co/3RHpkP9
I will attach also my .rdl file to make understand more what I mean
thank you again

Attachment: clientAccount_474399fc.rar

Mageshyadav M [Syncfusion]
Replied On December 10, 2018 02:15 PM UTC

Hi Ahmed, 
 
Please find the response for your queries. 
 
Query 
Response 
one I choose two date from same month and same year data show and also the tablix show but if i choose from other month the data no show let's tak exemple 
I have my facture in date 10-12-2018 if i choose stard date is 01-10-2018 and end date is 20-10-2018 the data show and facture show in tablix if i change same paramter to 
01-10-2018 and end date to 20-12-2018 the data not showing any more this my picture to make u understand 
 
We have checked the mentioned problem with shared RDL file. In that you are using the conversion for Datatime value in dataset so it filtering the invalid data’s from SQL Server.  
(We have checked the RDL file with your filtering in SSRS ReportServer there also we are getting invalid data’s) 
 
 
 
So can you please remove the Conversion in where condition as shown in below snap. 
 
the second problem is the sum so I have tablix with contain father group with footer called facture date in left and I put child group my problem is with the column "Total" 
when i make expression Sum of it is always give me wrong result I think is calucled it more than once in my exemple so I want to make correct to became same behavie like "SellerPrice" , so keep in mind that "Total" field is child Group and "SellerPrice" is just column this my picture I hope u understand what I mean the problem is in red color 
I will attach also my .rdl file to make understand more what I mean 
thank you again 
 
We are unable to determine your exact requirement. We suspect you are asking to get the sum of total for child group so we have modified your report with sum of totalfac and report can be downloaded from below location.  
 
If this is not your requirement then can you please share additional details to provide proper solution. 
 
Regards, 
Mageshyadav.M

Unknown
Replied On December 10, 2018 05:38 PM UTC

thank you 

First  I'm making a multiculture Program so it had many language inside due to that every datetime is saved in sql database with diffrent Culture so I had to convert it to same culture , see what happend when I remove conversion 
so I hope to give me optimal solution for that 
https://ibb.co/gTJ0WZs

second , what I want is sum of  total field you see it is calculating it two time keep in mind total field is child group and sellerprice field is normal column and I used Sum expression ,  I give you this picture and modified my RDL to make it easy on you to understand me 

https://ibb.co/GRh1343

the modified report here , thank you 


Attachment: Modified_5f7fc263.rar

Mageshyadav M [Syncfusion]
Replied On December 11, 2018 10:44 AM UTC

Hi Ahmed, 
 
Please find the response for your queries, 
 
Query 
Response 
First  I'm making a multiculture Program so it had many language inside due to that every datetime is saved in sql database with diffrent Culture so I had to convert it to same culture , see what happend when I remove conversion  
so I hope to give me optimal solution for that  
 
A support incident to track the status of DataTime parameter not working has been created under your account to debug the issue in meeting. Please log on to our support website to check for further updates.   
    
second , what I want is sum of  total field you see it is calculating it two time keep in mind total field is child group and sellerprice field is normal column and I used Sum expression ,  I give you this picture and modified my RDL to make it easy on you to understand me  
 
 
 
Thanks for sharing the additional details.  
 
We can achieve your requirement with using the Group name in Sum expression instead of Dataset name shown in below snap. 
 
 
 
We have modified your RDL file and it can be downloaded from below location 
 
 
Regards, 
Mageshyadav.M 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;