Search results for query: *

Hi Thanks for responding. Unfortunately its a 2000 database. I was thinking of using .net code instead of sql to compare the 2 values but I would prefer to use SQL server procedures etc - what do you think?

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

Hi Lbass, Sorry for taking so long tro get back to you - just wanted to say that what you suggested worked perfectly - thanks a lot for helping us!

Every employee is grouped into 1 of 4 bands, 'A','B','C','D'. Each employee record has one it is ust a way to classify each employee. So what the client wants to know is how much bonus(as a percentage) per each band. I'm not sure if I've answered your question but this is how the tables link...

Hi lbass - for every person in the table(record) ther will have been assigned a band. Hope thats what you wanted to know - thanks again

Hi Lbass, thanks for your response it worked great!. The requirements for this chart have been changed since I posted this question. The client now wants it to show bands B,C & D. My initial thought was to maybe create 3 separate charts and make them "look" as though they are 1 single chart -...

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

Hi lbass, I'll try to explain a bit more about my problem so you get a better idea of what i am trying to achieve - Observations In the chart if the Band A bar has values for each segment then the ordering is correct for that bar (A) and for all the rest of the bars as well. But if bar A has...

Hi lbass, thanks for responding to this and the other post. What I didnt think was important is very important. There will always be 4 bands, but depending on the data returned in (I have about 6 filters on the report) There wont always be 6 segments (1-6) for each band. so when 6 segments are...

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

Thanks so much just ried out what you suggested on my report and it worked perfectly - your a life saver I was tearing my hair out with this problem!

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