Dave Roger
asked on
Crystal Reports XI sub report will not update stored procedure
I have a report, that fires a sub report. The sub report's datasource is a stored procedure on a SQL Server 2008 database. It works fine.
Then I realize I need the stored proc to return additional data elements. So I add the new fields to the result set of the stored proc, and alter the stored proc in the database. I can run the stored proc in the database directly (via management studio). it works fine.
So I attempt to refresh the datasource, using the usual methods, and I just cant get the sub report's datasource to see the new columns.
In "normal Crystal", when I modify a table, and rerun, I get the "table XYZ has changed! Proceding to fix the report!" I can't get this to happen in this scenario.
Aside from rewriting the whole damn thing, what am I missing?
Then I realize I need the stored proc to return additional data elements. So I add the new fields to the result set of the stored proc, and alter the stored proc in the database. I can run the stored proc in the database directly (via management studio). it works fine.
So I attempt to refresh the datasource, using the usual methods, and I just cant get the sub report's datasource to see the new columns.
In "normal Crystal", when I modify a table, and rerun, I get the "table XYZ has changed! Proceding to fix the report!" I can't get this to happen in this scenario.
Aside from rewriting the whole damn thing, what am I missing?
ASKER
yes.
We also tried pointing the sub to another database.
the only thing we know works is that we change the sp to a new alias name, and re-work all the formulas, summaries, calculations, etc and basically rebuild the whole thing from scratch.
Even SAP's website says that. I just have such a hard time believing that this is the best answer.
We also tried pointing the sub to another database.
the only thing we know works is that we change the sp to a new alias name, and re-work all the formulas, summaries, calculations, etc and basically rebuild the whole thing from scratch.
Even SAP's website says that. I just have such a hard time believing that this is the best answer.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've even tried shutting down the whole computer and starting up again!
But i have not tried that exact sequence.
But i have not tried that exact sequence.
I recall having an issue when the report is just opened. The connection seems to still be there so it doesn't really try to read the new one.
mlmcc
mlmcc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi guys,
I got detoured from this issue with another couple of fires. I will give the datasource within the sub a try.
Dave
I got detoured from this issue with another couple of fires. I will give the datasource within the sub a try.
Dave
ASKER
Hi,
So we tried verifying the sub as if it were independent, as well as verifying it all, setting datasource, etc. it just wouldnt work. Separately, the SAP blog suggested that the only thing to be done was to rewrite the entire thing, including all the formulas, etc. very disappointing. It's not the fault of the experts who tried to help, so I've apportioned the points accordingly. thanks for trying.
So we tried verifying the sub as if it were independent, as well as verifying it all, setting datasource, etc. it just wouldnt work. Separately, the SAP blog suggested that the only thing to be done was to rewrite the entire thing, including all the formulas, etc. very disappointing. It's not the fault of the experts who tried to help, so I've apportioned the points accordingly. thanks for trying.
Sorry we couldn't be of more help.
James
James
mlmcc