Search results for query: *

Hi, I have a subreport A which has the processed_counts. I have a subreport B which has the Total Counts. I need to insert a field "Difference" in Subreport B which will be Total Counts (from subreport B )-Processed Counts (from subreport A) How do I go about getting this? I appreciate your...

Hi All, I have a Stacked bar graph.On my Y axes I have Process and on X axes I have Hrs. We have around 1000 processes and I was wondering if there is a way to split the graph to 2 pages? I am using Crystal Reports 2008. Thanks fo your help, Petronas

Hi Lbass, Thank you so much! I appreciate you taking the time to give me the perfect solution. I have a question regarding the GridRowColumnValue. If my Columnfield is based on a parameter, a date range.Eg, if I select YTD ( year to date) from the parameters the column field would be Jan 12...

Hello All, I have a Crosstab in which I have 'Sum Of Command.Totals' under my summarized Fields. This is being calculated at the query level either as a Number or as a Percentage. I want to display % sign only for the ones that are percent and blank for the numbers. Under my Crosstab Rows I...

In the summarized Fields I did the 'Weighted avg of Command.Percentage with @Weight'. The row totals %'s are not calculated correctly. Is there a way that I can fix this? Thanks in advance, Petronas

Thanks LBass. How do I tie in the weight formula with my percentage formula? I am sorry I don't use Crystal reports frequently. Thanks in advance, Petronas

Hi, I am using a cross tab. There is a formula for Percentage which is as follows : if {Command.Label}= "A" then 0 else if {Command.Label}= "B" then if {Command.initial_count} = 0 then 0 else ({Command.Counts}/{Command.initial_count}*100) else if {Command.failed_count} = 0 then 0...

Thanks for your replies. I used the character map utility and it worked great. Appreciate your help and your valuable time!

Hi All, Is there a way to add an acute accent in Crystal reports? I have to add the accent to Holandska on the s. I am using Crystal reports XI. Thanks in advance, Petronas

Hi, I have a field in the report , Response_value which has values such as 1,2,3,4,5 etc depending of the survey_id parameter. I want to calculate a total _repsonse where the formula should be If Response_value =1 then count(vlues) *1 If Repsonse_value = 2 then count(values)*2 I am not sure...

Hi All, I a have a parameter field which is defined as String ({?OID}). When I try to assign it as follows: {Command.Order_ID}=ToNumber ({?OID}) It pops up a message: "This array must be subscripted" How do I convert the parameter field to number? Thanks, Petronas

I have a report which looks like: Price Amount Charges $0.00 $0.00 $4.99 $14.97 Total...

Hi, I have the below SQL query in Creports. It is throwing an error " Conversion failed when converting datetime from character string". Declare @Get_Date datetime, @StartDate Varchar(30) select @StartDate = '{?StartDate}' Select @Get_Date = convert(varchar ,month(Getdate()) )+ '/01/'...

Hi, My report has a Startdate prompt which lets you select 'M' - last month or you can enter any date as a parameter. based on what is selected in the prompt I need to display the last month. If the report is run today choosing 'M' it should show Oct date. if you enter a value in the prompt...