473,889 Members | 2,216 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Reports. Changing dataset schema

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.c om 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 3435
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********@yah oo.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.c om 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
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******* *******@TK2MSFT NGP10.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********@yah oo.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.c om 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
PiRX
1 New Member
Had similar problem and solved it with those steps:
1) Set location/replace
2) Verify database

it looks like both steps are needed.
Jul 27 '06 #4

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

Similar topics

7
4044
by: Phin | last post by:
I need your HELP! I've seen all the posts on using Crystal Reports within vs.net (vb.net) and changing a SQL query at runtime. When I tried to pass in a dataset into the crystal report at runtime, the report still showed the results from the default query (from within the Crystal Report). Then I tried the XSD solution where you define a dataset (that mataches the database and the Crystal Report) and have the Crystal Report use this....
4
6929
by: LL | last post by:
I am looking for online Crystal Report articles or VB samples to accomplish the following scenario. (In .NET Windows application) 1) User downloads an Xml document to local computer. 2) When Preview button is clicked, Crystal report will format the Xml document into reports and display them to the user. Thanks for your help.
3
3056
by: Michelle Stone | last post by:
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...
4
2505
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, when a report is opened it prompts me to input the parameters values . But, in order to incorporate this report to my application, I have 3 quetions: 1- How can I send the parameters from my form directly (so there will be no prompt)? 2- How can...
1
1411
by: Brad Allison | last post by:
Okay, after spending the past 4 1/2 hours trying to figure this out I am getting some answers but I am also getting very frustrated. And again, if this is the wrong forum to post to I apologize. Why can I not use Crystal Reports to show data from a simple dataset? The problem I have is that when the report tries to access the data, I get a database login screen. It was suggested I use ODBC instead of OleDB (as I have been using - it...
5
3227
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? i've tried creating a dataset and filling it with the data from a mysql query, but it still does not show up in the wizard. i have also tried to create fields and import data to them, but there seems to be no way of accessing the crystal report...
4
1715
by: BrianDH | last post by:
Hi I am working on a C# Windows Application that builds an invoice (CR) converts to PDF and attach to email one at a time. This works untill my invoice count get over 40 to 50 invoices then I start getting errors. The errors vairy. sometimes IO sometime "unable to load report". Has anyone here had a need to creat reports in mass?
3
5419
by: Thomas Schremser | last post by:
Hi everybody! I'm using the full version of Crystal Reports XI (Version 11.0.0.1282) and Visual C# 2005 Express Edition. I want to create a report which should later be populated with data from a DataSet. Since my version of CR isn't integrated in the Express Edition of VS I'm unable to create a report without connecting it to an existing data source - in my case a SQL Server 2000 database. And that's where my problem starts: no...
2
446
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 interested in using crystal reports as a web based reporting tool to get data out of a sql server database and we have always created our own bespoke reporting tools but this particular client wishes to go down the crystal reports route. 1) We...
0
9961
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9803
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11187
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10783
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10439
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9598
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7991
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
2
4248
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3252
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.