problems with updating datasets in visual studio .net

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,
LimorI 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!
"Limor Bellison" wrote:
> 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,
> Limor|||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
"daw" <daw@.discussions.microsoft.com> wrote in message
news:48C835F1-5BB3-4CEB-A969-73995D0F4F22@.microsoft.com...
>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!
> "Limor Bellison" wrote:
>> 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,
>> Limor|||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
"Bruce L-C [MVP]" wrote:
> 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
> "daw" <daw@.discussions.microsoft.com> wrote in message
> news:48C835F1-5BB3-4CEB-A969-73995D0F4F22@.microsoft.com...
> >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!
> >
> > "Limor Bellison" wrote:
> >
> >> 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,
> >> Limor
>
>|||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
"Limor Bellison" <LimorBellison@.discussions.microsoft.com> wrote in message
news:491F9403-8334-46BD-B5DB-0AD8268EFB95@.microsoft.com...
> 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
> "Bruce L-C [MVP]" wrote:
>> 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
>> "daw" <daw@.discussions.microsoft.com> wrote in message
>> news:48C835F1-5BB3-4CEB-A969-73995D0F4F22@.microsoft.com...
>> >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!
>> >
>> > "Limor Bellison" wrote:
>> >
>> >> 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,
>> >> Limor
>>|||Hi,
My rport is allready designed and I modify the dataset from the data tab by
the generic designer.
Limor
"Bruce L-C [MVP]" wrote:
> 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
> "Limor Bellison" <LimorBellison@.discussions.microsoft.com> wrote in message
> news:491F9403-8334-46BD-B5DB-0AD8268EFB95@.microsoft.com...
> > 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
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 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
> >>
> >> "daw" <daw@.discussions.microsoft.com> wrote in message
> >> news:48C835F1-5BB3-4CEB-A969-73995D0F4F22@.microsoft.com...
> >> >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!
> >> >
> >> > "Limor Bellison" wrote:
> >> >
> >> >> 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,
> >> >> Limor
> >>
> >>
> >>
>
>|||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
"Limor Bellison" <LimorBellison@.discussions.microsoft.com> wrote in message
news:3953B976-D223-44A9-AB2A-7113027A4122@.microsoft.com...
> Hi,
> My rport is allready designed and I modify the dataset from the data tab
> by
> the generic designer.
> Limor
> "Bruce L-C [MVP]" wrote:
>> 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
>> "Limor Bellison" <LimorBellison@.discussions.microsoft.com> wrote in
>> message
>> news:491F9403-8334-46BD-B5DB-0AD8268EFB95@.microsoft.com...
>> > 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
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> 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
>> >>
>> >> "daw" <daw@.discussions.microsoft.com> wrote in message
>> >> news:48C835F1-5BB3-4CEB-A969-73995D0F4F22@.microsoft.com...
>> >> >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!
>> >> >
>> >> > "Limor Bellison" wrote:
>> >> >
>> >> >> 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,
>> >> >> Limor
>> >>
>> >>
>> >>
>>