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 Rhinorhino 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: *

  1. Tbirdbully

    Displaying the Field Data Pagenumber

    this only support 20-40 entries, I have about 500=/
  2. Tbirdbully

    Displaying the Field Data Pagenumber

    nope that doesn't work
  3. Tbirdbully

    Displaying the Field Data Pagenumber

    ...----------------------------- {?LinkReceiver} DELETE FROM "TableOfContents" WHERE "TableOfContents"."DateTime" <> {?DateTime}; SELECT * FROM "TableOfContents" --------------------------------------- When I put this in, a "Enter Values" box apear and asked for the linkReceiver input. no...
  4. Tbirdbully

    Displaying the Field Data Pagenumber

    Thanks in Advance! I am using crystal XI. Is there anyway to display the page number of where the field is in a report on a different page? What I mean is if a field is being printed on page 14, on page 2 I want to print the field and the page its on. The pagenumber function prints that...
  5. Tbirdbully

    anyway to overwrite a text box with another text box. not overlap

    Thanks synapsevampire and lbass! You guys are great!
  6. Tbirdbully

    Page Number insert

    Thanks in advance! I am using crystal 11. I want to insert the page number for a table of contents, however when I insert page number in the special fields it gives me the page of that report page. I want it to give the page of where product is in the report. mine looks like this now...
  7. Tbirdbully

    anyway to overwrite a text box with another text box. not overlap

    Thanks for your reply. Replicate() is not a valid formula function though. len shows up blue but replicate does not. Any idea?
  8. Tbirdbully

    anyway to overwrite a text box with another text box. not overlap

    I am using crystal 11. is there anyway to overwrite part of a text box with part of another box. This is what I am looking for. product names page number ------------------------------------------------------ [Acrobat].....................................45...
  9. Tbirdbully

    help create a working table of contents?

    I am using crystal 11. I have a report done and I need to create a table of contents that is user friendly.(clicking on the title brings them to correct page) I researched online and they first said to create a table. and then gave further instructions. This is my first question, how exactly...
  10. Tbirdbully

    how to compair a cell in row to a cell 5 rows down

    sorry synapsevampire about not being clear thank u for your patience Each row of my excel sheet is assigned to a code (0400) or a subcode (0400a). This field is {Sheet1_.SW Dir Code} 0400 Main Product 0400a Additional 0400b Additional 0401...
  11. Tbirdbully

    how to compair a cell in row to a cell 5 rows down

    I am using CR XI I am tryign to compair in excel row 1 with the rows below until it reaches no subcode (a,b,c,d) I have a SWCODE field that has 4 or 5 char in it. 0400 0400a 0400b 0401 0402 0402a if Length({Sheet1_.SW Dir Code}) = 4 and Next({@length}) then next({Sheet1_.SW Dir Code}) +"...
  12. Tbirdbully

    trouble compairing char in row with next row

    I didnt have any luck with synapsevampire method ethier. When I try the formula below I get the error "A field is required here" for previous(left({Sheet1_.SW Dir Code},4)) I guess it does not like the Left after previous or the left after next. If left({Sheet1_.SW Dir Code},4) <>...
  13. Tbirdbully

    trouble compairing char in row with next row

    I tried just creating a formula called {@left4} and put in left({table.field},4) if distinctcount({Sheet1_.SW Dir Code},{@left4}) > 1 then "Additional Products" when I try this I get "there must be a group that matches this field(({Sheet1_.SW Dir Code},{@left4})) I will try vampire's...
  14. Tbirdbully

    trouble compairing char in row with next row

    lbass I tried to make a group on {@left4} how do you do this? I went to insert group>customize group name by formula> left({table.field},4) Is there a way to change the name to {@left4} because its name is the same as my swcode field name shown below which gives the error msg that {Sheet1_.SW...
  15. Tbirdbully

    trouble compairing char in row with next row

    Thanks in advance! I am using CR XI I am having trouble with a formula to compair the first 4 char with the next row first 4 char. I have a SWCODE field that has 4 or 5 char in it. 0400 0400a 0400b 0401 0402 0402a My goal is to create a formula to compair the left 4 char to the row below it...
  16. Tbirdbully

    crystal report format subreport/group

    is there a way to put a formula for a separate subdetail. I want so only sub detail b shows up if there is a letter at the end of the code. so 0411k would show up but not 0411. I know there is a selection expert for group, but how do you have it filter with multiple groups. I dont know how to...
  17. Tbirdbully

    crystal report format subreport/group

    I am using crystal report XI (11). I have a excel database with certain fields listed below: Product Additional Product Software_Code Description Manufacturer I need to form a report that will place the product with its information on page 1 listing the additional products that relate...
  18. Tbirdbully

    combine details on same page with diff data

    ya I ended up putting a formula for new page after, to check for a char code that was placed in b and c. For some reason when you click new page after on a subsection it wants to make another new page for the following subsection. I just got it working the way I needed. Thanks again LB
  19. Tbirdbully

    combine details on same page with diff data

    When I do a keep together for overall detail it keeps everything together. However when I try to put new page befor detail a or after detail c it auto breaks up b and c to separate pages. I can't get A to be on 1 page 1 and B and C to be on page 2. I was thinking of trying a formula for New...
  20. Tbirdbully

    combine details on same page with diff data

    Sorry about not being clear. I have created addition details under the detail section. So subsection a,b,c,d,e section a has the main products in them, where as b,c,d,e are additional products. In b-e I have formulas to search for the char in excel to signals its additional. I can't get the...

Part and Inventory Search

Back
Top