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

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

    Extracting from string

    Hello, I have a request to extract building code from a string. The problem is they want everything to the left of the last - in the string. For example, the field could be Bu1-Bu2-Supervisor Shipping or it could just be Bu1-Welder or it can be completely blank. I guess I want to extract...
  2. GCL2007

    Extracting portion of field after last -

    I have a field that is typically populated in the format 12345-67-890 or something similar to that. There are two - characters, however the number of characters can vary. If I wanted to just get everything after that 2nd - . In the above I would want to report 890, what would be the best way...
  3. GCL2007

    Date fields coming into Crystal as Date/Time

    Hi - Wondering if anyone has ideas. I'm trying to create a report that reports Transaction records that I want to group into Fiscal Periods. I have a Periods table with Start and End Dates for the Period. I am just trying to report transactions by Period (for example, March 29 to April 25)...
  4. GCL2007

    Add leading ***** and a $ sign to check report

    Hello, I am trying to create a report for check writing. The request was to format the amount value like this: ************$123.44 with the leading *s and a $ immediately preceding the field value(which is 123.44) I would like the total field to be a fixed size, so if the value was larger, I...
  5. GCL2007

    Simple Recovery model - Huge Trans Log

    I have a SQL Server 2008R2 database that we use as a date warehouse. It is large, data file is 42 GB, but the Trans log file is 80 GB and growing. It is a Simple database with Maintenance Plan backups every night. Much of the data gets loaded in from our ERP system. I don't understand seeing...
  6. GCL2007

    Formatting hyperlink on exported document

    Hi - I'm using Crystal 2016. We have Oracle database and my users have input a folder location stored in a BLOB field (\\server\folder\folder1) in one of the tables of my database.. I had a hard time getting it to display but finally did using a SQL Expression formula...
  7. GCL2007

    How to get consistent field width in Note field

    Hi, I'm using CR 2013 with Oracle database. Trying to report a VARCHAR2 Notes text field and get consistent widths on my output in Crystal. Note field has text then an underline for user to hand write on form a value and initials. Field1 ______________________________________ Field2...
  8. GCL2007

    Exporting Data Only with Subreport Extra Row

    Hi, I think this may still be a limitation but figured I'd ask... Using Crystal Reports 2016, I have a report with a subreport.It passes a variable to the main report. The subreport is set to Suppress Blank Subreport and exports to excel beautifully on a straight export. But they want to...
  9. GCL2007

    Background Color Formula

    I’m having problems with a formula using CR 2013. It’s just a background color formula for a box that I want to paint using background color in Format Editor.. I have a crazy formula that checks for conditions and just paints the text box a certain color based on certain conditions in the data...
  10. GCL2007

    Record Selection for two occurences of character

    I'm trying to create a quick little report that would display any of our part numbers that have two - characters in the part number. For example 123456-123-AB . We have many parts with single -'s but I want to get only those parts that have two - characters in the part number. Can anyone help...
  11. GCL2007

    InStr and Mid

    I am trying to figure out someone else's report that I inherited... Can someone explain to me what this formula is doing? IF InStr({OD.COMMENT1},"*",1) <= 1 THEN ' ' else MID({OD.COMMENT1},INSTR({OD.COMMENT1},'*')+1,999) In the first line I get that it is searching for a * in the field. Is it...
  12. GCL2007

    Suppressing Decimals if .00

    I have a form with a Qty Shipped field on the form which is actually a Sum of Qty_Shipped for a Packing Slip item. I have run into a situation where I needed to ship decimals (.5 or .25) quantities. 99.9% of the time I ship in numbers with no decimals and I really don't want to format the...
  13. GCL2007

    Tempdb ldf file - how best to clear..

    I have a Tempdb transaction log ldf file that grew to 55 GB yesterday (on SQL SERVER 2008 R2). I think I found the offending job that was causing it and killed it - ldf was growing pretty rapidly up to that point. Not too experienced with this - what are my best options to clesr it out...
  14. GCL2007

    Conditional prompt for Dynamic prompts

    Have a question about conditional parameters. Want to set up a report with a prompt - How do you want to run the report? - by Scope or Type. If Scope is chosen Dynamic Parameter prompt for Scope Value displays. If Type is chosen, Dynamic Parameter of Type values is displayed for the user to...
  15. GCL2007

    QR Code Crystal XI and CR 2016

    Hi, Hopefully this is an easy question that will save me some digging on the web. I have a request to include a QR barcode on a Crystal report. I'm most familiar with Crystal XI and just now have had Crystal 2016 available to me. In the past, to do something like this, it would require...
  16. GCL2007

    Cross-tab within report excel download

    I have a question using Crystal XI and exporting to Excel. The detail of the report is standard rows of data - I've learned how to export nicely to Excel without adding extra rows to the Excel output file. My question is that I now have a crosstab at the bottom of the report in the Report...
  17. GCL2007

    Extract part of a field using MID

    Hi, I'm trying to extract a portion of a field. The fields value might be "0123456-PO-555556666 SOMETEXT OR NUMBERS" . I just want to extract the PO number portion, which would be 555556666. I've been playing with a MID({TABLE.FIELD},InStr({TABLE.FIELD},'PO-')+3) formula, which seems to work...
  18. GCL2007

    Code39 print out of parameters entered

    Just trying to do something very simple. Have parameters for 2 text fields to be entered, field1 and field2. I just want to print code39 barcodes of those values. If I just use the Stringtocode39 function STRINGTOCODE39({?field1}) and similar for field2, and set the font to a code39 font, my...
  19. GCL2007

    Extract part of field until a certain character

    I want to display a field up to a certain character. For example on a value like ABCDEFGHIJKL,MNOPQRST , I'd want to display everything to the left of the comma, and the comma can be in a different position on each record. Any ideas? Thanks!
  20. GCL2007

    Export a field into individual files

    Hello, I received an odd request - was wondering if anyone had come across something like this and how they may have approached it using Crystal. The request is to export the values of a field, say part descriptions, into individual pdf files titled with the value of the part description...

Part and Inventory Search

Back
Top