Hot answers tagged reporting-services
42
Really Short Answer - In Place is okay. You can review your configuration afterwards and implement the best practices for SQL Server 2012.
A Longer Answer on SQL Server Upgrades/Migrations
So this is an opinion thing and there isn't a necessarily wrong or right answer but I prefer migration style upgrades over in-place for a lot of reasons. That being said ...
10
In my experience, the same decision making process should be made as prior. AFAIK there hasn't been any 'world changers' with SQL Server installation, within the MS SQL Server product in itself, and the potential problems you have when rolling out software with millions of lines of code. Something bad could happen and now you're stuck with no 'ROLLBACK' ...
6
Using a database snapshot located on your production OLTP server will, in all likelihood, make performance worse. There are two main reasons:
Extra write overhead. Snapshots are copy-on-write, so this will obviously impact performance.
A snapshot will share pages from the old database on disk, but it uses its own memory in the buffer pool. If you have a ...
5
Mirroring is for individual database. For reporting services, you can user web server farms (AKA scale out deployment). It will allow multiple servers in a cluster. You will need SQL Server Enterprise Edition for this feature, though, as well as a load balancer (Windows has this or NW hardware like BigIP, etc.). See here for more info:
...
4
I don't have 2008 to look at but do you have access to the RDL files that were published to the server? I can't recall if those are plain old XML files, but I think if you have those, it's probably a convenient way - you could parse them with Linq to XML, or XSLT.
The schema is documented at:
http://msdn.microsoft.com/library/dd297486%28SQL.100%29.aspx
4
You could do something like this.
declare @T table
(
Department varchar(50),
[Staff Name] varchar(50)
)
insert into @T values
('Web - Electronics', 'Matthew'),
('Store - Electronics', 'Mark'),
('Web - Home', 'Luke'),
('Store - Home', 'John'),
('Store - Home', 'Paul'),
('Store - Home', 'Simon'),
('Web - ...
4
Open "Reporting Services Configuration Manager" --> Database, verify the login under [Current Report Server Database Credential] is one of users in RSExecRole or not, if not, click "Change Credentials" button to change to an user in RSExecRole.
You can also use commnadline utility rsconfig as well http://technet.microsoft.com/en-us/library/ms162837.aspx
...
3
You should format your label so that there is a background color of white (instead of default none).
Right-click on one of the labels and select Series Label Properties. Select Fill. By default this is set to No Color. Change it to White. Click OK. That should take care of it!
ADDITION: It may be possible to write an expression to change the ...
3
If you only want the reports stored daily (and not the data itself), you can create your five reports and setup a daily subscription to be delivered to a file share. See File Share Delivery in Reporting Services.
3
If you have lost the historical data (i.e. it gets overwritten rather than stored as a transaction history) then you can't reconstruct the historical state - full stop. However, there are a few approaches to dealing with this.
Build an automated process that queries the system through SSRS or some other mechanism and saves the historical reports to an ...
2
I believe that you need parametrized reports in SSRS - with a date parameter for your report.
You will find the theoretical and practical details and some step by step tutorials about parameters in SSRS reports in the following articles:
Adding Parameters to Your Report on MSDN
Tutorial: Adding Parameters to a Report (SSRS) on MSDN - here more specifically ...
2
Intuitively, if I was doing an OLAP solution for a retail chain, I'd say your infrastructure is really inappropriate for a system with substantial data volumes. This sort of kit has trouble with the data volumes you get in insurance, which is probably a couple of orders of magnitude smaller than I would expect to see in retail.
As gbn states in the ...
2
Only a couple of things come to mind.
Hack sp_dbcmptlevel and add a "IF suser_sname() = 'Your SSRS Account' RETURN" to the very top of it.
Add a DDL trigger to the database that simply rolls back any alter database statements.
There's no way to intercept the database call and prevent it from being sent to the database engine.
2
If you have an ASP.NET developer on hand, have them use the ReportViewer control to embed the report directly into a plain old aspx page. I've done this to a few reports, and they never show the usual "Report is being generated" message that you get when accessing them via Report Manager. (You might have to set AsyncRendering="False" on the ReportViewer ...
2
Database Snapshots are read-only, so you couldn't run read/write ETL processes against the snapshot. However, you could point reports, end-user adhoc queries, etc. at the snapshot. This would allow you to run the ETL processes against the live database without interfering with user reporting. A new snapshot would need to be created after ETL processes ...
2
What's throwing it off is the XML name spaces in the tags. To get around this you need to use the with XMLNameSpaces clause.
Give this query a go.
I've tested this on a test instance (2008, not 2008 r2), so you may need to change the actual namespace definition to match your xml data.
with ...
2
It is because it may not have a value at that pariticular field/place so first replace the value providing box with:
iif(IsNothing(sum(field)),"0",(sum(field))
Then replace row summary field with the below expression:
...
2
I wouldn't worry about setting the time component. Just write your query like this instead:
WHERE SomeColumn >= @StartDate
AND SomeColumn < DATEADD(Day, 1, @EndDate)
You have @EndDate = Today() which by default does not have a time component (or rather it's already 00:00:00). Adding a whole day to that gets you tomorrow at midnight. So the ...
2
Unfortunately, a workgroup is just a collection of computers on a local area network (LAN) that share common resources. They provide easy sharing of files, printers. But they don't provide shared security, like a domain. There doesn't exist something like workgroup users (as the domain users which can be used on all domain machines).
So you'll need to use a ...
2
Well according to MSDN here:
Group or User
Type the name of a group or user account in your
domain. If the report server is running under a local account, you
must specify local groups or users. If the report server is running
under a domain account, you must specify domain groups or users. Enter
the account in this format: \.
I would take ...
2
You shouldn't have any issues, just be sure that when you plan your maintenance for SQL Server you don't get blocked by the "Restart Computer" rule. E.g. if you have installed Windows Updates in the meantime you might not know that Windows needs to be restarted until you enter your maintenance window...
For some background, I got surprised by this during a ...
1
Absolutely sounds like a network issue. I've been working for a CDN with POPs all over the world and I've ran into similar issues.
When the server is not being heavily used clear the SYS.DM_OS_WAIT_STATS and run a query against it, then check it again. A much better solution would be to use Extended Events to see what wait times are adding up on your ...
1
You should indeed be able to do this using the Catalog table in the ReportServer database. It contains a column Content with the report definition in binary, which you can convert to XML with a query.
The resulting XML can then further be queried. I personally don't have much experience with this, but with just glancing at the query method and basic XQuery ...
1
I see a couple of ways this could be done without resorting to anything overly fancy.
The first would be to use Windows integrated authentication and assign permissions to the groups which represent users of the application.
You could create roles which could be granted, and then use set role to assume the role in your code in the db. This way you aren't ...
1
It is a bit kludgey, but here's an idea sketch... instead of merging the cells, could you fake it by placing an A in the left cell aligned to the right and a D in the right cell aligned to the left? You could then use expressions to control value, alignment, color, and borders of the two separate cells.
Let me know if you need more details. I think this ...
1
You should be able to write any sort of code in .Net and connect it into SQL Server. See http://www.codeproject.com/Articles/19954/Execute-NET-Code-under-SQL-Server-2005 for an example.
1
The page setup in the print options does not control your report parameters. You will need to use the Height/Width property of the report inside BIDS. Orientation in SSRS is controlled by setting these values. We have a report at our office that is similar to what you describe and there are two ways of (semi) achieving what you want to get done.
The first ...
1
What I have seen in a case like you ask about is you hit a report, and copy the url out and then try to hit it later. Reports have session state, especially if you change paramaters,etc. The url will look like a report url with some funky querystring data added to the end. You can't share that because SSRS can't take your "session state" and then find it ...
1
SSRS in the Report Model is available in sql 2008 R2, but not in express edition
check
http://msdn.microsoft.com/en-us/library/ms365305(SQL.105).aspx
and here is how to apply it on sql 2008 R2
http://msdn.microsoft.com/en-us/library/ms365343(SQL.105).aspx
and if you want to create a view and get TSQL and AD to talk
you can use the following functions to ...
1
I think only you can answer this question by testing out a few things. The SQL Server End recommendation you list are really just good query-writing practice. Whether or not you cache the reports depends on how live your data is and how live your reports must be.
When I am trying to improve an SSRS report, I optimize the query (in SSMS) as much as I can ...
Only top voted, non community-wiki answers of a minimum length are eligible
