I am trying to create a data report using a command object from the dataenvironment. In my dataenvironment I have a command object, and a child command object set up. The parent object will contain header information, and the child object detail information for my report.
Both of these commands are linked to stored procedures, each with a single parameter that will be the same value when I run the report. My relation between the two commands is between the parent ID and the child parameter. When I try to show the report in my application I get an error that just says "General Error".
I got it to work when I had just one command object, so I know I had everything set up right. It also worked when I used the full table for the child instead of a stored procedure. But, the table is too big, and it takes too long to look up just one claim for this to work.
The problem is just when I try to create the child command as a stored procedure with a parameter. I need to know how to set the parameter for the child command so that it is the same as the parent's parameter? Any help would be greatly appreciated.