Viewing 9 posts - 46 through 55 (of 55 total)
Set your defaults as below:
Start
=DateAdd(DateInterval.Year, -1 , DateSerial(DatePart("yyyy",Today), 1, 1))
End
=DateAdd(DateInterval.Day, -1 , DateSerial(DatePart("yyyy",Today), 1, 1))
The DateSerial() determines the first day of the current year. Then either subtract one year...
December 16, 2015 at 8:20 am
Can you do with an expression in the Naf_Eco cell where you format the output, something like
=Naf_Eco + " " + Libel_Naf_Eco
I guess it would depend how...
December 7, 2015 at 8:14 am
Here is one way to calculate the last day of the quarter (untested):
=DateAdd(DateInterval.Day, -1, DateAdd(DateInterval.Month, 1, DateSerial(Parameters!Yr.Value, Parameters!Qtr.Value * 3, 1)))
It constructs the first day of the quarter ending...
December 4, 2015 at 11:51 am
How about this:
=IIf((ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value) <> 0, (ReportItems!qty_complete.Value/(ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value)), 0)
December 3, 2015 at 7:49 am
You cannot connect to the data source, probably need to adjust the authentication/credentials that are used for the connection.
December 2, 2015 at 8:12 am
I use 2012 so I don't know if this works in 2008. Go to the properties of the tables and set the PageName property to what you want the...
November 11, 2015 at 8:01 am
I haven't done exactly what you are doing but here is a possible solution.
Change the Groups area at the bottom of the screen to 'Advanced Mode' - there...
September 18, 2015 at 8:02 am
Make sure you set the color value in the else part. Here is code I use to set the background color for a row:
=IIf(Parameters!Program.Value = "ALL",
Switch(Fields!CurrentClub.Value = 1, "DarkGray"...
September 18, 2015 at 7:53 am
If I understand correctly what you want, you can have an expression for the image in the Image Properties. Something like below based on a parameter:
=IIf(Parameters!Database.Value = "CCDApp", "/CDMS/Images/CCD_Annual_TB_Screening_Questionnaire.png",...
September 2, 2015 at 8:13 am
Viewing 9 posts - 46 through 55 (of 55 total)