I made stored proedure to pull out appliation summary data, then use Crystal Report to generate the report templates (both table and chart) all work well, I can get data from this template. However, I followed the procedures to add report template into IPCC Historial report client, it does show in report client, but it can't generate report, the error in log is:
Could not find the stored procedure.
I suspect this is database user priviledge issue, the user ID for Historical report client is authenticated by IPCC server, and doesn't have access to database, so there must be another user provided by IPCC that could run stored procedure in DB. I compared this stored procedure with others, didn't find the difference.
What else could I look to?
Wei
