Recent content by DougNaf

I am running SQL 2016 and as part of our data testing and procedure, I restore the mdf and ldf from our backups. With our prior SQL 2008 I was able to use the attach option of Server Management with no problem. With SQL 2016 I receive an error 3415. Some documentation I read discusses an SQL...

I am trying to add some custom fields to a page 2 of the MS Outlook calendar. I am using MS Office 2016 and MS Exchange Server. I am successful when adding the fields, etc., but when I select publish form, provide a name, I get an error which is "Cannot publish the form. Network problems are...

I have a need to view domain users that are connected to an SQL Database. I know you can query and display number of users connected, but I would like to know the users. Thanks in advance for suggestions! Doug

I do not know for sure what triggers the history records, but I think it is the application (written in fox-pro). Actually the application is SAGE_HRMS.

The applicaion is HR and if I make the changes within the app, there is a history job record added. I am building info and want to update several fields, but do not want a history job record created for every employee. If I can export, edit the spreadsheet, then import to SQL table i can avoid...

I am using SQL2008 and want to export data from an SQL table to excel, make changes and import it back into the SQL table. How can this be done? IE I have a master file that has 20 fields, The key is EmpNo and of the 20 fields I want to export 4 fields to excel (and make changes). current...

Thanks! I tried tested both suggestions and both work GREAT!

I have results from a crystal report such as Number AppNo 123.44 100 222.66 100 456.44 100 095.00 200 105.00 200 109.11 200 088.00 205 099.02 205 887.11 205 i need to create a new column that has the top number from each AppNo: Number AppNo...

I am working on a thin client architecture and will be connecting to MS WIndows Terminal Server. I need to run Crystal Reports. Can someone provide me with the version that is needed to be installed on the Windows Terminal Server? Thanks for any information. Doug

Thank you for reviewing the 'suppress' steps. I went back thru the steps and this time everything worked! The formulas you suggested for the grand totals worked also. Thanks again for your help!!! Doug

On the main report I checked the format and made sure each fo the 3 sub reports had the line style left, right, top, and bottom at none. On each subreport I went to the section expert and for Report Header A, B, details and Report Footer,I put a check mark in the "suppress blank section"...

Thanks for your information. I tried the 'suppress blank section' that you suggested but it did not appear to work. You mention "What you CANNOT do is suppress the subreport object or hide or suppress the section it is in". I think that is what i am really trying/needing to do. The only...

I am using CR 9. I have a main program that calls 3 subreports. Each of the subreports send a unique key (trip #) and returns a $.$$ amount. On the main program I have the 3 subreports on a Group Footer #1a line. Under that (Group Footer #1b) I am displaying the amounts plus some other data...

I used the first example: Select Replace(YourColumnName, 'CO RD', 'COUNTY ROAD') From YourTable Then ran the statement: Select Replace(YourColumnName, 'ST RT', 'STATE ROUTE') From YourTable One of the original fields go back to CO RD that had been changed to COUNTY ROAD. Is there some...

The statement worked great. Thanks!