Hi
I was able to generate rows with alternating colors by using the below exp. but it only works fine with table report.
=iif(RowNumber(Nothing) Mod 2, "Lavender", "White")
Please help me to get alternating row colors in a matrix report.
Regards
Durai
I am trying to get alternating colors on group headers.
The rownumber() doesn't work; that only seems to be the count of rows in the group.
Does anyone have any great ideas for this?
Thanks!
BobP
Hi All,
I have a table containing 21 columns. I want to alternate the color on the rows, to make it more radable and nocer to the eye. As such I set the BackgroundColor property on the entire TableRow (so it is applied to every textbox) to the following:
Code Snippet
=iif(RowNumber(nothing)Mod 2,"LightGray","White")
In theory it should work. I checked a few of the texboxes to make sure everything was okay and indeed the BackgroundColor property on each one of them was properly set to the above expression.
When I tried to build the report, I was prompted by 21 errors (one per textbox) stating the following:
[rsCompilerErrorInExpression] The BackgroundColor expression for the textbox 'FIELDNAME' contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
Obviously the TruePart parameter has been specified ("LightGray" in my expression), so what could be wrong??
Thanks in advance for the help
Idelso
When using the back color property for SSAS 2008 R2, is there a good way to match the number to the desired color? I found some color pickers online, but the numbers don't match the same colors in SSAS. How can I best determine the number needed for the color I want?
View 2 Replies View RelatedI have a field in one of my tables that has the RGB colors stored as 255,255,255 format. Is there a way to convert this to Hex color code to be used inside SSRS for a conditional color expression?
View 9 Replies View Related1)What is alternating way for this query.
2)What is mean by sql injection ?
3)Is it safe to use exec in stored procedure?
kindly answer ASAP
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: Suyog Dabhole
-- Create date: 27/9/2007
-- Description: View all history data for detail invoicing report
-- =============================================
ALTER PROCEDURE [dbo].[procGetAllDetailInvoice]
@Date nvarchar(25)=null, --Date format like (10 Aug 2007) no timeing send by BAL
@MonthDate nvarchar(25)=null, --From BAL sended date is of format 01-MON-YYYY(01 Aug 2007)(default day is 01)
@FromDate nvarchar(25)=null, --date format is like DD MON YYYY(12 Aug 2007)
@ToDate nvarchar(25)=null, --date format is like DD MON YYYY(12 Aug 2007)
@WeekDays nvarchar(55)=null , --By default 0 is send for All days and we are using 1 for SUNDAY ,2 FOR MONDAY like ...UPTO 7 FOR SATURDAY
@AllRooms bit=null,
@SingleRoom nvarchar(10)=null,
@ByGroup nvarchar(10)=null,
@byAreaFrom nvarchar(10)=null,
@byAreaTo nvarchar(10)=null
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Query nvarchar(MAX)
SET @Query='SELECT DISTINCT tblChargeSummaryHistory.MonthYearStamp,
tblRooms.RoomNumber, tblMinibars.MinibarDisplayName, tblChargesDetailHistory.ChargeDateTimeStamp, tblChargesDetailHistory.Quantity,
tblChargesDetailHistory.ProductCategoryName, tblChargesDetailHistory.ProductName,
''Mode'' =CASE
WHEN tblChargesDetailHistory.Source =0 THEN ''Charge''
ELSE ''Adjustment''
END,
''Source'' =CASE
WHEN tblChargesDetailHistory.Source =0 THEN ''Minibar''
ELSE tblChargesDetailHistory.UserName
END,
''PMS Interface''=CASE
WHEN (tblChargesDetailHistory.FlagChargetobeSent=1 and tblChargesDetailHistory.FlagChargeSenttoPMS=1 and tblChargesDetailHistory.PMSInterfaceStatus=1)
THEN ''OK''
ELSE ''No Interface''
END,
tblChargesDetailHistory.SellingPriceWithoutTax AS ''Price(Exc.Tax)'',
tblChargesDetailHistory.Tax1 + tblChargesDetailHistory.Tax2 + tblChargesDetailHistory.Tax3 + tblChargesDetailHistory.Gratuity AS ''Taxes & Gratuity'',
tblChargesDetailHistory.SellingPriceWithoutTax + (tblChargesDetailHistory.Tax1 + tblChargesDetailHistory.Tax2 + tblChargesDetailHistory.Tax3 + tblChargesDetailHistory.Gratuity)
AS ''Price(Inc.Tax)''
FROM tblChargeSummaryHistory INNER JOIN
tblMinibars ON tblChargeSummaryHistory.MinibarID = tblMinibars.MinibarID INNER JOIN
tblChargesDetailHistory ON tblMinibars.MinibarID = tblChargesDetailHistory.MinibarID INNER JOIN
tblRooms ON tblChargeSummaryHistory.RoomID = tblRooms.RoomID AND tblMinibars.RoomID = tblRooms.RoomID AND
tblChargesDetailHistory.RoomID = tblRooms.RoomID'
IF(@Date IS NOT NULL)
BEGIN
SET @Query=@Query+' WHERE tblChargeSummaryHistory.MonthYearStamp<'''+@Date+' 11:59:59 PM '' and tblChargeSummaryHistory.MonthYearStamp>'''+@Date+' 12:00:00 AM '''
END
ELSE IF(@MonthDate IS NOT NULL)
BEGIN
SET @Query=@Query+' WHERE DATEPART(year,tblChargeSummaryHistory.MonthYearStamp)=DATEPART(year,'''+@MonthDate+''') and
DATEPART(month,tblChargeSummaryHistory.MonthYearStamp)=DATEPART(month,'''+@MonthDate+''')'
IF(@Weekdays IS NOT NULL)
BEGIN
SET @Query=@Query+' AND DATEPART(weekday,tblChargeSummaryHistory.MonthYearStamp) in('+@WeekDays +')'
END
END
ELSE IF(@FromDate IS NOT NULL AND @ToDate IS NOT NULL)
BEGIN
SET @Query=@Query+' WHERE tblChargeSummaryHistory.MonthYearStamp between '''+@FromDate+' 12:00:00 AM '' and '''+@ToDate+' 11:59:59 PM '''
IF(@Weekdays IS NOT NULL)
BEGIN
SET @Query=@Query+' AND DATEPART(weekday,tblChargeSummaryHistory.MonthYearStamp) in('+@WeekDays +')'
END
END
IF(@AllRooms IS NOT NULL)
BEGIN
SET @Query=@Query+' '
END
ELSE IF(@SingleRoom IS NOT NULL)
BEGIN
SET @Query=@Query+' and tblRooms.RoomID=(select DISTINCT RoomID from tblRooms where RoomNumber='''+@SingleRoom+''')'
END
ELSE IF(@ByGroup IS NOT NULL )
BEGIN
SET @Query=@Query+' and tblRooms.RoomID IN (SELECT RoomID FROM tblRoomGroups WHERE GroupID=(SELECT DISTINCT GroupID FROM tblGroups WHERE GroupName='''+@ByGroup+''' )) '
END
ELSE IF(@byAreaFrom IS NOT NULL AND @byAreaTo IS NOT NULL)
BEGIN
SET @Query=@Query+' and tblRooms.RoomID IN (SELECT DISTINCT RoomID FROM tblRooms WHERE RoomNumber>='+@ByAreaFrom+' AND RoomNumber<='+@ByAreaTo+' )'
END
exec(@Query)
SET NOCOUNT OFF;
END
Hi All,
As the thread title state, I was wondering if it is possible to alternate the list table row colors between 2 colors. Just wanted to make it more presentable when viewing.
Regards,
Fadzli
Does anyone know if it's possible int sql 2000 reporting to change the color of an alternating item, similar to a datagrid in asp.net?
View 1 Replies View RelatedHello,
Im trying to embedd a picture into my detail table rows to have a dynamic bar graph happening with data from a column called winbacks.
1.So Ive created the embedded 'bar' image
2. Ive inserted the image into the row and under the image properties i have put under the padding
=144 * (1.0 - Fields!Winbacks.Value / Max(Fields!Winbacks.Value, "dataset1")) & "pt"
This part is working....and the image is stretching accordingly to scale.
I would now like to put in a condition to use a different image OR write some text in the row field if the Winback.Value is the highest in the table for that row...ie write ''top gun'' on top off the bar image
Im not sure if you can write text and have the image appearing but this would be ideal...
so Iam instead trying to create an image with the text and when the winback value is the highest use that image ELSE use the normal image.
Can someone please help with how to do this
thanks
Hey everyone,
I know that you can make an expression that will make it one color if a certain condition is met and a different one if it is not but is there anyway to make it so that if a number is less than another it's one color, if it's greater it's a different color and if they're equal it's a third color? Thanks for the help.
-Keith
Hello :
I want to use a style sheet, in a .RDL file, that is instead of having that:
<BackgroundColor>#336cad</BackgroundColor>
I want to put:
<BackgroundColor> class = « my color » </BackgroundColor>,
And if it is possible, how I make for connected the .RDL and the .CSS.
Thank's.
Hi Guys..
Can anyone tell me how can i make a column chart bar in two different colors.. acutally i have different teams in a table and each team as assigna a traget to achieve.. i want to present that each team in the chart with their column bar... but as i have two field target and achieved.. so i want a single bar wihich will be into two color Target and achive..
|
| | | --- This is total Target
| | |
| | | --- This much they have achieve....
|___________ |__________|
Thanks....
Hi everyone, I am trying to get this to work, but I know its all screwed up. I want Fields!PERCENT_OF_STD.Value to display red if its less than 100% or greater than 200%. If its neither, then just be plain black. This is what I came up with:
=(Fields!PERCENT_OF_STD.Value >= 200%, "RED", (Fields!PERCENT_OF_STD.Value <= 99%, "RED"))
Thanks,
Abz
Hi All,
i have a field which stores the related RGB values for each record
I need to set programatically the background color for some objects in the report using the RGB value stored for the record.
how can i convert the rgb value to color and then set the background color for the report object. ?
Please Help
Thanks In Advance
sud
Hi,
Not sure what I did wrong to this code. What I would like this code to produce is, if any number is less than 0 (negative) than it should be red, if it's greater than 0, it should be black. Somehow it comes back red even though it's a positive number.
=iif(Fields!balance.Value < 0,"red","black")
1,106,666
472,169
-61,991
680,138
101,507
83,670
19,673
17,649
2,344,837
I am trying to do something where I say look through the row. When you come across the word "Start" color that box green and color all other boxes to the right in that row green as well until you come upon the word "stop". Is this possible? If I am not making sense just let me know and I will try to explain better. Thanks in advance for any help that I get.
View 3 Replies View RelatedHello,
My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?
Michael
I have a matrix with three subtotals -- I want to be able to have the farthest column go from this with the far right columns in black
MUNCH$
MEAL-15
5
0
1
8
9
45.00
MEAL-19
5
0
2
4
6
30.00
MEAL-19 TT
5
0
1
0
1
5.00
MEAL-BLOCK155
5
0
1
0
1
5.00
Tender Total
0
5
12
17
85.00
Day Total
0
375
400
775
843.00
Terminal Total
223
1274
973
2470
2,615.68
to this with the far right columns the same color as the subtotal-- I now I probobly need to use the inscope function but cant seem to get it right
MUNCH$
MEAL-15
5
0
1
8
9
45.00
MEAL-19
5
0
2
4
6
30.00
MEAL-19 TT
5
0
1
0
1
5.00
MEAL-BLOCK155
5
0
1
0
1
5.00
Tender Total
0
5
12
17
85.00
Day Total
0
375
400
775
843.00
Terminal Total
223
1274
973
2470
2,615.68
thanks in advance
kam
Hi,
I am using toggle visibility feature in one of my reports and I am trying to change the background color of some cells when I toggle the view. Please help, any help will be appreciated.
Thanks,
-Rohit
Is there a way in SSRS to conditionally set the color of a column?
I want to do something like:
=IFF(some condition, Color(Fields!Date, "Green"), Color(Fields!Date, "Red"))
I am having a problem setting the colors of the bars in a bar chart. It seems like it would be the simplest thing, but apparently it's not.
The "series" is grouped on whether or not the value is positive -- if so, the bars are blue (by default) and if not, green (by default). I want to change it so the positive color is blue and the negative color is red.
I found that I can change ALL the bars to one color by going to chart properties, Data tab, Values Edit, Appearance tab, Series Style, Fill. There I set the color to red and ALL the bars became red. But this is not what I want.
I tried using a conditional statement like IIf(Fields!IsPositive.Value=True,Blue,Red) for the color, but (not surprisingly), it told me I hadn't defined Blue and Red.
Does anyone know exactly how to do this?
I made a bar chart with the default color green and blue,
now I want to change it to red and blue.
How can I do this?
I am working with a report created by someone else using SQL Reporting Services. In layout view the background for the body of the report is set ti transparent; however, when I preview the report using print preview the background or margins of the pages are appearing as black - text boxes, tables, etc. appear according to the properties that have been set. As soon as I change the background color to say white the print preview looks fine. Is this normal or is there a setting somewhere that controls this?
View 3 Replies View Related
Need to be able to change the color of the columns red for negative values and Green for positive-- Im thinking that this will have to be a custom code scenario and not a expression-- any suggestions??
kam
Below is the pice of code that I use to produce results that look like this
[4] [5] [1]
what I would like to do is is make it look like this:
[4] [5] [1]
Basically anything that >3 = Green
= "[" & CStr(Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "Y", 1, Nothing))) &
"] [" & CStr(Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "N", 1, Nothing))) &
"] [" & CStr(Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "NA", 1, Nothing)))& "]"
Thanks,
Rick
Hi!
I 'm working whit a matrix.
I want alternate the background color of rows. I did with table, but I don't Know how do I do with matrix. I desire something like this:
column1
column2
row1
data1,1
data1,2
row2
data2,1
data2,2
row3
data3,1
data3,2
Please, if somebody can help me
Thanks
I want to send out an email and the email body contains a table with data. I am using SQL to create the HTML table and to populate values inside the table. Below is the code I have so far
DECLARE
@HTML NVARCHAR(MAX)
;
IF (SELECT
COUNT(*)
from Employee])
!= 0
[Code] ....
But I am having trouble generating alternative colors for each row (tr:nth-of-type(odd) is not working for me)
Below is what the table should look like ....
I have a Matrix and in the total on the last row i want use conditions for the color on the background , i'm usign the option Subtotal but i cna't read the value for the subtotal for create my conditions , some body now how i will aprecciate
thanks
I have a string in which I am combining several fields. Is there a way to add formatting to the string as well
="Baud: " & Fields!BAUDRATE.Value & " DL Status: " & Fields!COMMSTATUS.Value
Example, I want my fields to appear in bold and string in normal.. I can't do this in an individual textbox due to space constraints
I followed the instructions and the textbox named Color did indeed display alternate colors on the odd rows.
However, when I tried to propogate the color to the whole row using the expression =ReportItems!color.Value for the value of the backgroundcolor property, it was ignored.
So I tried some custom code:
Public Function GetColor()
Dim retValue as String
retValue = Me.ReportItems!Color.Value
return retValue
End Function
The syntax parser didn't like ReportItems either.
I first tried it without the Me object and I got a message about requiring an object so I tried Me.
Has anyone got another idea?
Thanks,
IanO
So I have created a chart in my report that counts the number of transactions by day. Each day in a month is a series. Now when I view the report, the series line is different color as expected until I hit the 17th, then the color associated with the line repeats. I.e. the 1st and the 17th are the same color line, the 2nd and the 18th are the same color...etc.
Does anyone know how to break the color limitation quandry?
Thanks.
Hi SQL experts
How can I make charaters change to color such as red if some condition happen
in a column of database tables?
Using IF.... function?
Thanks
Daniel
Hi,
I have a problem with a conditional format of the Color property in a matrix report. When the value of the textbox is greater than 0, the color should be Red otherwise it should be Blue. This is implemented via an IIF statement and works perfectly in Preview in Visual Studio 2005.
When the report is deployed, the formatting appears to be ignored and all values are the default value of Black.
Anyone else experienced this problem and, if so, is there a workaround?
Thanks in advance