Search results for query: *

Sure, here is the string builder portion of my SP: declare @searchCriteria nvarchar(1000), -- the final search string @searchBasic nvarchar(1000),-- Basic search field- accept comma separated list - used on basic search page @searchAll nvarchar(1000),-- Advanced search ALL WORDS-accept comma...

I did find a solution to the problem. To refresh, the problem I had was that I wanted a way to return all records AND NOT records with specific value using a full text search. Full Text searching does not allow you to only exclude values - there always has to be "find something with this...

Thanks Qik3Coder, I forgot about that little trick, but it does not seem to work with FT Catalog searching. Unless you know how to properly construct the search string to pass in... I tried several different ways The more I look into this the more I'm convinced that you cannot simply return...

Greetings, I'm creating a web based app that includes basic and advanced search functionality. We're using SQL Server 2005 with Full Text Search enabled on the back end. The SP that performs the search builds a search string based on the options a user submits: BASIC - any string or comma...

Greetings, Hopefully I can express this situation clearly... We're creating a portal to which customers will subscribe and create and store data. Each customer will have a login to the portal Each customer will have a matching Active Directory account login Each customer will have their owh...

This might be a little late, but it may be worth the tip: There is a check mark in the Wingdings font that you can use on a report. Place a textbox control on the report, set its Font property to Wingdings, and then place the checkmark into it. Leave the original checkbox control on the...

Greetings, I have a report that contains two subreports. The main report is essentially a container to hold the two subreports. The subreports are identical in the data used, but sort and group differently depending on one of the parameters selected from the main report. Based on this boolean...

I've run into the same issue using an Informix Database. We have 34 different reports, most of which require complex SQL, so we use the command object behind the reports. My "quickie" workaround is to open my services file and comment out the service for the current (development) connection...

Thanks Jim for the code revision. I had to make a slight adjustment but it did the trick. It threw an error at the line: if Flag then exit do; Was expecting a While after the exit do, so I changed While sCounter < max Do to While sCounter < max and Flag=False Do I feel pretty good that I...

Thanks, I'll give it try. yeah, I got carried away on the brackets, I'll admit. And that last ReDim was thrown in as an attempt to make something happen (which didn't) I was able to get a little closer by changing the &quot;While sCounter < max Do &quot; To &quot;For sCounter := 1 to...

That Order list should read: Order# SKU Available Qty Ordered Bal 001 A 0 375 -375 001 B 775 25 750 001 C 100 193 - 93 001 D 0 5...

I'm creating a report that will display potential product shortages as the product appears on orders. I have a sub report that calculates the item's available quantity (based on several conditions - inventory, damaged, ordered, on hold, etc) Because the SKUs do not appear in the report...

More details.... We need the parameters within the query because the table is self-joined and we need to restrict the dates on the second instance. And it's a UNION query combining daily transactions and history transactions so filtering the dates out from the report selection criteria does...

I am creating a report which is based on a command object. The query requires two parameters - &quot;Begin Date&quot; and &quot;End Date&quot; Because of the way the data is stored, we need to have these parameters within the query, not passed from the report. Using Crystal 9 Informix...

I'm creating a Crystal Report (v9) against an informix db using a command object (query) with two date parameters. I'm having trpuble with the WHERE clause in my query: &quot;WHERE DATE(tbl.datetimefield) >= {?Begin Date} AND DATE(tbl.datetimefield) <= {?End Date}&quot; tbl.datetimefield is...

I've have a string array to hold certain field values whilereadingrecords. I need to be able to count the number of times a specific string exists in the array. So if the array holds &quot;AA&quot; &quot;BB&quot; &quot;CC&quot; &quot;AA&quot; &quot;DD&quot; &quot;AA&quot; I need to know that...

Greetings, I have a report that only displays the group level summary (no detail section) All quantity fields in the group are based on calculated running sum fields (shared variables) in the suppressed detail section. There's quite a few conditions that must be evaluated for the quantity to...

Thanks

(Had to do a little digging myself) Posted for a co-developer. She has a report with a custom command (a union query) joined to another table in the database (Informix) The report returns the data that she needs, but runs very slowly. The union query is necessayr because it contains daily...

Can you create an index in the report data source without actually creating the index on the database table?