Search results for query: *

Hi, I realize this should go under data access but the last post there is nearly a year old and I wanted to make sure someone saw this. I manage a crystal server for a company of about 1000. I do not have control of the "official" ODBC connections that get pushed to users and I'm tired of...

CR 2013 SP2 Iseries database The user has lists of 100 or so serial numbers that need to be input into a report, this is something they would like to do regularly. Inputting them one at a time is time consuming, I had tried linking an excel spreadsheet with the serial numbers to the database...

That seems to be getting me there. I think if I also check the length I can filter out the fields that have small c as part of the field and I'm set. Thank you very much!!

Hi, In my data "C" means something different from "c". I need to write a formula that will identify the case of the letter. I have tried if {field1} = lowercase("c") then {field2} else "" and I have tried if {field1} = chr(99) then {field2} else "" I unchecked the box under options for...

I've tried several that I found, most of them gave errors in crystal, this one is kind of ugly but it works in crystal: Time( if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 1 then "00:00:00" else if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 3 then "00:0" +...

I've tried several ways to convert a number to a time, i.e. 165236 to 4:52 pm. I found some that work in CR without throwing an error but when I publish the report in CMC and run the report all the times show as 12:00:00 am. I'm using CR 11 and CMC product 14.0.0 Thank you VE

How about this: Total your invoice lines using insert summary Create a formula for the 1% tax which is .01 * sum({invoice lines}) call it Tax1 Put that on the report under the summary. Create a second formula for the 1.5% tax which is .015 * sum({invoice lines}) Call that Tax2 Put that on...

OK I figured it out. I forgot to reset the variable.

Hi, When there is only one record in a group in the sub report, I need it to give me a dummy date of 01/01/1900. if there are more than one date records I need it to give me the previous date record. This is the formula in my sub report: whileprintingrecords; if Count ({DRLDCH01.CHCODT}...

Thank you, I will check that out

Hi, I have been working as a Crystal Reports writer/developer for over 10 years. Every position was with a non tech company where I supported finance and wrote management reports and made tools for operations users. I do a lot of creative things to make things work. The last five years I have...

Hi, Is there a way in any version of CR to clean up the leader lines and labels on pie charts? I'm using 2008. If I get them to look OK and the data changes then I have to start all over again, so it's not really a report that I can give anyone else to run. Was this fixed in a later version...

Hi, I'm using CR 2008, making multiple pie charts. The problem is that I can't seem to move the series labels, and they are defaulting to being under the chart label, sometimes overlapping the chart label. I can't seem to move the chart labels either, moving them would be another way to fix...

I need to consolidate data from several sources for reporting needs, I have been pushing to put this in SQL instead of Access (!!) and have been asked to estimate the memory needs. We don't have a DBA or access to one, and all the calculations I have found seem complicated and frankly if I...

For some reason, the pop up calendar on two Crystal 2008 installations is skipping November. It goes straight to December from October. You can go back to November, but if you click on November 1 the date it gives you is December 1. Neither of us has seen this before, and we can manually type...

Other than readability and personal preference, are their any rules to aliasing tables in sub queries? For instance, if you alias a table in the outer query AB, is there any scenario where giving a table in a sub query the alias AB would cause problems? Or if a table used in the outer table...

Wow! thank you! I had no idea this had a name, so much easier to find when you know the correct terminology. VE

I have googled and experimented in both CR alone and with SQL commands and I'm going crazy... here is what I'm trying to do (CR2008 and SQL2008): Look at record dates by person, and if there is less than 7 months between the dates then I accrue a number of hours based on a formula, if the gap...

I'm using Access 2007 and SQL 2008 (with Crystal Reports 2008). I have a union query that is made from a pass through query and a query that uses an access table and a SQL table. When I run this union query in Access it prompts for the SQL password twice. When I try to run a report in...

Found it! it was under database properties.