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.
Report: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportModified-1930529284.
If this is not your requirement then can you please share additional details to provide proper solution. |
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
|