Search results for query: *

Access 2016 I've created a query of 2 identical tables, combining different years of data. There is a text field called "Loss Reported". Sample Data "1/1/2018 1:10:25 PM" I created a new field in the query from "Loss Reported" to trim to time and convert the data to a true date (this works...

When you take a memo field and allow it to grow can anyone come up with a way to indent all of the lines, after the first line?

I have a Crystal XI report that is pulling data from a MSSQL database. One of the fields, that is a memo field, has data typed in all CAPS. If there is a punctuation mark in the data then Crystal puts a space before the punctuation mark. I need to take that space out. I'm not really sure...

I'm new to this but if I understand correctly the following is saying create to a varible called "noprint" and if both fields return empty then suppress the detail. whileprintingrecords; shared BooleanVar noprint; noprint:= isnull({?Manufacturer}) and isnull ({?MfgPartNumber})then noprint: =...

Crystal 11 and SQL Server 2005. I've got 2 SQL databases. I need to pull data from both and drop into a Crystal Report. In SQL.DB1 there is a text field formatted like this "The Quote for Jefferson county is #ABCQ12345 for 3 speakers". I need the quote number "#ABCQ12345" to match and pull...

I'm having a tough time with running a update on a text field and would appreciate anybodies help. SQL Server 5.0 Thanks >>>>>>>>> UPDATE GM2.DBO.ENVIRONMENT SET...

I'm fairly new using SQL Queries. The query below works fine until I add the last line "and mail6.folder like 'X-GM%'". I'm guessing that I'm not using "and" correctly and thus it is not seeing the additional variable. Any help would be appreciated. Thanks! select * from gm6.dbo.mailbox as...

Crystal 8.5 on XP I'm probably making this harder then it needs to be. I've got a numeric field (conthist.duration) which contains time and sales amounts depending on the conthist.rectype field. Thus "T" = time or "S" = Sale or "S U" = unsuccessful sale. First I'm trying to get a dollar...

I'm using the following record selection formula in Crystal 8.5 to select data from GoldMine dBase. The formula works OK but I just discovered it is excluding any companies that are blank. I need to exclude companies that contain the three company names I have shown.... and not exclude blank...

I have a date field {ConHist.ONDATE} and I want to select records from the {ConHist.ONDATE} between the parameters {?start_date} and {?end_date} I can't seem to come up with a working solution. It seems that I have to either convert {ContHist.ONDATE} to a string or I have to convert...

I read a previous thread that seemed like the same problem thread149-333185 but suppressing if blank on the footers did not cure my problem. I have 2 subreports I've placed in the Group Footers and I've even tried them in the Page Footers and no matter what I do it advances the page before...

I have an issue at a clients site where I can't get Crystal 8.5, (with or without SP3), to run any large reports. I've tried using an ODBC connector to a DBF and I've tried just by connecting straight to the DBF files. I've tried this from 3 different Win XP machines and it will display the...

As a background: I've written many, many reports in Crystal for GoldMine over the years but only recently started using the ODBC linkage so I might not have it all setup correctly but I followed the insturctions in the EXCELLENT Crystal for GoldMine books written by Lila Brown... The Problem...

What is Net Hood and what does it do?

Using Crystal 8.5 pulling DBASE 4 data from GoldMine, Win XP Pro and/or XP Home. Internet Explorer 6.0. GoldMine 6.0 data. GoldMine now saves notes in HTML format. Running a report in Crystal with notes causes Crystal to crash. This happens if we run the report direct from Crystal or...

Instead of a field displaing horizontally to vertically, thus rotating 90 degrees? Thanks Don

I have two tables (dbase) that I am including in a report... If I create the report with Contact1 then ContSupp I get two errors 1) xBase error: bad user specified key expression 2) error detected by database dll If I reverse the creation steps and insert the ContSupp first then the Contact1...

In Crystal 7.0 Professional you could make and *.exe file of the report and take it to a client and run it on the desktop.... I just upgraded to Crystal 8.5 Professional and I don't find this anywhere... how do I do this now? Thanks! Don

I'm new with ODBC but have been writting VERY basic Crystal Reports for a few years... I have a report, Crystal 8.5, that points to 3 DBase IV files. If I understand correctly the best way to distribure reports like this is to use ODBC and create simple ODBC names on my design machine that are...

I have a text field that contains imported dates like, 11/16/2000, that I need to sort for reporting and filtering. My guess is that if I can reorder the text to 20001116 (yyyymmdd) that I would have better luck doing it... Any suggestions on a formula that would do that? Thanks