Search results for query: *

I have 3 columns College, Year and programs and the data looks like College Year Program 2005-2006 1styear Maths Physics English Earth Science 2006-2007 2ndyear AB CD EF GH IJ KL MN OP QR 2007-2008...

I have a crystal report designed using crsystal reports V11. A few fields in the database are stored in html tags. When I show these fields in the report, the html format is showing up. When I right click on the fields ----> Format field ----> Paragraph ----> Text interpretation ----> HTML...

I have orderid, customer name and orderamt 1, abc, 950 2, abd, 500 3, abe, 450 4, abf, 1950 5, abg, 1200 6, abx, 2200 7, aby, 2500 8, abz, 2700 9, abxx, 2800 10, abzz, 3100 I want to pass one parameter number, 100 or 500 or 1000 so that the order amt results are grouped based...

I have completely 2 different datasources pcp1 and pcp2 and are not related The data coming from pcp1 and pcp2 is most of the times same but not always. I have a cross tab in the main report taht displays data from pcp1 and subreport that displays data from pcp2 my goal is to find if there is...

I have a Cross tab that has Rows Country Columns Year Summarized fields orderamt Profit(Y/N) sample data looks like 2001 2002 Austria Orderamt 4200 6000 Profit(Y/N) Y N France Orderamt 5500 5000 Profit(Y/N) N N Germany Orderamt 12000 10000 Profit(Y/N) N Y Ireland...

I have a cross tab that is set up like below. --Rows ReviewNo Cost --Columns Year Month Period --Summarized fields PaperAmount The report uses a command statement that uses union all to get the desired results. select select MonthPeriod,FiscalYear,ReviewNo, case when Papertype =...

I am opening a new thread to explain everything clearly with example. there is 1 date parameter, there is always 2 years of data. I have 2 groups Country and Region. I have the following structure. PH Current Prior %Change YTDCurrent YTDPrior %ChangeYearly...

I have 3 drill downs in a report and is there a way while exporting from level 1 to also export the level 2 and level 3 data of the report.Appreciate your response

I have 2 groups country and region and at the region level I am calulating the %diff between currentmonthtotal and prior yr currentmonthtotal how do I suppress country and region when %diff is less than 5%

Hi, I have 2 groupings country and Year. I have only one date parameter and I have to calculate yeartodate summary values and the previous months greater than the month parameter should be highlighted in green. sample data like this Country Year:2010 YeartoDate Jan Feb Mar Apr May Jun...

Hi, I have a date field "Edition_date" which has to be filtered based off on 2 dates that have to be extracted from a string field "Title". The start date in the Title always comes after "startday" and End date always comes after "Endday" My Title sample data is like 1)Cause: Processing...

Hi, CRXI R2,Oracle 9i, I have a cross tab that`s going to be run for a time period of any 6 months during a year.If there is no data for any months, I want to show that as "The "xxx","xxx" Months have no data. For ex,If I am running from jan till jun and there is no data for mar,apr,jun, I...

I have a report structure like GH1 ClassID GH2 Description GH3 SalesRepName Details GF1 GF2 GF3 Detail level data is as ClassID Description SalesRepName StartDate 1 High Michael Greene 08/01/2008 1 High Tren Malle 08/03/2008 1 High...

Everyone, I created a cross tab report that has Rows: Supplied Date(for each month) shipping type for ex:Overnight,2 day,3day Columns: location for ex:Chester,Bridgetown,Johnson City etc. Summaries: Sum of Ordered Amount sometimes the report has fewer locations and sometimes many...

Hi, I have a parent edition record with several child records for the parent edition record. SO,I have a parent grouping and then child grouping.I have to display No Records for the child if a parent edition record doesn't have child records. GH1 (Parent) GH1a GH1b GH1c GH1d GH1e GH1f GH1g...

I have my data something like this England (GROUP) emp Customername Order date payment received id 1 BBS Pty 09-Feb-2004 True 1 BBS Pty 01-Mar-2004 True 1 BBS Pty 24-Oct-2004 True 1 BBS Pty 18-Apr-2005 False 3 BBS Pty 30-Mar-2004...

hi, my data looks like this paper paper paper paper Entry paper date code in stock to use location 12/20/2007 AT F T 300 DR 12/20/2007 AT T F 423 DR 01/06/2008 CR T T...

I have 2 different sets of questions for which the codes are dynamically assigned in the report as shown below. For Ex: //This formula is used in Report Header whilereadingrecords; numbervar array a; numbervar i; numbervar j := 60; stringvar array y1 :=...

Hi All, I have a series of Questions coming from the sql server database and I have to assign codes to these questions,but the problem is that the codes could be changing. Is there a way to dynamically assign codes? for ex: Question Code 1 BZ could be AZ 2...

Hi All, I am using a 3D bar chart to show Months on the x-axis, count of order ids on the y-axis and years on the z-axis.Each year has got same color on all the months in the bar which is done by using the color highlight option in chart expert. Is there any way to dynamically assign chart...