Search results for query: *

This worked ... If Payee like ['Target*','Home Depot*'] then 'HomeImprovement" Else 'Other' Thanks!

I have a data set that looks like Payee Amount Target 010 10 Target 011 20 Target 001 30 Home Depot 01 10 Home Depot 02 20 Home Depot 001 30 It want to group this into a HomeImprovement category. How to I write a formula that allows : If Payee like ('Target*' or 'Home Depot *) then...

Hi All, I am looking for a formula that will parse a string to remove anything in braces. eg. Old Column = Jane Adams (gauurk), John Doe (xgdhug), Will Ray (sygtre) New Column = Jane Adams, John Doe, Will Ray Any help will be appreciated. Thanks!

Hi All, I am using Crystal XI and have an excel file that has the following data. Mark B X X R X X B X R So what I want to do is that between the B and the R I want to change all the X's into B's until I find and R. Then mark all the X's into R's until I find a B. and so on. So the result...

Thanks Lbass! this worked wonderfully. Took me a little bit but everything fell in place. Percents based on column totals is straight forward but this is a little round about. Thanks for your help!

Forgot to show the summary columns in the last post, I am going to simplify the crosstab. So it is : Row are interactiontype and colums are regions, summary is the count of the interactions by region along with the percentage. There is a tot of the rows on the left and total of columns on top...

Row are interactiontype and colums are regions, summary is the count of the interactions by region along with the percentage. so for interaction type of phone, I have Total VA MD phone 926 100% 690 74% 10 1% I want this to show up as : Total...

Hi All, I am using CR XI R2, and have a crosstab with percent. I would like the percent to show with values upto 2 decimals. Total va md Total 1,631 100% 1,352 82% 13 0% IM 59 100% 58 98% 0 0% Phone 926 100% 690 74% 10 1% VM 20 100% 13 65% 0 0% WC 70 100% 64 91% 0 0% Fax 556...

Hi All, I have a table with 2 integer colums HourPart TimePart 13 15 14 30 I need to combine these into a time colum as follows Time 13:15 14:30 Thanks for your help in advance, sk

:-) I was hoping there was another way ... but thanks for confirming.

Hi I am using CR XI and have a dataset with 6 months worth of dates and values. The first crosstab shows vaules by week for all weeks in the dataset which I was able to do easily but the second crosstab needs to be a daily one with only 15 days worth of data shown. I wrote a formula as...

Thanks! both options work very well :-)

I have a table with user states in it. I worte the following query to find persons who have never been in a 'ready' state for a given period of time. This query takes forever to run. Any way to make it better? SELECT distinct A.UserName, A.UserID FROM dbo.Activity A WHERE A.BeginTime >=...

Thanks everyone for your time and advice. I am going with changing the command to accept a duration parameter. Seems to work fine.

Unfortunately this does not work if I have to pass the Startdate and EndDate as parameters to the command. Also the main report also has a subreport to which the same evaluated startdate and enddate (based on duration) needs to be passed.

Hi All, I am using CRXI and have a report that has the startdate and EndDate as parameters, which is then passed to a command. Now I have to add another parameter (Duration)which will automatically set the startdate and the enddate values. The duration parameter will have 3 choices, Daily...

Thanks for your reply. This worked very well. I had created the same formulas before, but I did not create a summary field for each formula. When I tried to use the fomula as is, it would give me results for only one row, the rest would be 0. What is the explaination behind the using a summary...

Hi All, I am using CR XI. I have a sql query that returns summed up values (4 rows to be exact) Item Sum ---- --- A 10 B 20 C 40 D 5 Now using crystal I have to show these values up on the report header, in a pretty format. So I have created formulas with...

Thanks! this worked perfectly. Never would have thought of doing it this way. Learnt something new. Thanks!

I have a parameter driven report that asks a user if they want -- daily (rolling 8 days), weekly (rolling 8 weeks) or mothly (rolling 8 months) worth of data. Based on the parameter entered the Crosstab should group by days, weeks or months. Data retrived from the database is by days. e.g...