Search results for query: *

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

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

I am creating a report which is based on a command object. The query requires two parameters - "Begin Date" and "End Date" 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...

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

Greetings, I have a field that must display elapsed time in &quot;HH:MM&quot; format. I'm using two calsulated fields for comparison - calculated because of certain criteria. Here's the formula: whileprintingrecords; local numbervar Tmp := ((datediff(&quot;n&quot;,cdatetime(shared stringvar...

I have several reports that require begin date/time and end date/time as parameters. No big deal here. My problem is that the client wants the DEFAULT values to display as: FROM: CurrentDate (again no problem), 12:01AM TO CurrentDate 11:59PM How can I set the time as specified? They want...

I'm reporting against a transaction history table. The transactions record the various stages of a product sku as it goes from warehouse to shipping (planned, scheduled, picked, ship, etc) Any time something changes on the order master table, the transaction is recorded here, with the most...

Greetings, I'm creating a report that displays current product requirements and a sum of five-day demand. I need to show product SKUs by type, the current demand, the ship date, and the TOTAL demand for each SKU with ship dates +1 up to +5 days out. In short, it needs to look something like...