Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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