Search results for query: *

Is it possible to display a text box in the shape of an oval as opposed to the standard rectangle? I can't seem to find anything in the format editor that will allow me to change the shape. My users have requested an oval shape with conditional formatting to change the background color. I can...

Hi all, I have a text (.txt) file that contains the data that I need for a report. The db administrators for my client have asked if I could use the text file as the datasource so they don't have to set up a procedure to import the file into the database. I understand it's possible to use a...

I'm using Crystal XI. For some reason the cell sizing handles no longer appear when a cell is highlighted. Is this an option that can be turned on or off? Does anyone know how I can turn this back on? Thanks!

My client who is using CR 8.5 has asked me to produce a cross tab report which has a summary that calculates a percentage in the middle of the cross tab. I'm not an expert with cross tabs so I'm wondering if this is even possible using a standard cross tab report or if a manual cross tab would...

I am looking for some help in parsing a string field which contains data as follows: LName, FName MName I need to show the Last, First and Middle Initial in seperate fields. I successfully use the Split function to parse the LName and FName into separate fields but I am having trouble parsing...

I have a string field which contains numeric data with leading zero's. I've converted this field to a number field and removed the leading zero's but I am having some trouble inserting a decimal point so I can report the field as a currency amount. For example, the string would appear as...

I am wondering if anyone has any idea why the following query isn't returning the correct number of records. The query used is: SELECT dbo.vw_Debtor.PacketId, dbo.vw_Debtor.FileKey FROM dbo.vw_Debtor INNER JOIN ( SELECT PacketId,MAX(FileKey) FileKey FROM dbo.vw_Debtor GROUP BY...

I created a report off a Sybase data base that has a Date/Time field which I believe is considered UTC format. The guide says the field is seconds since Jan. 1, 1970. I created the following formula named @TimeConvert so I read it in my report: WhileReadingRecords...

I'm looking for some help on displaying a Time in military time format that is greater than 24 hours. I have a report which calculates a total number of seconds an agent is logged into their system. I then use the following formula to convert the number of seconds to military time: numbervar...