Filter
:
Has Code
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
-
Answered0VotesHow to get values partly coming from database in table or textbox?
Hi, I am using SSRS 2008. In my dataset value is coming like "2012-08-16 07:07:27.790" datetime. I want only date in my textbox ... -
Answered2VotesNeed help! SSRS corrupted?
All of the sudden a subscribed report had a formatting changed in one cell that throws the report layout off. When I preview the report from the report server, I see the same thing. However, in BIDS ... -
Answered1VotesSSRS Spreading Data across 2 columns
Hi! I'm building a report on SSRS and I was wondering if it was possible to split all of my data into 2 columns within the report. This way, I can view all of the data on half the ... -
Answered0VotesCan I use lookup function to get a value from one dataset?
Hello, have one dataset with two columns, code and meaning. I have the code value and like to extract the meaning from dataset. I was looking at lookup function but it looks like I ... -
Answered0VotesReport builder 3.0 format tooltip text
Hey. I have a bar chart report made with report builder 3.0. It looks otherwise ok, but when I hover my mouse on the bars, the tooltip is showing my figures unformatted. I'd like to ... -
Answered3VotesIn BIDS Reporting Services AddIn will not execute SQL on refresh (SQL Server 2008R2 SP2)
Hi. After update from 2008R2 to 2008R2 SP2 in BIDS the reports does not fire SQL on refresh. This does only happen if the SQL changed. (looks like a crazy cache). So the reports ... -
Answered1VotesHow to split table horizontally in SSRS depending on condition?
Hi, I have created a table in Report using SSRS 2008 .Dataset which I have connected to table,contains 4 rows like Blood Pressure ... -
Answered0VotesEmail link in an action not showing up when displayed via web page.
Hello. I have a custom report with a non-functioning email link as an action. We are using Sharepoint 2010, Sql Server 2008 R2, and IE 9. I realize this might be a ... -
Answered1VotesSyntax Error with "=Today()"
Hi, Silly problem: when ever I try to put in =Today() into a placeholder in Visual Studio, I get a syntax error (indicated both by the red underlining around the two brackets, and ... -
Answered2VotesDealing with divide by zero
I recently received help on this forum to create this expression: =Format(Fields!KCOM_PAR_Tdy.Value,"0") & " (" & ... -
Answered1Voteshow to count specific values in single column
Dear Sir, I need how to count specific values in single column i'd tried count functions but i don't got result below mention the ... -
Answered0VotesNeed to Create a Parameter in a subquery
I'm using SSRS 2008 and I have a report with a subquery that contains a parameter, @LocationNo. what I'm trying to do is allow a user to enter a Location Number, which is a five digit integer, and ... -
Answered0VotesFormatting number in Report.rdlc
Is a local report in a Microsoft reporting control in winForms. How do I format a money value? -
Answered0VotesSSRS Could not update list of Fields for the query
I have a Stored Procedure dbo.SSRS_Report I am trying to get the Data Properties but getting an error. "Could not update list of Fields ... -
Answered1VotesChange background color ONLY for two row at a time
Hi, this code =Iif(RowNumber(Nothing) Mod , "PaleGreen", "White") will change background color for every other row. I want to change background color for ... -
Answered0VotesChanging a Column Heading Based on a Parameter Passed in a Procedure
Currently in the layout the column heading is hard coded. This is how the report parameters are set up In a ... -
Answered0VotesSharepoint integrated with SSRS 2008 R2 Issues
Hello Everyone SSRS Report takes 1 second in SQL Management Studion and in SSRS but when i check the same report on Sharepoint, it takes aroung 7-8 seconds. Can ... -
Answered2VotesInner and Outer Aggregate
Hi, I have the following code and need to somehow to do this calculation: =Sum(Last(Fields!DIFFERENCE.Value))-Sum(First(Fields!DIFFERENCE.Value)) Any suggestions? Any ... -
Answered0VotesReport Builder 3.0 #Error with Date Calcs
I am using Report Builder 3.0. In one of my columns, I'm pulling a date from a cube. A few entries come back with a value of "Unknown". I'm trying to use the following ... -
Answered0VotesSubreport Where Used
Is there an easy way to tell where a subreport is used? I have one that I think is used in multiple reports, but I'm not sure without opening and checking each one ...


