473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Updating dataset in crystal reports

Thanks for your message

I tried again and again... but didn't work. Can u please detail the
exact steps to perform?

This is what I do. In field explorer, i right-click the dataset to
update. Then I click on SET LOCATION. When the list comes up, I
already have the same dataset as the "CURRENT DATASET" and I have the
same dataset in the tree control on the right as the default
selection. I just click on REPLACE and close the dialog. But the field
explorer still shows the same old dataset.

Anything I am missing? Thanks...

"Darrin J Olson" <da************@sio.midco.net> wrote in message news:<Oo**************@TK2MSFTNGP10.phx.gbl>...
My vote would be the same as number 2 below. I've done this numerous times
as I change the schema of my typed datasets. Be sure your new dataset is
coming up in the list to select...

-Darrin
"Michelle Stone" <mi********@yahoo.com> wrote in message
news:09****************************@phx.gbl...
Hi all

I recently changed the schema of a dataset (added one
field, and changed another field type from STRING to
DATE). I want this reflected in my Crystal Reports
Designer.

Please don't tell me to recreate the report as a lot of
work has already been spent on this report.

I will list the solutions I got from others on
groups.google.com newsgroups:

1. Verify Database : Doesn't work. Even found others
commenting that this just detects new tables, and not new
fields.

2. DATABASE/SET LOCATION: This supposedly worked for one
person on this newsgroup. But didn't for me. Or am I not
doing it correctly? When I tried to set the location to
the same location (and then clicking REPLACE) it loaded
the same old dataset

3. Restart Visual Studio.NET: Didn't work

4. Close and reload the .rpt and .xsd file : Didn't work

5. Log on/off the server : Didn't work

HELP! :-)

Regards

Michelle

Nov 18 '05 #1
3 3030
You might want to try copying your modified Dataset and naming it something
else, then replace it with the new one. I recently fought a login failure
problem for days before trying a different server name alias for the same
server, nearly drove me insane. In this case, the schema would not update
either - your case sound somewhat similar...

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

"Michelle Stone" <mi********@yahoo.com> wrote in message
news:6a*************************@posting.google.co m...
Thanks for your message

I tried again and again... but didn't work. Can u please detail the
exact steps to perform?

This is what I do. In field explorer, i right-click the dataset to
update. Then I click on SET LOCATION. When the list comes up, I
already have the same dataset as the "CURRENT DATASET" and I have the
same dataset in the tree control on the right as the default
selection. I just click on REPLACE and close the dialog. But the field
explorer still shows the same old dataset.

Anything I am missing? Thanks...

"Darrin J Olson" <da************@sio.midco.net> wrote in message

news:<Oo**************@TK2MSFTNGP10.phx.gbl>...
My vote would be the same as number 2 below. I've done this numerous times as I change the schema of my typed datasets. Be sure your new dataset is
coming up in the list to select...

-Darrin
"Michelle Stone" <mi********@yahoo.com> wrote in message
news:09****************************@phx.gbl...
Hi all

I recently changed the schema of a dataset (added one
field, and changed another field type from STRING to
DATE). I want this reflected in my Crystal Reports
Designer.

Please don't tell me to recreate the report as a lot of
work has already been spent on this report.

I will list the solutions I got from others on
groups.google.com newsgroups:

1. Verify Database : Doesn't work. Even found others
commenting that this just detects new tables, and not new
fields.

2. DATABASE/SET LOCATION: This supposedly worked for one
person on this newsgroup. But didn't for me. Or am I not
doing it correctly? When I tried to set the location to
the same location (and then clicking REPLACE) it loaded
the same old dataset

3. Restart Visual Studio.NET: Didn't work

4. Close and reload the .rpt and .xsd file : Didn't work

5. Log on/off the server : Didn't work

HELP! :-)

Regards

Michelle

Nov 18 '05 #2
my god... is that the only way out? changing dataset is a very common
thing. crystal decisions/microsoft not doing anything about this?
pathetic

"Jerry Boone" <je***@antech.biz.killspam> wrote in message news:<Po*******************@newssvr11.news.prodigy .com>...
You might want to try copying your modified Dataset and naming it something
else, then replace it with the new one. I recently fought a login failure
problem for days before trying a different server name alias for the same
server, nearly drove me insane. In this case, the schema would not update
either - your case sound somewhat similar...

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

"Michelle Stone" <mi********@yahoo.com> wrote in message
news:6a*************************@posting.google.co m...
Thanks for your message

I tried again and again... but didn't work. Can u please detail the
exact steps to perform?

This is what I do. In field explorer, i right-click the dataset to
update. Then I click on SET LOCATION. When the list comes up, I
already have the same dataset as the "CURRENT DATASET" and I have the
same dataset in the tree control on the right as the default
selection. I just click on REPLACE and close the dialog. But the field
explorer still shows the same old dataset.

Anything I am missing? Thanks...

"Darrin J Olson" <da************@sio.midco.net> wrote in message

news:<Oo**************@TK2MSFTNGP10.phx.gbl>...
My vote would be the same as number 2 below. I've done this numerous times as I change the schema of my typed datasets. Be sure your new dataset is
coming up in the list to select...

