Viewing 15 posts - 106 through 120 (of 183 total)
It still doesn't work, even when i have used the correct expression, any other idea's?
July 30, 2008 at 8:45 am
It still doesnt work for me, where will type this expression in the group footer?
July 29, 2008 at 10:25 am
The query is to be used for a report within SSRS, but before i commit it into SSRS, i need to get the query right.
The outcome of the query is...
July 25, 2008 at 9:07 am
This should help.
Right click on the report item, and then select the 'Visibility' tab, and check the 'Collapsed (+)' box.
July 25, 2008 at 4:37 am
Fixed!!!, had to readjust the alignment of the table a little closer to the text box which was acting as the report title, as well as make them the same...
July 25, 2008 at 4:34 am
Will setting the autogrowth of the 'file growth' to 1%, and leaving the maximum file size to unlimited do the trick?
July 25, 2008 at 1:38 am
Its a live database been used by an e-commerce application, in other words there is only one user logged in at a time.
The recovery model is set to full...
July 24, 2008 at 4:31 pm
Sorted!!!
Figured it to be the lead DBA not giving me access rights as an administrator (dbo) on the server itself
July 24, 2008 at 9:13 am
Is this okay?
CASE WHEN ISNULL(SUM(QuantityShipped), 0) = 0 THEN 0
ELSE SUM(T_OrderLine.[Unit Price] * T_OrderLine.QuantityShipped) / SUM(T_OrderLine.QuantityShipped) END AS [A.S.P]
July 23, 2008 at 10:57 am
Hey All - Im back,lol
I just rewrote this query and i get the following error message:
Column 'CMDATA_Reporting.dbo.T_ProductClass.ParentProductClassID' is invalid in the select list because it is not contained in either...
July 23, 2008 at 10:21 am
Try creating a shared data source for the reports to run from. And then use the domain\user account for user to view them - which is the windows integrated option.
July 23, 2008 at 4:21 am
Just thought I should share this with you guys, it was sent to me by another member of SQL Server central:
This could point to two things:
1. In order to...
July 22, 2008 at 10:09 am
Funny how we find things around the net. Just thought I should share it with peeps in this forum for knowledge sharing:
using Report Manager, drill down to your report. ...
July 21, 2008 at 11:10 am
Sorry for the mix up about the dates i was just using 14 days as an example.
July 21, 2008 at 10:40 am
Hello All
I kinda found a way which is KISS (Keep It Simple and Simple), i used in my select query:
WHERE[ExpiryDate] BETWEEN getdate() AND getdate() +30
July 21, 2008 at 9:52 am
Viewing 15 posts - 106 through 120 (of 183 total)