Hello,
I've enabled the 'Month', 'Year', and 'Quarter' time hierarchies in a date/time object. My issue is that I can't pass the 'Year' value from a parent to child report. I can pass the 'Month' as well as all other values successfully. I've singled out the 'Year' object and the error message is
Internal error occurred: The query cannot run because the prompt 'Year' contains an invalid numeric value. (Error: WIS 10705)
Here is the hyperlink I'm using
="<a href=\"../../opendoc/openDocument.jsp?iDocID=AaJbGnFIKX9Gky4tnap1uTM&sDocName=Link+-+Test+Open+Year&sIDType=CUID&sType=wid&sWindow=Same&lsSYear="+[Year of Date Opened]+"\"target=\"_blank\">"+""+[Ticket Count]+"</a>"
Any ideas?
Thanks,
Carter