Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

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?    
0
fhcdaver
Asked:
fhcdaver
  • 4
  • 3
  • 2
  • +1
3 Solutions
 
mlmccCommented:
Did you try VERIFY DATABASE when editting the subreport?

mlmcc
0
 
fhcdaverAuthor Commented:
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.
0
 
mlmccCommented:
That is the purpose of VERIFY DATABASE to force Crystal to go and read the stored procedure and update it.

Have you tried logging off the database in Crystal
Close Crystal
Open Crystal and logon the database

mlmcc
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
fhcdaverAuthor Commented:
I've even tried shutting down the whole computer and starting up again!
But i have not tried that exact sequence.
0
 
mlmccCommented:
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
0
 
James0628Commented:
Could the subreport be using an old/different stored procedure?  Go to Database > "Set Datasource Location", open up the datasource under Subreports, open the Properties for the stored procedure and make sure the name is correct.

 If the name is correct, you could try using "Set Datasource Location" to change the datasource for the subreport, but just point it back to the same stored procedure, and then do a "Verify Database".  Or create a copy of the stored procedure, temporarily change the subreport's datasource to the copy, do a "Verify Database", change it back to the original stored procedure, and then do another "Verify Database".

 James
0
 
musalmanERP ConsultantCommented:
Adding James Comment:

Try to Update Sub Report separately. I mean Open Sub Report apart from Main Report in Crystal and then try to Update the Data Source.
0
 
fhcdaverAuthor Commented:
Hi guys,
I got detoured from this issue with another couple of fires. I will give the datasource within the sub a try.
Dave
0
 
fhcdaverAuthor Commented:
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.
0
 
James0628Commented:
Sorry we couldn't be of more help.

 James
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now