hog

OK, in my case it works as I modify the SQL in the dataadapter to pull in the new fields. I generate the dataset then report design view, onto field explorer, verify database and it works?

In your report designer view, click on Field Explorer, right click on Database then select verify database. If you have made changes it will tell you the database is out of sync and allows you to resysnc it. If you make changes then do this but it says it can't find any changes then close .NET down and start it again and it will detect the changes. Works for me :-)

I have a report that uses a dataset that takes fields from table A plus 1 field from table B. If I display the rows within the dataset it clearly shows all required data is retuned. If I then open a report based on all the fields in the dataset from table A the report opens OK. If I then include the one field from table B I get a message box simply stating crystal reports engine error. If I remove the field from table B the report opens ok. Any ideas? Thx

I do it another way. I have a dataset and dataadapter on my report form which I use in design time. I modify the select query to bring in the required new fields, veryify the database and the fields are there.

see my post in the general section re this same problem for the answer

Sorted: Field Explorer -> Database Fields -> Right Click table -> Verify Database

I have created a report based on a dataset in order to get the underlying report to up and running. The report then uses a dynamic dataset at runtime to populate its fields based on user selection. I now need to add other fields but I see that the fields I can choose from in design mode are restricted to those in the original dataset. If I update the report to point to a modified version of the original dataset I loose all formatting on the report. Is there a way to add fields at will without buggering the whle report? This is very staright forward in Access report writer but cannot work out how to do it in Crystal reports?

I am getting into the crystal report lack very nicely.....I think:D However I cannot seem to remove status bar from Crystal Report viewer. All other properties seem to be abalt to be set but can't find this one? I do not want the report to show the status bar displaying current page, total pages and zoom factor. Any ideas??:confused:

My application uses a MDI Parent form to display 8 other forms. I have a boolean flag in place so that only one instance of each form can ever be open at a time. If form A is opened first then B, C and D are opened then currently the user needs to select form A from the Window menu to bring it back on top of C and D. Clicking it's button results in no action as the flag says it is already open. Is there a way to link the Windows menu event to the forms open button so that if like above A, B, C and D are open and A is behind B, C and D then by clicking the button A will be brought to the top? I tried TopMost but that dd not work? Thx

Can anyone recommend a good source of help to get up to speed on using crystal reports .net? I'm fluent with Access reports but cystal reports is somewhat alien to me?? Thnx

I think you'll find just checking to see if it is true or false will suffice

SAMs Teach Yourself VB.NET in 21 Days SAMs Database Programming With VB.NET and ADO.NET

try it this way: Dim cmdIns = New OleDb.OleDbCommand() cmdIns = New OleDb.OleDbCommand(sql, conn) I sometimes get error like this and find splitting the lines into two works

I can runn the MSDE ok on my laptop the problem I have is trying to connect to an instance of the MSDE running on another machine

Not sure this is what I'm after, thanks. I already know how to connect to databases using a connection string, what I can't do is create a connection to the MSDE instance running on the PC from my laptop as .NET retports it can't find the PC on the network probably cos the server service is not running on it. But other posts say you do not need the server service running in ordero make use of MSDE

isn't it simpler to do: IF IsNumeric(textbox4.Text) ANDALSO textbox4.length = 10 THEN Button2.Enabled=True ELSE Button2.Enabled=False Endif

Yep, tried it although I'll read your second web link to see if there is any help there. I had my deployment setup working ok in that if it detected the .NET Framework was missing it started the bootstrapper exe file. It is this file that report the error.

Here is the situation: One PC with MSDE running but not the Windows 2000 server service. Visual Studio .NET running on my laptop on the same network as the PC above. Question: How do I create/connect to the PC from my laptop to create or connect to a database on the PC? I've have tried using Data Connections and SQL Servers within the .NET IDE with no joy. Is there some special way to do it?

OKey dokey :-) Yes I mean to create the database within the Visual Studio .Net Server Explorer Yes I intend to have the MSDE service running in order to allow access to the SQL database I was asking do I need the Windows Server service running as well as the MSDE in order for users to connect to my database or do I just need the MSDE running? Derek you have understood me correct. Thanks to you all for you comments :-)

yeah, I have tried using that but it errors every time I try to use it? Even tried downloading it again in case the first was corrupt, but no joy!

I currently have a trial version of an application released to users which connects to an Access2002 database backend. As I am still developing the application I have been investigating the possibility of moving it over to a SQL Server database using MSDE as I am reading that it is more efficient. I have little knowledge of SQL Server or MSDE so was wondering could someone just clarify a few points if possible. If I create a version of my Access2002 database as a SQL Server database using the server explorer within .NET do all I need to do is this: 1. copy the database to a machine which has MDSE running on it 2. modify my code so that it uses the SQL namespace objects rather than OLEDB 3. does the PC that will have the database and MSDE installed need to have the server service running? I am aware that there is a limit of having a maximum of ten user connecting to a PC with the server service running, to ensure Windows 2000 server is used for greater number of users. Therefore I assume the MSDE can operate without the server service running??? all help gratefully recieved... :)

Thank you dudes, the file I required was SQL2KDeskSP3.exe which has resolved my slammer problem. :-))

Well blow me!! I cannot believe it was that simple......THANKS :-)

I'm using this code to set an objects property to show if a po is internal or external, but am getting stuffed as it gets called twice, once for each control. This means even if I select external the form show internal. It's driving me nuts and I am possibly not seeing the wood for the tress but.........help?? Private Sub Radiobutton_CheckChanged(ByVal sender As Object, ByVal e As System.EventArgs) _ Handles radInternal.CheckedChanged, radExternal.CheckedChanged If Not blnRefreshingForm And Not blnFormLoading Then Dim ctlSender As Control = CType(sender, RadioButton) Select Case ctlSender.Name Case "radInternal" m_objContract.InternalPO = Me.radInternal.Checked Case "radExternal" m_objContract.InternalPO = Me.radExternal.Checked End Select Me.cmdSave.Enabled = True Me.cmdAdd.Enabled = True Me.chkDataChanged.Checked = True End If End Sub

when I build my setup solution it includes all the windows installer files which end up in the release folder. The .NET Framework runtime is in dotnetfx.exe available from the mS site. I was unable to get this to load automatically so a work around is to supply a readme file for the user to run dotnetfx.exe if they are informed that the .NET Framework is not present on their PC. I have an application deployment area on our server which has a folder in it to hold the dotnetfx.exe file so user need not go to the MSA site