Viewing 15 posts - 2,986 through 3,000 (of 3,480 total)
Most likely because there's a significant difference between the meaning of @StatisticsDate and StatisticsDate in your statement.
@StatisticsDate is always a variable. When the parser sees "StatisticsDate" it has to...
May 30, 2014 at 8:14 am
Did you compare it to a standard MAX(Date) with a GROUP BY clause?
May 29, 2014 at 6:37 pm
Too young? No such thing, I think.
Too inexperienced? That's another question entirely.
If you really want to be an SSRS expert, you need to learn T-SQL (Microsoft's version of...
May 29, 2014 at 2:54 pm
So do you really mean "page breaks" instead of "control breaks"?
maybe this discussion will help?
May 28, 2014 at 8:47 pm
Is using SSRS an option or do you need to do it in T-SQL? The nice thing about doing it in SSRS is that the columns are dynamic.
May 27, 2014 at 7:00 pm
select only the data from the first table that is not available in the second table
SELECT A.*
FROM A LEFT JOIN B ON
(several joins - on the columns that match)
WHERE B.ForeignKey...
May 27, 2014 at 2:11 pm
I do not know how to merge the cells.
depending on where you are in the tablix, you may or may not be able to. What I mean is, it's going...
May 27, 2014 at 10:50 am
However, the bar chart subreport is not getting the selected parameter value
...
Only thing I can think of is that you didn't set the subreport's parameter to be equal to outer...
May 27, 2014 at 6:36 am
sounds like a WiseOwl tutorial... they're all on YouTube
May 26, 2014 at 5:08 pm
I know this is closed, but it's better to pass the parameter to the stored procedure and filter there. Otherwise, you can send a lot of data to the...
May 24, 2014 at 7:20 pm
Woudn't you specify that in your sort list?
Sort by:
column1
column2
SortParameter1
etc?
Then SortParameter1 could be a value list of the remaining column names. (Just build a function to determine the sort order...
May 24, 2014 at 7:43 am
You filter the second (cascaded) parameter based on the first parameter.
Given @param1 and @param2, the value list for @param2 is usually
SELECT somecolumn
FROM someTable
WHERE someField = @param1;
May 21, 2014 at 4:40 pm
Are you trying to point at something with an arrow or underline something? Underlining is easy, but drawing arrows on something that will change shape might be tricky.
May 21, 2014 at 2:14 pm
Nothing doing:
-- set up table
use tempdb;
GO
CREATE TABLE t1 (
PO_Num INT PRIMARY KEY,
DaysToTravel INT,
DaysInWhse INT);
GO
-- add some sample data for folks to play with
INSERT INTO t1(PO_Num, DaysToTravel, DaysInWhse) VALUES
(1,10,20),
(2,5,30),
(3,7,40);
-- now...
May 20, 2014 at 9:25 pm
Viewing 15 posts - 2,986 through 3,000 (of 3,480 total)