Skip to Content
0
Former Member
Mar 24, 2009 at 11:11 PM

Error passing 'Automatic Time Hierarchies'

22 Views

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