Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: swiss2007
  • Content: Threads
  • Order by date
  1. swiss2007

    Labels in details repeat on next page

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

    html formatting

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

    Grouping in intervals

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

    show the cross tab difference

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

    Highlight cross tab cell and also other cells

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

    highlight cross tab cell with and without dollar sign

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

    suppress Page Header

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

    export drilldown portion

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

    Suppress group

    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%
  10. swiss2007

    highlight summary values

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

    Extract date from string

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

    cross tab missing values

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

    Suppress rows based on a condition

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

    columns exceeding one page

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

    group

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

    Conditional Group formula

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

    cross tab problem

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

    probelm with splitting and grouping

    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 :=...
  19. swiss2007

    assign values dynamically

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

    problem with 3D bar chart

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

Part and Inventory Search

Back
Top