Viewing 15 posts - 31 through 45 (of 55 total)
I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it...
October 2, 2019 at 10:42 pm
You should be able to do this from a Logic App which would allow you to handle the error that the IR is already stopped. The Logic App could use...
July 16, 2019 at 1:59 pm
Reading your original post again and assuming something from the view names, I suspect that you want to swap the tables and put all_clients_view first. I am guessing that you...
May 8, 2019 at 1:36 pm
Try 'left outer join' instead of 'inner join'
May 7, 2019 at 8:28 pm
December 17, 2018 at 8:05 am
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...
October 5, 2017 at 4:32 pm
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...
October 3, 2017 at 1:24 pm
Brandie Tarvin (10/10/2016)
When there are extra columns within the database, the system will perform poorly.
Ummm. Hrrrr. So how do I remove those pesky extra...
October 10, 2016 at 12:35 pm
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...
March 21, 2016 at 8:02 am
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...
March 9, 2016 at 12:58 pm
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
Viewing 15 posts - 31 through 45 (of 55 total)