Syed Qazafi Anjum's threads
Filter
:
Has Code
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
-
Answered1Votes
How to combine multiple fields into one Group?
I am new to SSRS reporting and I am creating reports using Data Views. In the database I am reporting on I am trying to group by State, but 1 state may be entered a few different ways. (Ex. TX, Texas, ...
-
Answered1Votes
=SUM with IFF
I have a simple =sum(Fields!something.Value) that brings back NaN. I'm thinging this is a null value but I try to add IIF(Fields!something.value = "NULL",0) but id SSRS ... -
Answered0Votes
SSRS Pi chart report formatting issues
Hi, We are facing problem with Pi chart formatting in SSRS, we want the result to be displayed as shown in below image, for the narrow slices we want to display ... -
Answered0Votes
How to make make report open in new window?
Hi , I have one static url in 1 column of SQL table and and 1 ID in other table and other extended column of url in the same table. I ... -
Answered1Votes
Formatting SSRS Bubble chart
Configuration options for the bubble chart seem very limited. 1) I need a setting where I can control the minimum and maximum size of the bubbles. The screenshots ... -
Answered0Votes
Set background color from hex
I'm trying to set a table cell's background color from the database. The color values stored in the database are strings like this: #FFAE5308. In the report designer I'm setting the ... -
Answered0Votes
Formatting a text box based on its value
=100 or something like this. Any help would be appreciated. Murali Krishnan -
Answered1Votes
case in where clause
declare @var varchar(5) SET @var = 'something' --when @var <> null SELECT * ... -
Answered0Votes
How to find Sunday,Between two dates in Reportviewer
Dear sir, I need exclude Sunday between two dates using DATEDIFF() ID ... -
Answered0Votes
How to sum the Actualwork column values and percentages column values at the bottom with specific resource
= @SDate AND convert(VarChar(10),CAST(PeriodEndDate AS DATETIME),126) <= @EDate AND SUM(T.ActualWorkBillable) <> 0 AND PeriodStartDate -
Answered2Votes
SSRS 2008 R2 - Stored Procedure dataset does not show fields
Hi I am using SSRS 2008 R2 and I have a dataset that uses Stored Procedure with dynamic SQL and it does not show me the fields and looks like I need to add them as calculated ... -
Answered1Votes
Only Display First 3 Rows of Tablix
In a SSRS report I only want to display the first 3 rows of a Tablix. For example, I have a list of employess with their sales figures, and I want to only display the top 3 ... -
Answered0Votes
default value not working within report
On my reports I have several paratmeters and most of them are tied together, meaning that parameter 2 is based of the parameter 1 selection parameter 3 is based ... -
Answered0Votes
Passing OLEP parameters in the URL to access the ssrs report
Hi, I cannot get Reporting Services to accept the parameter via URL access rather it gives the error that The path of the ... -
Answered0Votes
How to handle this scenario
I have created one table in which 3 columns named Year,Months , and third WorkingDays (in which numeric values) I want that three DropDown lists in report . In which one is ... -
Answered0Votes
Passing multiple values from a FIELD in my main report to my child report
Hey ! I have a main report which has only 1 "AsOfDate" parameter and has 4 columns and all of them have been added to the Group By clause as well. So, my report looks something like ... -
Answered0Votes
Total of totals.
My result set from the SQL query contains 3 columns. An ID, and important to this question: two columns each with numbers. I added a manual/custom 4th column to my Tablix, ... -
Answered1Votes
SSRS 2005 + countdistinct function
Hi, We are using SSRS 2005. One of the reports I had to do countdistinct on field updateuser which is nothing but user who updated transaction. Not ... -
Answered0Votes
SSRS 2012 Rounding function - forcing to have 3 digits after decimal point all time
Hello All, I need the data to be formatted as below. something like forcing the value to have always 3 digits after decimal point - 14.56 as ... -
Answered1Votes
How to substitute NULL parameter for subreport?
I am using SSRS 2008 R2. My RDL has several subreports in it which all take one field value only from this parent RDL as their inputs. This one field value is called ...
