Forum Replies Created
Viewing 15 posts - 1 through 15 (of 63 total)
-
RE: DROPDOWN LIST
Create a dataset to pull values from the cube with the query below.
select <parameter3 value that goes into the the dropdown> from cube where <parameter3> <param 2 like = begins...
"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 Report - Number of Subcategories in Category
=CountDistinct(Fields!SubgroupCode.Value,"GroupCodeName")
In the footer row of 'GroupCode' place the above expression.
"GroupCodeName" is the Name of GroupCode group
It should work.
"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: Where are you?
Born, Coimbatore (Manchester of South India)
Earned my stripes working in Bombay
Then Fort Smith, Arkansas
Then Dallas, Texas
Then Saginaw, Michigan
Then Winston Salem, North Carolina
Now Charlotte, North Carolina
"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: Tablix, Corss table sort sequence
If it is 2008, in Column Groups, right click the Group properties of the YYYY/MM column and under Sorting, choose that column and set the Order appropriately.
This should work.
Siva.
"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: How to handle optional parameter in SSRS with oracle
select a, b,c from xx where (@id is null or id =@id ) will solve your purpose.
Siva.
"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: Weird timeout, 1 report doesn't render even if the query is over in 5 secs...
No best practices. It is all from mistakes that I learnt(continously learning) from.
As you rightly pointed out, DB size does not matter, but if you find time to exlpore 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: Weird timeout, 1 report doesn't render even if the query is over in 5 secs...
Geez! you have answered yes to most of the questions......
See, if , for a matrix cell against a row/col group, the query does not return a value, then SSRS...
"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: Weird timeout, 1 report doesn't render even if the query is over in 5 secs...
[Not a fix/soln, just to investigate further]
Hi there,
Are you using a matrix?
Are the columns in the table only fields from the query with groupings.
In the dataset properties tab, are all...
"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: How to get a list of SSRS schedules for subscriptions
Connect to each of the ReportServer DBs and run the query.
Or talk to your sys admin to script 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: How to get a list of SSRS schedules for subscriptions
selectc.Name,
s.StartDate,
s.NextRunTime,
s.LastRunTime,
s.EndDate,
s.RecurrenceType,
s.LastRunStatus,
s.MinutesInterval,
s.DaysInterval,
s.WeeksInterval,
s.DaysOfWeek,
s.DaysOfMonth,
s.[Month],
s.MonthlyWeek
fromdbo.catalog c with (nolock)
inner joindbo.ReportSchedule rs
onrs.ReportID = c.ItemID
...
"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 Installation is a bit tricky
OK.
what is your current state.
Could you try http://localhost/reportserver and http://localhost/reports
and reply with what you see.
"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 - Changed Stored Procedure Name
It is not custom code I am referring to, Ben. Just right click the report(rdl) in the solution explorer and select View Code. The report's xml code will open 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: SSRS - Changed Stored Procedure Name
Glad you found a workaround.
Out of sheer interest, you can right click on the report and View Code and look for the old SP name and see where it still...
"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: alternate backgroud color base on "grouping of state"
On the matrix cell, where you have state, for the background property use the Select expression
IIF is only for either or choices. when you have more than 2, then, Switch...
"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 - Changed Stored Procedure Name
after you rename the SP and refresh the datset, did you rebind the refreshed dataset with the table control on the report.
Go to the table properties and choose the current...
"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 - 1 through 15 (of 63 total)