SQL reporting services has a little search box in the top of the report viewer. When used, it finds the search text, navigates to containing page and highlights the text on the page. My question is how can I do this when the report loads. Currently I have a reportviewer embedded in my page. Is there a method that will find? I am usi...
I'm trying to change the default page size, margins and grid spacing for new reports in Report Builder 1.0. The defaults are American (i.e. Letter paper size and Inches). I need to change this to UK (A4, cm). In the VS2005 report designer this can be done by modifying report.rdl in C:\Program Files\Microsoft Visual Studio 8\Common7\...
Zilch on the web or BOL Any ideas? ...
I have two reports built using SSRS 2005. The first report is set to navigate to the second when a specific field is clicked. I am using an expression similar to the following in the "Jump to URL" property of the textbox: ="javascript:void(window.open('http://server/reportserver?%2fFolder%2fMyReport&rs:Command=Render&Date=" & ...
I added an additional, new DataSet to my report and have been getting this cryptic error ever since. ...
Hello, I am developing an ASP.NET MVC website. The reporting is done by SQL Server Reporting Services. I know how I can make a PDF file out of a report without showing it, yet I'm not sure what's the easiest/best way to store this file an make it available for download in MVC or send it via email (out of MVC). Any help or direction wou...
I'm trying to pull results from a database (sql server 2005) which takes 4 tables: Subscriber S, Member M, ClaimLines L, ClaimHistoryLines H Query is as follows: select S.SBSB_ID, M.MEME_NAME, (CASE L.CLCL_ID WHEN '' THEN H.CLCL_ID ELSE L.CLCL_ID END) AS CLAIM_ID FROM CMC_CDDL_CL_LINE L, CMC_MEME_MEMBER M LEFT OUTER JOIN CMC_CLDH_DEN_H...
We are using SQL Server 2005 and SSRS to produce reports for a .NET2.0 C# web application. When viewing reports in Safari or Chrome we are having issues with: Missing toolbar controls - Export, Resize etc. Font size is very large. Example: When viewing in IE7/8 the font appears to be 12pts. When viewing it in Safari the font is 24pts...
RS2005 doesn't like this syntax. What's wrong with it? How do reference multiple tables in one textbox? =sum(Fields!onHand.Value, "Table1") / sum(Fields!QTY.Value,"Table1") ...
Currently I get 3 rows back from a query, although the report only displays one of those rows. I need all three in the datatable, but only one row to be rendered. How can I choose that row specifically in the report. I'd rather not create another datatable in my dataset just to accommodate this. =FormatCurrency(Fields!tip.Value, "DailyS...
I've inherited a headache! I have two SQL Reporting Services servers. One is a production server, the other is a test server. I know for a fact that some of the reports were deployed directly to production. I know for a fact that some reports are out of sync, meaning the version on Test isn't the same as the version on Prod and vice-...
I am doing some work in Reporting Service 2005. I need to call a COM object so I wrapped the call in custom assembly. The approach worked in preview. But when I deployed the report I ran into #Error. Microsoft has a KB article about this: http://support.microsoft.com/?kbid=842419 It says that I have to assert permission in my custom as...
I am trying to use URL access to pull down some reports from sql server reporting services 2008. One of the parameters I need to pass is a Guid. When I just paste the guid in to the url as &LoggerID=CD4869DC-68B8-4513-B3C6-0E6DD9F74380 I get the error: Default value or value provided for the report parameter 'LoggerID' is not a valid ...
Hi, I have a strange scenario wherein I am having to delete the data from the table once a report is generated. The data gets uploaded to the table when the user clicks on a "Generate Report" button on the web page. My problem is that once the report is generated and shown on the report viewer control I don't want the user to click on ...
Hi, I am writing a Custom C# code that uses Reporting Services Web Service to retreive folders, and reports underneath each folder. On top of that, I want to make each of those reports linkable, so that when you click on it, the link will take you to another Web App that displays the Report. I have following Code so far, and I dun know h...
In a matrix report is it possible to hide a column based on value of the parent group? For example, I've got a column called "value" which I'd like to hide when the column group that contains it has a specific value. ...
Can I use Reporting Services 2008 with SQL Server 2005 database? Do I need both licenses (for SQL server 2008 and SQL server 2005) Do I need two instances (SQL Server 2008 and Sql server 2005) or can Reporting Services 2008 be "installed" as add on to Sql server 2005? Thanks for answers, Matra ...
I have an issue whereby SQL Server Reporting Services graph image URLs become unavailable after attempting to just request the images after a few minutes (instead of also refreshing the HTML). The actual error is: "The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server d...
I'm writing an SSRS report that will change the value of one of the fields based on the value of another field in the same row. Would the best way to do it via SQL? i.e.-Multiply FieldX (float) by -1 if the value of FieldY ends with D,DA, or 'DB', etc. I was initially looking at using a case statement, however I was getting a little s...
Can we merge two cells of two different rows while designing a report in SSRS??? ...