Viewing 15 posts - 106 through 120 (of 173 total)
Did you try simply adding a total row to your group? If it is grouped properly, the sum by group should work fine. Right click the group name...
January 24, 2012 at 4:01 pm
and SQL does kick butt
January 23, 2012 at 6:16 pm
As everyone else alluded, whenever you have potential for many attributes for a single instance, it is generally better to build your tables vertically (rows instead of columns). It...
January 23, 2012 at 4:11 pm
select
c.cus_code
,[number of Invoices]=COUNT(distinct i.INV_NUMBER)
,[Invoice Total]=round(SUM(l.LINE_PRICE * l.LINE_UNITS),2)
from
#CUSTOMER c
left outer join #INVOICE i on i.CUS_CODE = c.CUS_CODE
left outer join #LINE l on l.INV_NUMBER = i.INV_NUMBER
group by
c.cus_code
having
COUNT(distinct...
January 23, 2012 at 1:51 pm
Interesting that the syntax is different for concatenation than in tsql.
In SSRS you'd use VBA, so the concatenate syntax should be =Fields!FieldName.Value & " " & Fields!OtherFieldName.Value. ...
January 17, 2012 at 6:00 pm
Glad to help!
January 13, 2012 at 2:22 pm
selectoi.OrderItemsID
,oi.ItemID
,oi.OrderID
,oc.OrderDescription
,TotalCharge=Sum(oc.OrderCharge)
from#OrderItems oi
left outer join #OrderCharges oc on oc.OrderID = oi.OrderID
and oc.itemid = oi.itemid
group by oi.OrderItemsID
,oi.ItemID
,oi.OrderID
,oc.OrderDescription
January 13, 2012 at 1:56 pm
Just a guess - but maybe your SharePoint field is a Rich Text field. The font formats are preserved.
January 12, 2012 at 6:38 pm
Get yourself some R2, you can name the tabs.
January 12, 2012 at 6:34 pm
Create Table Client_Products_Asoc(Client_Products_Asoc_ID Int Identity(1,1) Primary Key ,Client_ID Int References dbo.Clients(Client_ID) ,Product_ID Int References dbo.Products(Product_ID))Go
Logically, the ClientID + ProductID should be unique so you can use them together as a...
January 11, 2012 at 6:18 pm
I did a stint a while back with a firm that provided software solutions (term used loosely) for the mortgage servicing industry. It was typical while providing software demos...
January 4, 2012 at 4:42 pm
blackbelt in googlejitsu
lol
January 4, 2012 at 2:49 pm
Did you try the background image property for your report object?
January 3, 2012 at 2:50 pm
funniest danged thing EVER!
January 3, 2012 at 1:28 pm
Viewing 15 posts - 106 through 120 (of 173 total)