Groups | Blog | Home
all groups > sql server reporting services > august 2005 >

sql server reporting services : problems with updating datasets in visual studio .net



Limor Bellison
8/31/2005 11:23:03 PM
Hi,
I have a strange problem since yesterday.
I'm trying to change datasets in my project and I save changes. when I close
the Report and open it again I see that the changes where not saved. Also
the visual studio keeps getting stuck and I have to close it and open it
again.
I have noticed that if I change the query string from the Dataset Properties
window, it does save it.
Since yesterday everything worked properlly, I didn't installed any thing or
make any changes. I tried to do the same thing in another computer in a new
project, and I have the same problem there. Also when I make changes in a web
application in the visual studio, there are no problems.

I'm really desprate here,
can you help me?

Thanks,
daw
9/1/2005 6:20:04 AM
I don't know if this is what your problem is, but I noticed that when I
change a dataset from the Data tab, I click on the Layout tab (which shows
the * next to the name to show that it's changed) and then click Save. Since
I've done that I haven't seen a problem with dataset changes not being saved.
Also, if you click Run from the Data tab, leave the result set displayed and
go to another application for awhile, eventually Visual Studio pops up the
same window that Enterprise Manager does having to do with the result set
(can't remember the exact message). Sometimes a separate window pops up from
Visual Studio with the message, sometimes Visual Studio just hangs. That's
probably what you're seeing.
Hope that helps!

[quoted text, click to view]
Bruce L-C [MVP]
9/1/2005 8:31:50 AM
This is definitely the route to go. Sometimes when you change a dataset the
designer does not recognize that a change was made so it does not get saved.
Going to layout and clicking the save button resolves this problem.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Limor Bellison
9/3/2005 11:08:01 PM
Hi,
I mannaged to overcome the saving problem by changing the dataset from the
"edit selected dataset" window. but I still have problems with visual studio
getting stuck, it happens unexpetedly after I change the dataset.

Thanx,
Limor

[quoted text, click to view]
Bruce L-C [MVP]
9/4/2005 12:00:00 AM
Where are you doing this from? Is it from the report wizard?

Once you have the report designed and you want to modify the dataset
definition then you just go to the data tab. There is either a graphical
design tool or you can switch to generic (2 pane versus the 4 pane). To
switch to generic designer you click on a button that is to the right of the
....


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Limor Bellison
9/4/2005 11:01:01 PM
Hi,
My rport is allready designed and I modify the dataset from the data tab by
the generic designer.

Limor

[quoted text, click to view]
Bruce L-C [MVP]
9/5/2005 9:54:08 AM
Is this going against a stored procedure or are you inputting the query
directly. Is there any pattern? Are these very large or complicated queries,
lots of parameters?

One of the things that happens when you modify the query is RS tries to get
the new field list. If you have a query that this happens with routinely
then you can directly modify in the RDL. Make a copy first before you do
this. Then you do a view, code (I think, I am at home and don't remember the
menu to view the RDL).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button