Forum Replies Created
Viewing 15 posts - 31 through 45 (of 63 total)
-
RE: Repeate Table Header in SSRS 2008
Please see my response to the related post here: http://www.sqlservercentral.com/Forums/Topic593245-1063-1.aspx
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Learn next to SSRS
How about this from Wrox.
Arun, see if you can buy this in Chennai, else PM me I will check if I can send it thru' someone.
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Paging in SSRS 2008 shows 1 of 2?
The buzz word is On Demand Report Processing.
http://msdn.microsoft.com/en-us/library/bb630400.aspx#OndemandProcessing
And for the pros and cons of this please see Robert Bruckner here: http://blogs.msdn.com/robertbruckner/archive/2008/08/11/on-demand-report-processing-in-rs-2008.aspx
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Paging in SSRS 2008 shows 1 of 2?
The ? is not just a ?.
In 2005, if a report had 180 pages worth of records all were rendered as a whole.
In 2008, only a page worth of data...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Averaging time from calculated report items in SSRS
OK. what is the data type of Fields!ResolvedTime_1.value.
Are you not trying to use AVG on a date time column.
convert them into minutes or seconds, treat them as a number...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Export to Excel Show GridLines
Sorry Rahul.
do you want gridlines on cells, say that is a header (textbox in the report) or do you want headlines outside of the region occupied by the report in...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Export to Excel Show GridLines
Look for properties:
border color, set it to black and
border style set it to solid
Try for table properties if that does not work, then set the same properties...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Conditional where statements for a multi-selection parameter
Let me show you how to do this when @test-2 takes a single value.
WHEREPOP30300.VOIDSTTS = 0
ANDPOP30300.GLPOSTDT >= @start
ANDPOP30300.GLPOSTDT < @end
...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: SSRS 2005 losing authentication - Error message 401.3 when changing report parameters
Does he have rights to the Item Level Task: 'Manage Reports', that grants rights to change parameters. http://msdn.microsoft.com/en-us/library/ms160344(SQL.90).aspx
Try it out.
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Ad Hoc Reporting with parameters
Ohk, here is your query.
SELECT column A, column B, column C, column D, column E
FROM table_123
WHERE column E = '0
Since this is an Ad hoc report, I assume you have...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Creating Index page with page numbers (for a report with many subreports)
You might have heard this sermon before. There are three phases: Design, Execution, Rendering.
Based on the number of records returned during execution, pagination will occur during rendering. And you...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Custom Code for Report Header
Sorry, the approach that I have given above is only when only one of the sub reports is selected.
Cannot think of a solution at this time.
Sorry again.
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Custom Code for Report Header
At any given instance will all three sub reports SUB1, SUB2, SUB3 be selected/printed or only one of the sub report will be selected.
If the latter is the case, you...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Repeating TABLE Header on each page of the report when you print the exported to excel report.
Did you check the box for Repeat header rows on each page?
Do you know where to do this?
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
-
RE: Repeating TABLE Header on each page of the report when you print the exported to excel report.
what is the image/figure on your header rows when you select the table. You should see the header image. Or are you seeing the image with three black lines denoting...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Viewing 15 posts - 31 through 45 (of 63 total)