sql-serveraggregate-functions
SSRS Report Total is incorrect
I want total of debit from invoice table and credit from payment table. credit total display correctly while debit is incorrect. I use Group on invoice# invoice table field.
It seems that it sum twice a value.
Can anyone tell me where i am wrong.
The data is stored in two tables. Invoice, which holds the Invoice# and Debit amount, and Payment which holds the Credit and Payment#.
Solution
Or you can do this in SSRS which is very simple just go to the Debit cell right click and select Add Total something like this in the following example, I have added a total for Unit Price column.
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?