Search results for query: *

Hi everyone, I just installed CR developer v11 on my PC but in french. I just want to change the language to english (easier with forums and terminology when I need help). I tried to uninstall and reinstall it in english but no luck, still in french. Anybody has any idea on how to change it...

Hi! I use CR 8.5 and SQL database. I have a running total that summarize a field. I need to evaluate it on a change of month (group #3) and reinitialize it on a change of year (group #2). I have another group (group #1 : currency) that I need to do another calculation. Let me explain. I...

Hi! Is it possible to add a blank column in a cross-tab in crystal 8.5? I use a city field for the column but I need an extra column that I would call 'Corporate' and I need a column for the total. My cross-tab should look like this: Burnaby Edmonton Winnipeg Corporate...

Hi, Is it possible to create a formula without any comparison with a field in the database? What I mean is that I need a formula that has 3 texts (G.S.T. and Q.S.T. and H.S.T.). I want to create a group so I have those 3 taxes in my report. The thing is that I have sub-acounts for the...

Hi, I have a PC with windows XP and office 2000 and CR 8.5. When I wanted to export to excel, I had the choices of format 5.0 to 8.0 extended before. Since last week, the higher format that I have is 5.0! Nothing changed on my PC, no patches or upgrades what so ever. So I don't understand...

Hi! Is it possible to create a formula that returns the previous groupname of a group. Example: I group my report by invoices (each invoice have lots of details). I want to compare the current group with the previous group. Is this possible? Or can I just compare the current record...

Hi, On my PC, I have Windows 98, Cr 8.5 and Office XP. When I run a report and want to export it in excel, I don't have the format excel 8.0 (extended). It stops at excel 5.0. I didn't have that problem with Office 2000 (excel 2000). So what I did, I desinstall Office XP, reinstall Office...

Hi everyone, Is there a function in crystal 8.5 that returns the week number in the year? Example: the 3rd week of february is the 8th week of the year. Thank you.

Hi, I have CR 8.5 and Windows XP service pack 1. When I export in excel format, I don't have the format box where I can choose if I want the header or not, etc... So in that case, when the exportation is done, I have no header at all. I didn't have that problem with windows 98. Does...

Hi, I have a cross-tab group by month for the columns. When I have no data in a particular month, it doesn't show in the cross-tab. Is there a way that I can have 12 months all the time? Thanks, Budjette [sadeyes]

Hello, I want to link an oracle view to a table in access. I have 4 starting points and 4 endinG points. Example: table1(Oracle) table2(Access) CC ---------> CC DEPARTMENT --> DEPARTMENT PERIOD ------> PERIOD YEAR --------> YEAR When I link the first one, CC to CC, I...

Hello everyone! I was wondering if there is a way in a chart to only display the data in the y-axis when <> 0? For the look, it's not very pretty to see zeros on the chart. Any suggestions??? Thanks, Budjette

Hi everyone! We have a big problem with our web server (we have our intranet on it). We already have a live web server ruuning fine. We are building up a new server to replace the old one. Everything is working fine except for somes ASP pages. Some ASP pages are working fine through a...

Hi everyone, I have a table in SQL that looks like this. Type Crew Date Monday Tuesday Wednesday Thursay ... Hours 14027 10/14/02 55.67 67.89 48.60 48.50 WO 14027 10/14/02 68.78 34.56 23.45 23.45 Ress 14027 10/14/02 45.67 23.45...

Hi! Is it possible to change the color of a data label (in the group axis) with a specific condition? For example, I have a line chart with pecentages in the data axis and dates in the group axis. Sometimes I have 0% in the data axis on a date. I want to have alle the dates black except...

Hi, I want to create a decode function that compare dates, NOTES.DATE_CHANGED and SYSDATE. I want it to look like this: DECODE(TO_DATE(TO_CHAR(NOTES.DATE_CHANGED, 'MM-DD-YYYY'), 'MM-DD-YYYY') >= NEXT_DAY(TO_DATE(TO_CHAR(SYSDATE, 'MM-DD-YYYY'), 'MM-DD-YYYY'), 'MONDAY')-14, null, 'Yes'...

Hi, I need help for the arrays. I never worked with arrays before and I have a hard time doing what I want. I have a report with 5 groups. The last group by is with dates. The maximum values that I can have in that group is 7. The thing I want to do is fill up an array with thoses values...

Hi! I have an array that I fill up in a group header with dates. I have a parameter that I receive, and if this parameter is in the array, I want to display all the values in the array in the details section. Is this possible? Thanks, Budjette