Search results for query: *

I figured it out. I added the following to workbook in VBA: Sheets("Inventory_Detail").Parts_Entered.ListIndex = 0

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

Never mind. I had to reorder the formula and put the year first.

Ok either of the above works with one exception. In some cases, we'll have inventory records without a manufacturer listed. These are not showing on the report. It's only showing records if the manufacturer is not null. Any idea as to why this is? If I remove the exclusions, all records...

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 found a way to do this. First, you create a parameter but don't make it a multi-value parameter. Second, in your record selection, you add something like this: totext({Database.Field}) in split ({?Parameter},",") This allows you to paste a list in the parameter, separated by a comma. Just...

I pulled everything out of the subreport's selection expert per your instructions above.

Never mind....I just pulled the text out of the formula and put the text and the warehouse number in a separate text field and placed it above the formula in the report footer. Thanks again for the help!

Done. One last question. If I wanted to add the warehouse number in the {@not in db} formula so it reads: "Not Found in the Database for {Inventory.Warehouse}:" , is that much more complicated? If so, it's not a huge deal as I'm displaying the warehouse number from the parameter in the report...

I got it. Had a brain fart. lbass...I don't know who you work for or how much they pay you but my friend, you deserve a raise!!! Kudos!!!

Still having the same problem. Here's how the subreport links are setup. In the main report, I have two parameters: {?Warehouse} and {?Stock Numbers}. If I go to Change Subreport Links, under the fields to link to (on the right), I have both of those parameters included. At the bottom for...

Ok that got me 99% there. I'm now seeing stock numbers that I entered in the parameters that aren't in the database. However, I'm now being prompted to enter my stock numbers twice in two different parameters...one from the main report and the other from the new subreport. I'm sure this is...

Ok I have an idea. If I split the stock numbers (that were entered/pasted in the parameter separated by commas) into individual fields using multiple formulas like... //Formula Name: StockNum_Entered_1 Dim x(1) As String x = Split ({?StockNum}, ",") formula = x(1) //Formula Name...

That query is from Database --> Show SQL Query inside CR. I do have the report working with the pasted string and split function.

Here's the SQL query. Not sure what you mean by identify your database. It's a Cache database with an OCBC connection to it. SELECT Inventory.Warehouse, Inventory.Stock, CustInfo.CompanyName, Inventory.DateEntered, Inventory.Description, Inventory.Location FROM SQLUser.Inventory Inventory...

Thanks lbass but I've never dealt with commands before so I'm gonna need some additional help here. I created a new command object report, entered a parameter called StockNum and set it to multiple values. I then modified your formula as follows (StockNum is the parameter name, Inventory is...

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

These values are in a database field but I only want to query the values from my external list (see attached screenshot).

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

Crystal Reports XI...it was in my original post.