crystal report field explorer not showing newly added field

M

13

22

I have created a crystal report with datasets(xsd) , it is working fine. Then i added a new field in xsd and when i open the field explorer it do not show that field, i added source again through database expert but still it is not showing that field. Any other person faced such issue then please help.

Mastectomy answered 21/9, 2012 at 18:3 Comment(4)

Did you verify database? Also, sometimes it needs to create a new connection if you update the database. – Bea 21/9, 2012 at 18:4

This is going to sound silly: have you tried right clicking on the data source in the data serve window and hitting refresh? And then doing the same to the data source in the report? This has worked for me in the past. – Locket 21/9, 2012 at 22:22

Hello friends thanks for your support. The problem is solved by right clicking on database fields and then click on verify database. This updated the fields. I am wondering that it should be refreshed by adding datasource again. – Mastectomy 22/9, 2012 at 6:41

please note that if your query is returning columns with same names, only one of them will show in the field explorer. – Nutt 10/9, 2018 at 10:51

M

39

After waiting a lot for right answer and searching on internet i tried different options by myself and the problem was solved by right clicking on database fields and then click on verify database. If some one have some better option then please suggest.

Mastectomy answered 25/7, 2013 at 11:30 Comment(1)

This really helped but I couldn't find what you described in VS2013. Click The menu "Crystal Reports", then database -> verify database if you are lost like me. Make sure you rebuild your project after this. – Becalmed 31/7, 2014 at 14:2

U

5

I had the same problem and resolved it by adding parameter input and running the report from the designer. Crystal report popped up and said that it was fixing the report and refreshed the connection to the database for the most current fields.

Unroot answered 22/2, 2016 at 16:1 Comment(0)

S

3

I had a similar easy where Log on or Log off server and Verify Database wouldn't update the database fields list in Crystal Reports. The only thing that worked for me was to physically move the typed dataset to a different location. After creating a new connection within Set Datasource Location I updated the datasource and there it was....

Seka answered 7/1, 2016 at 14:18 Comment(0)

G

2

Don't forget to rebuild your solutions before validate your database.

Girlfriend answered 30/1, 2018 at 3:49 Comment(0)

C

1

Sap Crystal report has a problem while refreshing database changes to crystal report. I found this solution and it works like a charm:

First go to refresh data base option and then it will ask you to enter parameter values to the stored procedure
then without passing any values just press escape button it will suddenly ask you to confirm the changes made to database when you do it on second time it will say database is up to date

Conidiophore answered 7/7, 2016 at 8:9 Comment(0)

K

0

Restarting the Machine did the trick for me.

Kaleidoscope answered 28/8, 2016 at 9:57 Comment(0)

S

0

Some data types in dataset can't show in crystal reports try to change data types ( example don't use System.DateTimeOffset use datetime only)
Verity database in database fields

Shiny answered 20/12, 2016 at 9:44 Comment(0)

E

0

If your DataSet (.xsd) came by "Add Existing File" and not create one, then you will encounter a problem like mine. to fix this:

-Find the DatasetName.xsd file and all of its name-like file . Copy it EXCEPT THE DESIGNER (DatasetName.Designer.cs) and paste it somewher, you will re-paste it later

-In your VS. Delete the DataSet (xsd File) in your project by right click it in your Solution Explorer. This will delete any traces of file.

-Re-paste the files that you copied in the same location. Then in VS. And add the xsd file that you re-paste.

-Then you can now add columns. And it will update the DataSet, and also the Crystal Report will see the updated column

Reason: For i-dont-know-what-the-heck-happened, if you include the designer file then add it in you project, then you add columns to it, the VS will create new designer.cs file instead of overwriting the existing file. So the column registers only in original but the newly created one only recognized as valid (which is no traces of new added column)

Estep answered 21/4, 2017 at 11:24 Comment(0)

R

0

You can press F5 to see preview, if crystal report find out new fields it will verify all field in database, and your new fields will appear. Hope this will help you!

Renshaw answered 23/1, 2018 at 4:30 Comment(0)

W

0

Log off from server, then verify database, that did the trick for me!

Willwilla answered 10/6, 2019 at 16:8 Comment(0)

T

0

By just updating the entire datasource location did not work for me. I had to expand the source location and then update the individual table. Hope this helps someone.

Tellurion answered 24/6, 2019 at 11:25 Comment(0)

V

0

Right click REPORTDATASET then select Set Datasource Location.

click database files and select your existing *.xsd. then you will see REPORTDATASET. select it.

update
close

Now you will be seeing the new fields in your *.rpt :)

Vidovic answered 17/7, 2019 at 11:56 Comment(0)

O

0

I use the following technique:

Select datadese expert in crystal report
Select previous added datatable.
Press "<<" to remove it from reporting, its related columns are removed from report automatically.
Then select Project Data>>ADO .Net DataSets>> your updated dataset
Press ">>" to add and click the OK button.
New added field also shows in dataBase fields and then added in report.

Oralla answered 20/9, 2019 at 9:10 Comment(0)

Recommended topics

Hot tags