... IS NULL THEN
v_returnedval := NULL;
ELSIF p_original_datatype='INT' THEN
-- Check Parameters and assign proper default values
IF p_original_range_1 ...
... to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function).
How?
$total_time =intval(intval($total_seconds)/ 3600).":";
$total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":";
$total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT);
// ...
... Fixing this resolved all 3 issues below!!!
Encountered Issues
ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly (ex: Parameter name = p_STUDENT_ADNAME, ...
... with CHAR(10) and although it displayed and printed properly, when saving as a PDF, CHAR(13) would return weird question mark symbols instead.
Bonus
All rows with this would be about 3 lines of ...
... to do the following:
We have our main report with a textbox that has the Action property: Go to Report / HouseKeepForm (our confirmation page) / With 2 parameters provided in the main report (note: ...
... the above it would all work:
Open your form in InfoPath
Go into Design mode
Go to "Controls" and add a Drop-down List Box to your form
Right-click it and select "Drop-down List Box Properties"
Under ...
... revisited solution below -> Just leave the "allow blank" option in the parameter properties unchecked
SSRS Report Revisted:
Had an issue where SSRS report parameters were not resetting to blank ...
... If the user is too quick with their mouseovers and mouseouts, then the GUI will sometimes leave the link as blue despite the mouse cursor not being anywhere near it.
Proper HTML mouseovers:
When ...
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.