Search results for query: *

I can see the views through other odbc connections...Access or Actuate...Crystal does not pull the views into Data Explorer. I have Views checked under File --Options. All I can think of is...some setting on the database where the views are created thats causing crystal to miss them when it...

Hi, I need to draw data from a view into some crystal reports v8.5. I can see this view through other software like Access and I can query the view directly in DB2. I can even manually edit the SQL to pull from the view but i cannot see the view name in the data explorer. Any ideas what's...

Hi all, I have a strange issue with crystal reports, but perhaps related to ODBC. Up until about a week or so ago, I could see all fields in certain tables. Now, I log on with an ODBC connection to the database and I see only some of the fields. If i switch to a DB2 sERVER Login, I see all...

Is it possible to use a case statement in Crystal 8.5 with a wildcard operator? For example, SELECT (TABLE.FIELD) CASE LIKE '%VHS%' AND LIKE '%GB%' : 50 Thanks for any advice

I have a report that needs to left join from one table on 4 different fields to another table and show counts of which SCIMS were used. The goal is to show all unique combinations of the 4 fields and then counts of which were used as well as zero counts of which were not. This is the query...

I have a report that needs to left join from one table on 4 different fields to another table and show counts of which SCIMS were used. The goal is to show all unique combinations of the 4 fields and then counts of which were used as well as zero counts of which were not. This is the query...

Inside CE 8.5, I'm trying to send reports via email to an address external to our company. We send internal and external all the time, but addresses to this particular location are of the format 'firstname.lastname@companyname.com'. The reports appear to run successfully, but the mail...

I'm trying to get a new user set up with Crystal 8.5. He has a valid user account for connecting to DB2 as do I. I can run pre-existing reports no problem, but if I want to create a new report from scratch or add a new table to an existing report, the odbc connection to db2 shows 'No items...

Can anyone tell me how to supress a group header if all of the records in the group are supressed? I've got 300+ records that get supressed correctly within a group, but the group header is still printing thinking there are 300 records there.

Thanks for the input, I ended up reformatting the report to show the necessary data in Group Footers and use a subreport up top to return a shared variable containing the value I need to filter on. Then I'm just suppressing records based on that criteria. I would tend to agree the best...

I've got a report that uses a manual running total to determine distinct transfers of a ticket from group to group. I need to limit the report to transfers greater than 3? Is ther a way to use a manual running total in your record selection formula?

Thanks for the reply. I was actually just missing an initialization of the shared variable in my main report header that would allow for a manual running total field. The I used a third formula to in the report footer equal to the running total field and all appears well. Thanks

I've got a report that is using a subreport to relate the minumum date/time value in a list of info and pass it back to the main report for use in a numbe rof formulas. Specifically to calculate a duration. I need to look at the duration between a value in the main and the shared value to...

Sorry about that...I'll pay a little closer attention to my code tags next time. And frankly, I like Mikes solution better than mine anyway and it works in V7. Regards

try this code...loop through the string character by character...check for a vowel and build a new string if its not. stringvar str_with_vowels:= {DATABASE.FIELD}; stringvar str_without_vowels; stringvar currentchar; numbervar i:=1; str_without_vowels:= ""; currentchar:=...

I'm trying to connect to a DB2 source via ODBC in crystal 8.5. ODBC tests out fine and I can query the database through DB2 command center and batch files using my userid and pwd. I can even login sucessfully to db2 on a pre-existing report and access the data. Problem is, I cannot connect...

Thanks for the tip. I gave it a try but still no luck. Some additional searching through MS Knowledge base turned up that the behavior is apparently by design with Excels ISAM. I'm going with the workaround of saving the excel sheets as text files and importing those instead. Seems to be...

I have a bunch of Excel spreadsheets that I'm importing into SQL Server 7.0 tables using DTS. I want the data stored as varchars. Looks like all is well on the import until the data values change from numerics to strings. Then the strings show up as Nulls in the SQL Server table. Anyone...

I created a package to transfer some tabular data from an Excel sheet into SQL Server 7.0. Everything runs fine except for one field which is an nvarchar field. The values of the field are either null, 'Removed', or a date (stored as a string obviously). When the package is executed, the...

Can anyone tell me how to get a crystal line chart to not plot null values as zeros? I've gone into report options and options and ensured that the 'convert null value to default' is not checked. I assumed this would take care of the nulls being interpreted as zeros...but not the case on the...