So it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to ...
... of manual process considering when I did this, it didn't properly understand recurring events. My workaround for this was to copy the recurring event to the SharePoint calendar, then from within SharePoint ...
... values.
Additional
Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE:
SOUNDEX('Data Not Yet Available') ...
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum:
Quick Count
=INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&"")))
...
... AS WeDate
-- yields
-- 2012-04-29 -- this Sunday
-- 2012-04-29 -- this Sunday
-- 2012-04-29 -- this Sunday
Other Searches
These didn't get me very far until I decided to write this article:
DAYOFWEEK(myDate, ...
... to null the first query and make sure it didn't return the errors "no data found" and send this to the second query:
-- the same query but which doesn't fail the procedure :)
SELECT
NVL(
...
...
3. Add an SSRS parameter
Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them)
4. Add a ...
... the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good.
Aim / Objective
The plan will be to replace the default "" with a custom null ...
... want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources ...
Quick Reminder
I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query.
The Situation
We ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.