Syed Qazafi Anjum's threads
Filter
:
Has Code
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
-
Answered0Votes
How 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 ...
-
Answered2Votes
Need 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 ... -
Answered1Votes
SSRS 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 ... -
Answered0Votes
Can 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 ... -
Answered0Votes
Report 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 ... -
Answered3Votes
In 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 ... -
Answered1Votes
How 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 ... -
Answered0Votes
Email 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 ... -
Answered1Votes
Syntax 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 ... -
Answered2Votes
Dealing with divide by zero
I recently received help on this forum to create this expression: =Format(Fields!KCOM_PAR_Tdy.Value,"0") & " (" & ... -
Answered1Votes
how 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 ... -
Answered0Votes
Need 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 ... -
Answered0Votes
Formatting number in Report.rdlc
Is a local report in a Microsoft reporting control in winForms. How do I format a money value? -
Answered0Votes
SSRS 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 ... -
Answered1Votes
Change 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 ... -
Answered0Votes
Changing 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 ... -
Answered0Votes
Sharepoint 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 ... -
Answered2Votes
Inner 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 ... -
Answered0Votes
Report 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 ... -
Answered0Votes
Subreport 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 ...
