Try 'left outer join' instead of 'inner join'

Interesting to come across this today, little behind on these emails.  Easy to answer because we just ran into this in our production application a couple of weeks ago and...

An update: I went back and created a subscriber to another SQL Server 2012 instance (so both Publication and Subscription were on the same version of SQL Server) and everything...

Brandie Tarvin (10/10/2016)

Ummm. Hrrrr. So how do I remove those pesky extra...

Have the AS/400 developers look at the field definitions with DSPFFD command. It sounds like they may be defined with a CCSID of 65535 which means it is hex...

Does the report have parameters that get their available values from datasets? If so, those datasets have to be populated when it loads. That could explain why it...

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...

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...

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...

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...

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...

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...

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...

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...