Viewing 15 posts - 16 through 30 (of 47 total)
If the person needs access to every report, just grant the access at the "home" level. you can do this from the web interface.
August 19, 2009 at 10:21 pm
just a quick update: I failed to ensure that the main table in my test environment had the same indexes as in production. :blush:
After creating the indexes (which did...
August 19, 2009 at 4:12 pm
Thanks so much for the quick responses. I am somewhat familiar with Profiler, so I will take a look at that. Right now, I am running both versions...
August 19, 2009 at 10:37 am
If you really want it in the header or footer, you can make the textbox in the body hidden, and then create a textbox in the header/footer that refers to...
August 18, 2009 at 2:58 pm
If you are searching the rdl files in Windows Explorer, you may have the problem I had, where it wasn't searching the files. I used Method 2 from here,...
July 13, 2009 at 10:57 pm
Kit G (2/23/2009)
February 23, 2009 at 1:36 pm
GilaMonster (2/23/2009)
February 23, 2009 at 1:31 pm
Steve Jones - Editor (2/18/2009)
What features would really help you "high posters" here at SSC? Changes to the forums? the...
February 18, 2009 at 2:00 pm
FYI - If you use the abs function (or any expression, i think) instead of using the format property, the number will appear as text if the report is exported...
January 9, 2009 at 4:28 pm
Well, most importantly - in Dallas, TX, the wind is blowing NNW at 10 mph. It's cloudy and 62 degrees. 😀
I hope I was able to make an equitable...
October 16, 2008 at 1:58 pm
I'll try to spend some time comparing the two methods today or tomorrow. The data I posted yesterday was just a small sample, but since I'm working in dev,...
October 16, 2008 at 8:16 am
Thanks for the additional option - I'll give it a try. It looks like it would allow me to eliminate one of my temp tables (#DailyBalance), which would be...
October 15, 2008 at 2:12 pm
Seth,
Thank you!! That appears to work perfectly.
-Marianne
October 15, 2008 at 12:27 pm
Unfortunately, that won't work. #PointBalTotal has gaps in the dates (it shows the balance only for dates that actually had transactions), which is why I join to #DATE_DIM -...
October 15, 2008 at 11:57 am
Assuming the name of the column group is WeekStartDate, something like the following should work:
=iif(iif(isnothing(Sum(Fields!RMAs.Value,"WeekStartDate")),0,Sum(Fields!RMAs.Value)/Sum(Fields!RMAs.Value,"WeekStartDate"))=0,nothing,Sum(Fields!RMAs.Value)/Sum(Fields!RMAs.Value,"WeekStartDate"))
Note: the expression above is also eliminating divide by zero errors
Hope this helps!
-Marianne
September 30, 2008 at 1:01 pm
Viewing 15 posts - 16 through 30 (of 47 total)