| Author |
Topic |
|
mani99
Starting Member
13 Posts |
 Posted - 2009-10-26 : 11:29:49
|
| Hi All,I get the following error anytime I drill down within a specific report: "Object type cannot be converted to target type". The report initially runs without any problems but the error only displays when drilling down.I have not seen this problem before and am struggling to find a solution. Any help would be very appreciated. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-26 : 11:39:11
|
| My guess is one of possibilities:1) there is a type in the name of the report you are trying to jump to. Even spaces matter. If someone created the report and it worked, then renamed the called reports name, you would get a similar error. or2) that the report you are jumping to is being passed a parameter that is invalid.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
mani99
Starting Member
13 Posts |
Posted - 2009-10-26 : 11:43:42
|
| Apologies, I didn't mean that the report would drill down into another report, what I meant was that the results table has toggles which can be expanded/collapsed. By default they are collapsed, it's only when the user tries to expand do they get the error message. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-26 : 12:12:12
|
| Ahhh, that IS different. Sorry...JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
mani99
Starting Member
13 Posts |
Posted - 2009-10-26 : 13:03:25
|
| Can anyone help with this? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-26 : 13:34:37
|
| In most every example I found when googled points to a value that expects to be a single value but is actually an array (or the reverse) Are you using a parameter to hide or alter a text box (or the entire row)?JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
mani99
Starting Member
13 Posts |
Posted - 2009-10-26 : 13:41:43
|
| The report uses a table and within the table there are 3 table headers which use a parameter to determine which row to toggle. The parameter is a simple "Select... union all.." query that allows the user to select what detail they would like to view in the report. The default being the Area grouped and showing totals. They can then decide to further expand this to show the next level of detail (Properties) and further expand these to show the lowest level (Units). The problem arises when they try to expand anything. If they choose to show the Property Level detail in the report parameter and then run the report, it runs without any problems. The error only occurs once the report has run and the user tries to expand any row. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-26 : 13:54:22
|
| Does that parameter by any chance happen to be defined as Multi-Select?JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
mani99
Starting Member
13 Posts |
Posted - 2009-10-27 : 06:54:09
|
| The exact select statement is:select ViewValue = 0, ViewLabel = 'Default View'union allselect ViewValue = 1, ViewLabel = 'View Properties'union allselect ViewValue = 2, ViewLabel = 'View Units'And in the visibility tab within properties for each header, an expression is used for the Initial Appearance of the Toggle: (Parameters!View.Value >= 1)Edit to say: The above expression is altered for each header, the top being 1 the next being 2 and so forth. |
|
|
|
mani99
Starting Member
13 Posts |
Posted - 2009-10-29 : 07:08:15
|
| Anyone who can help? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-29 : 10:38:39
|
| Does that parameter by any chance happen to be defined as Multi-Select? |
|
|
|
mani99
Starting Member
13 Posts |
Posted - 2009-11-05 : 06:33:55
|
| No, the parameter is a simple drop down and not a multi-select. |
|
|
|
|
Object type cannot be converted to target type