Viewing 14 posts - 211 through 224 (of 224 total)
brett grammar (1/25/2007)
So RS does not have Report Headers, only Page Headers, which are created and appended after the body of the form is generated. I had a fairly simple...
October 12, 2010 at 3:42 am
I feel sorry for you. These areas are very poorly documented with real world examples of usage, even in books dedicated to RS (I know, because I've read them all).
October 12, 2010 at 3:34 am
Sacheen (9/29/2010)
I have created one parameter in a report which takes values from a dataset.
I have marked option to allow NULL values but when values are populating in the parameter...
October 12, 2010 at 3:32 am
That's what I do (in some cases, for some specific reasons, that escape me right now):
WHERE InvoiceDate >= DATEADD(d, DATEDIFF(d, 0, @StartDate), 0)
AND InvoiceDate < DATEADD(d, DATEDIFF(d, 0, @EndDate), 1)
October 12, 2010 at 3:20 am
There's a knowledge base article on Microsoft's site that lists all the SQL updates since each main release and service pack.
2008: http://support.microsoft.com/kb/956909
2008 SP1: http://support.microsoft.com/kb/970365
(there's none...
October 12, 2010 at 3:18 am
I don't know about MDX, but I do know about RS's Hidden parameter and how it sometimes doesn't do what you expect. For example, sometimes it leaves blank space and...
October 12, 2010 at 3:12 am
There's a list of groups at the bottom of BIDS, you can right click the group you want and click to add a row outside the group above; that will...
October 12, 2010 at 3:07 am
I have a hundred or so reports that need to be deployed into different folders, and copied across multiple servers (development, testing, production) which means that the BIDS deploy function...
October 12, 2010 at 3:01 am
I store files locally, and keep them in source control. We used a 3rd party program for that named Fortress, and it integrates properly with BIDS 2008. It puts little...
October 12, 2010 at 2:47 am
I couldn't understand what you were trying to do, but accessing sub report values from the parent report isn't possible.
I think what you want can be done in a different...
October 12, 2010 at 2:43 am
I would love to hear any real world implementations of report models. As far as I've seen them, they're unusable if there's going to be any changes in the database...
October 12, 2010 at 2:41 am
You're comparing an integer with a string by accident, so it fails. I think you want to do:
=IIf(Fields!TotalCalls.Value Is Nothing, 0, Sum(Fields!TotalCalls.Value))
October 12, 2010 at 2:31 am
I loved your entry today, it summarises my feelings about a lot of companies today - and getting dropped instead of being transferred seems to happen a lot more than...
January 14, 2010 at 1:28 am
Resolved:
WITH Link_CTE (link_id, next_link_id, root, level) AS
(
SELECT link_id, next_link_id, root = link_id, 1 AS level
FROM things t
WHERE EXISTS (SELECT * FROM customer c WHERE c.link_id = t.link_id)
UNION ALL
SELECT t.link_id, t.next_link_id,...
January 4, 2009 at 7:01 pm
Viewing 14 posts - 211 through 224 (of 224 total)