Showing posts with label dataset. Show all posts
Showing posts with label dataset. Show all posts

Thursday, March 22, 2012

changing a stored proc dataset w/parameters

Hi, I changed a report to point to another dataset. Both the old and new
data sets are stored procs with parameters. The issue I'm getting is when I
try to preview the report it is still wants the old parameters. I changed
the dataset value in the table properties and hit refreshed in the data pane.
Any suggestions.Query parameters and report parameters are two different things. When you
are creating or modifying the dataset query parameters (or in your case
stored procedure) parameters are detected and report parameters are created.
The report parameters stick around unless you delete them. In layout view,
Report Menu->Report Parameters. Click on the parameter and delete it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lisa" <Lisa@.discussions.microsoft.com> wrote in message
news:799D404D-0742-4B2D-B708-49F566AFA9D9@.microsoft.com...
> Hi, I changed a report to point to another dataset. Both the old and new
> data sets are stored procs with parameters. The issue I'm getting is when
> I
> try to preview the report it is still wants the old parameters. I changed
> the dataset value in the table properties and hit refreshed in the data
> pane.
> Any suggestions.

Tuesday, March 20, 2012

Changes to table not reflected in report

Hi!

I usa a SQL server for my windows application project. I have created a Crystal report, using .NET dataset connections. I made changes to one of the tables used in the report, and I updated the dataset. I then opened the report and used the "Verify database" feature, but the changes are not reflected. This worked before in the same report with changes to the same table. It seems like it does not work in any of my reports (using different datasets).

I have spent a good hour searching knowledge bases and forums, but found nothing. Anyone here that can help me? (I'm a bit pressed for time, close to deadline and all)

Thanks in advanceHave you checked EnableSaveDataWithReport and made sure its set off (either thru the menu option) or thru your code? Hope this helps|||Also Open the report and Do verify database|||Hi!

Thanks for the answers. The problem is solved for the moment. It seems that the "Verify database" functionality always works after I have run the applikation, a build is not enough. But If I start the app and then try to do the changes it seems to work....

So I consider it a bug that its not enough to changes and save the dependant DS... but as long as I get it to work I keep on. =)