March 28, 2007 at 9:26 am
April 3, 2007 at 6:57 am
Anyone else running into this problem?
April 3, 2007 at 7:20 am
This was a little strange. I tried the subreport in all three areas with a hard coded parm value (ID) of 3 which is a valid ID so I didn't think the problem was with null values in the ID columns (the second grouping ID was based on an outer join). I changed the stored procedure to us an IsNull for the ID "IsNull(bID, 0)" and that fixed it.
From what I read I was lead to believe that the problem was with the parm value being passed but it seems to be that the problem was also somewhere else since I tested with valid hard coded parms with the same error.
So if you run into this problem don't try and test with hard coded parm values because it still will not work. Just change your query to make sure that all group levels have a non-null value.
Carl
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply