Search results for query: *

Hi, I know that you cannot place ntext data types into variables but I was wondering if anyone knows of a "work around" for this. The problem I have is that I need to compare 2 ntext data types to check if they are the same or different. What I am doing - When a user edits a record and then...

Hi, I've got a problem where I have a popup associated to a text area. When the popup is used it displays a checkbox and some text. If you check the box the text is placed in the text area. What I started noticing is that if the text has the characters "<" or ">" and the Javascript puts the...

Hello, My problem is with a parameters that accepts multiple values. The parameters name is country. I want the user to be able to select multiple countries if they wish or they can select "*" (all). My select expert works like this - (IF {?@Country};) = "*" THEN TRUE ELSE...

Hello, I'm using crystal version 9. My problem is that I need to create a percentage barchart and I am not sure where to begin. My prob - I have 4 fields in my table (sql server 2000) salary, bonus, deferredbonus, band. The band field has the following values - A, B, C, D. 1)I have to sum...

Hi, My prolem is that on my local environment the reports look fine but on the "live" environment the charts are getting cropped and I'm not sure why. It looks like the end of the chart has just been chopped off! Is there a setting I can change to make all of the chart(s) fully visible...

Hello, In my bar chart I want the y axis to only go up in whole numbers. The chart is set so that the y-axis values dont have any decimal places (only whole numbers). One problem I've noticed is that when there is not much data the axis goes up in 0.5 increments. but because it can only go...

Hello, Im creating bar charts in crystal 9 - does anyone how I can set the y axis to only be as high as the highest value it receives. At present the charts is configured as follows in the chart expert - for all records show records - sum of formula1 sum of formula2 sum of formula3...

Hello i've posted this problem on here before but now i got a different question. I am trying to create a chart with 4 bands (A - D) and within each bar (the bands) there are to be 6 segments (1-6). I cant get the segments to order correctly (1 - 6) is now (1-4 and then 6-5). I've now come to...

Hello I cant get this right so im going to try to breakdown what im doing and see if anyone has any suggestions. I am trying to create a bar chart. This bar chart will have 4 bard (A - D). Each Bar(e.g. Band A) will be futher divided into 6 segments (1-6). so one bar would be Band A - 30%(1)...

Hello, I have a bar chart problem which is - The chart is to have 4 bands (1-4) within each band there are six groups(1-6) so the chart has the following properties on change of - Band PCTotal Count of @PCTotal The formula for PCTotal is -...

Hi I made a report which referenced a stored procedure that stored procedure referenced a view. Everything was fine until we sent the report + sp + view to our client. They have a replica of our database + website + reports. When they ran the report they report crashed because it couldn't find...

Hi Im using crystal reports version IX. I'm making a report with 7 parameters. 4 of the parameters are drop down list (with the * for all) and the other 3 are free text boxes. All parameters are optional except for the period parameter(2004, 2005 etc). I'm having reall difficulty with the...

I've created a bar chart that is set as follows - - for all records show values - 3 formulas that are summed into 3 bars. At present the y axis is value is exactly the value which is the highest returned out of the 3 formula (651, 654 etc). What I would like to do is adjust the y axis so...

Hello, Our server computer recently got the Netski virus and upon disinfection we lost all our server connections we had set up on sql server. I managed to get all of them back xcept one that every time I try to connect i get the error timeout expired. My connection username/password is correct...