I've got two datasources, one Oracle and one Sql Server. Due to circumstances that predate me (as in it was like this when I found it) some columns in the Oracle database contain PKs from lookup tables in the Sql Server database. I am attempting to create a Sql Server Reporting Services report that will combine data from both the Oracle...
I find the force close Report option very useful as a developer- the stack trace is really useful to see and I've been able to solve many bugs by using it. However, there are places in my app where (quite rightly) I've used a try/catch statement to handle Exceptions. The problem being, that this prevents a force close and so I can't ge...
We are configuring SQL Server Reporting Services on an existing installation of TFS 2010 RTM. After configuring the Warehouse, Analysis Services and Reports tab in the TFS Administration Console, I get the following error: "Failed to add BUILTIN\Administrators account to the TfsWarehouseDataReader role on the Tfs_Warehouse relational da...
In a reporting services report, I'm displaying a bullet point by using the expression : =ChrW(&H2022) This is in a TextBox setup to use Arial font. Now, it seems to work fine, but how safe is it ? i.e. is it likely to work on all PCs ? (The application is a web application). ...
The question is simple, I couldn't find any solution though. If it is possible, how do I repeat a field that's in the Footer on a new page if it doesn't fit the container? For example: I have a column that can store up to 5000 characters, and I must display it in the Footer. So if it reachs a certain number of characters, I'd like it t...
Hi Everyone, I'm trying to determine how exactly to convert SSRS reports to Word docs and have them sent to the Sharepoint doc library. From my research, all I could gather was that it's all part of SS Integration Services, but little else. I'm not using report builder, but Visual Studio. Any help here would be highly appreciated. Tha...
I've learned enough about SSRS to know that you can take snapshots and view a history of a scheduled report that is great. How we use it here is that we publish many reports and users run them when they want. Does SSRS store when users logged in and what reports they ran? Unfortuntely, I don't have database access to the report serv...
We have an application which is created in asp.net/flex front end, ms sql/ssas as data source. We are in phase of creating a new reporting module. so for consistency of graphs and ui we want to use flex as front end and SSAS as backend for reporting module. My understanding is: *Flex based UI (reports/parameters) SSRS Reports (standa...
I need to write a report that on startup shows specific groups expanded while other remains collapsed. I've been searching for a property like "collapsed" or "expanded" or similar at the group level, but I found none. The only way I've found to do something similar is through the "hidden" properties of the detail. But this way the +/- m...
Hi all, I've been struggling with the DBCC INPUTBUFFER in SQL 2005/2008 attempting to get some information on each run of my queries. I know there are a number of other methods available that can do similar things to DBCC INPUTBUFFER, including sp_who/sp_who2, fn_get_sql(), dm_exec_sql_text, and so forth, but none of these others retur...
Hi, I am new to SSRS. I have Business Intelligence VS 2008. I am trying to add report parameters to the report but the data tab does not seem to be coming up in the designer. My requirement is to pass parameters from the UI to the report in a remote/server mode. I have to just pass the parameters to the report and the report should ren...
Hi: one of our customers are having this exception randomly. We put in some re-try code and keep-alive code, yet it still happens. So I am looking at the SQL log our customer sent us. And I saw this. So basicaly, one of the report has no data in certain field. would that be the cause of that problem? library!ReportServer_0-15!150c!10/...
I am thinking of installing SQL Server 2008 R2 and tools on my box. But it occurred to me this might mean I cannot edit SQL server 2008 reports and use our sql server 2008 report server. Is this correct? ...
I was wondering if its possible/how to make a ssrs report so that a column will increment down the page until the end and then continue in the next column Time Weight Size CONTINUED 1:00 110 14 4:00 113 10 2:00 114 16 5:00 115 13 3:00 112 11 6:00 117 15 End of page ...
Hi guys, Im trying to create a report in SSRS. The report calls a stored procedure for its data. I want to display the data in a table. But the thing is, the result from the stored procedure differs from time to time, because every customer has its own 'template'. This means the result for customer A could be : AccountNumber | Customer...
I have a matrix in an SSRS 2008 report. The rows are grouped on the Time field, and the columns are grouped on the FieldName field. Pretty standard stuff, you can see the designer view of it below. This works pretty well, except that in some instances I need to hide the "time" column (highlighted in the image). I've tried setting the...
Hi guys I knew that you can develop customised code to generate pdf report via SQL Server Reporting Services (web services API). My question is: can you utilize the same mechanism to convert any HTML code into pdf file? My team lead wants me to convert html to pdf in this way to try to utilize the existing report services reference. ...
Hi All, We are having an SSRS server configured over a live IP. Before I can start building reports, I want to know What are best practice for developing reports that are easy to deploy How can I maintain SVN copies of my reports I was suggested to create shared data sources, what are they and what are benifits? What are security rela...
Hi, I have some report and plenty of parameters inside that report. One of parameter contains values stored inside dropdown list (that are downloaded from db). I wanted to set the custom width for a specific drop down list in my report so I do it by adding the following code in Report.aspx file located in: C:\Program Files\Microsoft SQL ...
i am new to SSRS and i have to generate sales report in which we have to apply different conditions in different columns i have three columns that has three conditions in profit column condition is accountID=13 and TypeID=23 in units column condition is accountID=8 and TypeID=14 in Disbursement column condition is accountID=78 and T...