Viewing 15 posts - 2,536 through 2,550 (of 18,926 total)
lcarrethers (9/20/2011)
So your telling me=sum(Iif(trim(Fields!payrolcd.Value) = "SALARY" and trim(Fields!PAYRCORD.Value) = "SALARY", Fields!Untstopy.Value,0))
should work?
How do i trouble shoot that error
In the OUTPUT window you'll have the real error. Can't...
September 20, 2011 at 10:32 am
In the output window you should have something a little more usefull (yes I know it's annoying!).
September 20, 2011 at 10:20 am
Did we get you the 300 notification your requested? 😀
September 20, 2011 at 10:19 am
lcarrethers (9/20/2011)
That is what i have and all the results are errors?
Then it's a new error because it doesn't show any syntax error in my system.
September 20, 2011 at 10:11 am
Ninja's_RGR'us (9/20/2011)
=sum(Iif(trim(Fields!payrolcd.Value) = "SALARY" and trim(Fields!PAYRCORD.Value) = "SALARY", Fields!Untstopy.Value,0))
September 20, 2011 at 10:02 am
L' Eomot Inversé (9/20/2011)
Ninja's_RGR'us (9/20/2011)
What's up with the new signature Tom? It sure looks like french but I'm pretty sure it's not!
The subject of the song is never named...
September 20, 2011 at 9:59 am
=sum(Iif(trim(Fields!payrolcd.Value) = "SALARY" and trim(Fields!PAYRCORD.Value) = "SALARY", Fields!Untstopy.Value,0))
September 20, 2011 at 9:57 am
Sql monitor from red-gate
Or make a job and run tlog backups every 15 minutes or 5.
The only reasons I've seen log blow out if because of index maintenance or awfully...
September 20, 2011 at 9:50 am
That's how SQL makes a linked connection to excel. Never tried to figure out why.
I'm guessing it needs a terminator.
September 20, 2011 at 9:47 am
Actually over 16 months now, might be time for a revisit!
September 20, 2011 at 9:44 am
Gianluca Sartori (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Damn, you stole my evil QOTD :-D.That would have been a major complaint generator 😉
Uh! I'm trying to figure out what would SanDroid think of it...
He might...
September 20, 2011 at 9:43 am
Whole books have been writen on the subject and you have one of the best authors on the subject here. So if he doesn't know, then likely noone knows...
September 20, 2011 at 9:34 am
GSquared (9/20/2011)
Gianluca Sartori (9/20/2011)
L' Eomot Inversé (9/20/2011)
Gianluca Sartori (9/20/2011)
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
September 20, 2011 at 9:31 am
Try a master report with 2 subreports.
I think you can specify a pagebreak on the subreport item. If not just us a 1 pixel rectangle (has to be visible...
September 20, 2011 at 9:12 am
Viewing 15 posts - 2,536 through 2,550 (of 18,926 total)