Search results for query: *

I have a spreadsheet with an ActiveX combo box in cell B5 that is linked to cell C5. I have a named range on another worksheet called "Parts_Entered" and my ListFillRange is pointed to it. When I select a value from the drop down list in B5, I'm populating a date range in cells B6 and B7...

I'm working on a report in Crystal 11.5 and need some assistance with a formula. I'm looking at inventory data where the manufacturer is equal to multiple values and the inventory year >= a year or where the manufacturer is equal to other multiple values and the inventory year >= a different...

I'm building a report with a parameter for stock numbers. The parameter allows multiple custom values. If the user enters a bad stock# that doesn't exist in the database, I want to alert the user that the stock# they entered doesn't exist. Is this possible? Building a dynamic parameter isn't...

Good morning. I have a report where I need the ability to paste in multiple values into a parameter prompt. The values will come from a vertical list in a text file and can range from 1 to hundreds so it would be tedious to have to enter these manually. The values will always be alpha/numeric...

Using Crystal Reports XI. I've got a field in our Inventory database called PartCategory and that field has 4 possible values: Y, W, U or NULL. I'm trying to add a parameter to allow users to select which category(s) they want to include on the report. I've tried adding a static parameter but...

I'm drawing a blank here guys...maybe it's just too early to be attempting this :). I need to figure out how much my state (4%), county (1%) and city (4%) taxes are based on the actual tax amount charged. For example, if I have a total tax charged of $27.00, I need to break that $27.00 out to...

I've got a VBA module built to import a text file but need some help with one thing. The problem is, field 7 of the text file can contain commas and if commas are present, it's splitting the text up instead of leaving the commas in field 7. I also need to leave the double quotes in the data if...

I've got a spreadsheet that is querying inventory. I have a parameter setup so I can enter two values - a starting inventory location and an ending inventory location. In Microsoft Query, my criteria formula looks like this... >=[Start Location] And <=[End Location] The problem I'm having is...

I've got a text field that contains some text that I want to exclude from my query. The text is in the middle of the string and I can't figure out how to use the "Not Like" or "Does Not Contain" in MSQuery to remove them. Here's an example of a string and I need to exclude anything that...

I've got a report where I'm pulling all employees in from a field UserFeatures.EmpName. This field shows every employee that's setup in the company. I'm passing this field to numerous subreports. I need to hide all employees unless they have data in any of the subreports. For example, I have...

Ok I'm stuck on this one and need some help. I've got a WOSummary.DepositPostedDate string field. This field shows dates deposits were taken on an order separated by a }. The field looks like this... 05/08/2017 or 05/08/2017}05/09/2017 or 05/08/2017}05/09/2017}05/10/2017 and so on depending...

I have a formula called Sales_Total that, at times, can exceed 11 characters in length but the cell width only allows for 11 characters. When this happens, the report returns ######## instead of the amount. What I'd like to do is evaluate the number of characters in the total and if the...

I've got a report - group 1 is CustomerData.AccountNum and group 2 is ARStatement.AccountName so currently, the report is sorted by the account number. I need to sort it by the account name. I've got some duplicate customer names in the ARStatement.AccountName field and if I simply group by...

Using Crystal Reports 14 and working on a report for accounting. The two classes I'm using are CusDocData and CustomerData. The report is grouped on the CustomerData.AccountNum field. I have a date parameter called "Detail Start Date" and I need to sum the CusDocData.InvoiceBalance field if...

Ok need some help here. I'm working on a spreadsheet to show sales in a specified date range but only if the stock number in the database table falls in a range of stock numbers from a different worksheet. Here's the way I need it to work. I have a StockNumbers worksheet and I'm running a...

Got another one that I need some help with. I'm getting "the string is non-numeric" on the following formula. local stringvar currGN := GroupName({SalesTotalAdjustment.RecDate}, "quarterly"); local stringvar currGM := if length(trim(currGN)) > 0 then left(currGN, instr(currGN,"/")-1); local...

Getting this if I run my report on a system that I know has no data 3 years ago. I need it to return a 0 if there's no data. Can't, for the life of me, figure this out and I'm no Crystal expert. I'm trying to fix this report that was created by someone else. Here's the formula that's...

Need some help with this one. I have a string in cell E2 that I need to extract everything between the first two spaces. The string is... INV 7243-1 FRG LH (Extra Sale) ANY I need to extract 7243-1 from this string but here's the kicker. It won't always be 4 digits, a hyphen and 1 digit...

I have a text field in cell H2 that contains either "LH" or "RH" (see examples below). I need to extract the "LH" or "RH" into cell I2. If H2 shows "CARAVN 07 RH (((NEW IN STOCK))) (CH23R)", I need cell I2 to show RH If H2 shows "SUB150 02 Int.2972 LH (((NEW IN STOCK))) (CV23EL)", I need cell...