Search results for query: *

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

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

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

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

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

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

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

Hi All, I have a crosstab which looks like this : 01/22 01/23 01/24 01/25 01/26 HR1 2 3 4 1 0 HR2 1 5 0 2 0 Totals 77 85 92 106 28 (The total inclues the suppressed "others" column) I have...

Hi All, I am trying to change how reports are displayed in the infoview. Instead of displaying them within the infoview portal(object area), I want to launch them on a separate browser whenever a report is selected to be viewed. When I login into infoview and click on the "Personalize...

We have an email group which references other subgoups. When scheduling to send out the report instance to the group, if one of the email addresses is inactive or for what ever reason it bounces back the job fails and no one gets the report email. Is it possible to skip emails that bounce back...

Hi, I am using Crystal XI, on a SQL database. Example of the problem I am having is as follows: Company A Col1 ----- 10 20 30 --- SubTotal: 60 Company B Col1 ----- 15 25 10...

Hi All, I am using Crystal Reports XI and I have a stored proc which needs two input parameters which appears in my report as @Year and @Company. Now I want to add in a 3rd parameter to only the report (and not the stored proc), called deal with a listofvalues that depend on the company...

I have a data set as follows: A 11:50 $20 A 12:30 $40 A 10:30 $25 B 9:30 $35 B 9:30 $35 C 6:45 $45 The result I want is : A 12:30 $40 B 9:30 $35 C 6:45 $45 Basically I want one row for the highest recorded time, ordered by column1 ascending. I think I need an inner query with a group...

I need help with a formula which calulates a date and time and passes it as a parameter to a subreport which uses that datetime parameter to execute a stored proc. The formula is DateTime(CurrentDate, Time(06,30,00)). This gives the result with a AM attached to it which causes the subreport to...

How do I move multiple reports from Crystal Reports 10 to Crystal Enterprise 10 simultaneously, instead of one at a time? Any help will be appreciated.

We use Crystal Reports 10 to develop the reports and then move them over to Crytsal Enterpirse 10. This is fine when there are only one or two repors to publish, but when we have a 24 or more reports that need to be published, first in dev, then QA and then into Production servers it can get...