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!

Recent content by Tbirdbully

  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

    I tried this out a few times but I keep getting stuck on step 8 with the correct syntax for excel. The syntax shown below given is for Microsoft SQL Server. ----------------------------- {?LinkReceiver} DELETE FROM "TableOfContents" WHERE "TableOfContents"."DateTime" <> {?DateTime}...
  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...
See more

Part and Inventory Search

Back
Top