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!

  • Congratulations strongm 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. melven

    Name Variable using Field Value

    Example - I have open order data listed by date needed. Week Order Product Quantity 1 303 ABC 10 1 313 BLOCK 22 1 323 HEAD 15 2 333 ABC 22 2 343 PIPE 13 3 353 PISTON 55 3 363 ABC 40 3...
  2. melven

    Name Variable using Field Value

    Hi, Can I name a variable using a field value? How do I do this? Thanks, Mel CR Developer 2008 v12 CR Developer V 12.2, .NET
  3. melven

    Text Field Page Wrap

    Added the following formula and placed in footer so X does not equal 1 until Terms Header. WhilePrintingRecords; numberVar X; If OnLastRecord Then numberVar X:=1; And changed Page Header suppression formula to: numberVar X=1 I believe this will fix the problem; no issues yet. Mel CR...
  4. melven

    Text Field Page Wrap

    It is a Text Object, sorry. Yes, I have Keep Together unchecked on the Text also. I have figured out that it has to do with the suppression formula I am using on the Page Header. The formula is (TotalPageCount-PageNumber)<3 for a 3 page terms and conditions. When I remove this formula and...
  5. melven

    Page footer won't print at bottom

    You can also use Reserve Minimum Page Footer under the Page Footer section settings. Space is then reserved for the largest of your page footers instead of for all of them. CR Developer V 12.2, .NET
  6. melven

    Text Field Page Wrap

    Hi, I am having a problem with a large text field, terms and conditions, that duplicates some of the text at the top of each new page. Each page starts the same number of lines up from the previous page. Example - First page of t&c prints conditions 1-5 and half of 6. Second page will start...
  7. melven

    Selecting the highest education degree

    I do not know what your data looks like so am guessing, but I might categorize the degrees with a formula in the detail section. If {table.degree}="Masters" Then 1 Else If {table.degree}="Bachelors" Then 2 Else If {table.degree}="High School" Then 3; Then order by this formula field...
  8. melven

    Hyperlink - Open Application and File

    I have the answer, is a bit wacked though. "C:\Program Files\QuickTime\PictureViewer.exe """""""""""+{IMAGES.IMAGE}+"""""""""""" Tried using double quotes like the text path above but would only recognize table.field with odd number of quotes because it is watching the opening single quote...
  9. melven

    Hyperlink - Open Application and File

    Thanks for the reply fisheromacse, "C:\Program Files\Quicktime\Pictureviewer.exe "{table.imagepath}"" does not recognize anything after the 2nd quotation as formula without the double quotes. And double quotes the way I have it makes {table.imagepath} text rather than table and field. Have...
  10. melven

    Hyperlink - Open Application and File

    I am getting closer. In hyperlink formula editor: "C:\Program Files\Quicktime\Pictureviewer.exe ""I:\Images\Image.jpg""" This will open Pictureviewer and the .JPG, but I have not been able to get the database {table.imagepath} field to open a JPG yet. "C:\Program...
  11. melven

    Hyperlink - Open Application and File

    Hi, I would like to open a .JPG file in a specific application. The .JPG path is saved in an SQL database {table.imagepath}. And the application I would like to use is QuickTime PictureViewer because there are no editing features. I would like to select PictureViewer with CR because the...

Part and Inventory Search

Back
Top