Viewing 14 posts - 16 through 29 (of 29 total)
Maybe it really isn't 0 in that textbox. You might have to use IsNothing instead of comparing to zero. Just adjust the IIf based on what is really...
December 31, 2015 at 9:24 am
Then just wrap it with IIf as so
=IIf(reportitems!Textbox103.Value = 0, 0, CDBL(reportitems!Textbox33.Value) / CDBL(reportitems!Textbox103.Value)
+CDBL(reportitems!Textbox34.Value) / CDBL(reportitems!Textbox103.Value)
+CDBL(reportitems!Textbox35.Value) / CDBL(reportitems!Textbox103.Value)
+CDBL(reportitems!Textbox36.Value) / CDBL(reportitems!Textbox103.Value))
Untested syntax but I think correct, It puts 0 is the...
December 31, 2015 at 9:01 am
Are you getting that because reportitems!Textbox103.Value is zero? You should us IIf to make sure that value is not zero before doing the calculation do you don't divide by...
December 31, 2015 at 8:29 am
Siten0308 (12/23/2015)
<httpRuntime executionTimeout="9000" maxRequestLength="900000" />
Are you changing this in the Report Manager or Report Server Web.config file, I think you want the Report Manager one which would be at...
December 24, 2015 at 8:15 am
That is still true. The closest I have been able to do, when the parameters are drop-downs is to use a query to populate the values. When they...
December 23, 2015 at 8:08 am
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 14 posts - 16 through 29 (of 29 total)