-Darrin
"Michelle Stone" <mi********@yahoo.com> wrote in message
news:09****************************@phx.gbl...
> Hi all
>
> I recently changed the schema of a dataset (added one
> field, and changed another field type from STRING to
> DATE). I want this reflected in my Crystal Reports
> Designer.
>
> Please don't tell me to recreate the report as a lot of
> work has already been spent on this report.
>
> I will list the solutions I got from others on
> groups.google.com newsgroups:
>
> 1. Verify Database : Doesn't work. Even found others
> commenting that this just detects new tables, and not new
> fields.
>
> 2. DATABASE/SET LOCATION: This supposedly worked for one
> person on this newsgroup. But didn't for me. Or am I not
> doing it correctly? When I tried to set the location to
> the same location (and then clicking REPLACE) it loaded
> the same old dataset
>
> 3. Restart Visual Studio.NET: Didn't work
>
> 4. Close and reload the .rpt and .xsd file : Didn't work
>
> 5. Log on/off the server : Didn't work
>
> HELP! :-)
>
> Regards
>
> Michelle

Nov 18 '05 #3
Have you tried it and did it work for you?

I still haven't proven this at a technical level, just at a frustrated
developer level.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

"Michelle Stone" <mi********@yahoo.com> wrote in message
news:6a**************************@posting.google.c om...
my god... is that the only way out? changing dataset is a very common
thing. crystal decisions/microsoft not doing anything about this?
pathetic

"Jerry Boone" <je***@antech.biz.killspam> wrote in message

news:<Po*******************@newssvr11.news.prodigy .com>...
You might want to try copying your modified Dataset and naming it something else, then replace it with the new one. I recently fought a login failure problem for days before trying a different server name alias for the same server, nearly drove me insane. In this case, the schema would not update either - your case sound somewhat similar...

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and Access

"Michelle Stone" <mi********@yahoo.com> wrote in message
news:6a*************************@posting.google.co m...
Thanks for your message

I tried again and again... but didn't work. Can u please detail the
exact steps to perform?

This is what I do. In field explorer, i right-click the dataset to
update. Then I click on SET LOCATION. When the list comes up, I
already have the same dataset as the "CURRENT DATASET" and I have the
same dataset in the tree control on the right as the default
selection. I just click on REPLACE and close the dialog. But the field
explorer still shows the same old dataset.

Anything I am missing? Thanks...

"Darrin J Olson" <da************@sio.midco.net> wrote in message

news:<Oo**************@TK2MSFTNGP10.phx.gbl>...
> My vote would be the same as number 2 below. I've done this numerous

times
> as I change the schema of my typed datasets. Be sure your new dataset is > coming up in the list to select...
>
> -Darrin
>
>
> "Michelle Stone" <mi********@yahoo.com> wrote in message
> news:09****************************@phx.gbl...
> > Hi all
> >
> > I recently changed the schema of a dataset (added one
> > field, and changed another field type from STRING to
> > DATE). I want this reflected in my Crystal Reports
> > Designer.
> >
> > Please don't tell me to recreate the report as a lot of
> > work has already been spent on this report.
> >
> > I will list the solutions I got from others on
> > groups.google.com newsgroups:
> >
> > 1. Verify Database : Doesn't work. Even found others
> > commenting that this just detects new tables, and not new
> > fields.
> >
> > 2. DATABASE/SET LOCATION: This supposedly worked for one
> > person on this newsgroup. But didn't for me. Or am I not
> > doing it correctly? When I tried to set the location to
> > the same location (and then clicking REPLACE) it loaded
> > the same old dataset
> >
> > 3. Restart Visual Studio.NET: Didn't work
> >
> > 4. Close and reload the .rpt and .xsd file : Didn't work
> >
> > 5. Log on/off the server : Didn't work
> >
> > HELP! :-)
> >
> > Regards
> >
> > Michelle

Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Colin Graham | last post by:
I have recently created a report in crystal(10) linking to a dataset as the datasource. I notice however that the fields available in the report all have STRING format and therefore i cannot change...
3
by: oscar | last post by:
is there a way of integrating mysql databases into the .net crystal reports? in the report wizard i have options for sql databases, but nothing for mysql. is there a plugin i'm missing for it? ...
0
by: Maqsood Ahmed via .NET 247 | last post by:
Hello, I was trying to create Crystal Report using a DataSet (notfilled with DataBase entries). DataSet contains some Tables. Butwhen I want to generate a Crystal report it doesn't showanything. I...
1
by: Doug Lim | last post by:
I have an ASP.NET application that I've developed using Visual Studio ..NET 2003 and I'm making use of Crystal Reports for .NET that's included to return reports back to the visitor's web browser...
4
by: touf | last post by:
hi, I'm using Crystal reports to generate a simple report in a VB.net windows application, I've defined all my stuffs (accessMDB,query, 2 parameters) in the report design, and it's working fine,...
3
by: VMI | last post by:
I know this may not be the best NG for this, but I feel you guys know more about this than any of the other NGs. I need to build several simple reports (over 50 of them and they get their data...
7
by: Jlo | last post by:
Hi, I have a c# winforms application. When I call the report file, it shows me all the records in the table. How can I make it to call only a particular range. i have the following code...
2
by: =?Utf-8?B?Um9zcyBNYXNvbg==?= | last post by:
Hi I am interested in using crystal reports for the first time but have a few questions that someone maybe able to help with before I get started. The background to my query is that a client is...
8
by: Brock | last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.