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...

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 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

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}...

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...

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...

I'm sure this is a really basic newbie question, but I need to be able to write stored procedures and my current user account does not have permission. Right now the only way I can write or access them is as sa and I really really don't want to do that. We do not have a DBA so I need to do this...

What do you do when you run into a problem that needs to be solved and your manager, who is not technical (business manager), demands that you tell them excactly when you will have it fixed? What do you say when they imply that your job is easy? When they ask you how long something will take...

I'm using Crystal 2008 and SQL 2008 I have two tables, one is an assignment table, and one is an invoice table. There are assignments that are not invoiced. I need to create a report that includes all assignments with additional data for assignments which have been invoiced. I have tried...

Excel 2010 is adding black backgrounds to my charts when I publish them as .pdf. A coworker has excel 2007 and does not have this problem. Is there a way to fix this or is it just a bug in 2010? I'm using acrobat reader X in case that is an issue. Thank you VE

I'm using CR 2008 I have been asked to create a report where each of 4 possible codes in group 2 are listed under group 1. The problem is that I don't have each record in group 2 for each record in group 1. (I hope that makes sense). How can I get a list of all possible codes in group 2 to...

Hi again, I'm using Crystal 2008 connecting to an Access database. I'm trying to get a distinct count of this formula: if ({AVPerformance.invoicedate} in #3/26/2011# to #4/29/2011# and {AVPerformance.AV} <> "") then {AVPerformance.AV} else {@null}//empty formula I tried the Running Total...

Hi, I've created a task that I want to disable but I can't find it. I have "show hidden tasks" on and I have looked around in the registry but I just can seem to find it. Is there any other place I could look? Thank you for your help. VE