Search results for query: *

I'm working with Report Builder 2.0 (we don't plan on getting SQL 2008 R2 - so NO 3.0 for us!) and have found that if I have an existing report using an existing stored procedure (it has 4 existing parameters) and I add a new field to the stored procedure it will not refresh the data set. I...

We are using SQL 2000 and with Apex I am currently using a replace on my company name field to take out commas, ampersands etc. Problem is I need to take out aprostrophes too, but I think Apex or SQL won't recognize the double quotes as valid. So the following does not work...

We are using Crystal 8.5 on VFP 8.0 platform. Our orders are to be shipped in what we call full trays (or whole numbers). An order is made up by a number of detail items, so all we care about are the orders whose TOTAL of these detail items does not end up in a whole number value. So my...

I have a offsite company that requires underscores rather than spaces in our output data. This would be with every field within my report. Right now my poor traffic clerk is physically doing this in the spreadsheet I export to, then sending to the offsite. Is there a quick formula or some...

I have an enduser that wants to see a date row even if no data is available. It's a challenge in that we only show shipments as a Monday date. Currently my x-tab rows are by BaseProduct,MondayDate and the columns are the ProductType. We have many products that ship only certain times of the...

I have a situation where I need to select orders where they have more than one license designation on an order and order detail level. The rub is if they have more than 1 I need to show all of the detail level records. Data: Customer, Order number, License Bill 24000...

I am trying to create a report that shows the rows of product with columns of Date and then under the ShipDate an Order Qty column then a Committed Qty column for that date should look like: 5/13/04 5/20/04 5/27/04 Ord Comm Ord...

I have to reprogram some of my reports into the VFP 8.0's report writer and it would be easier for me to work with a printout of the Design page of my Crystal 8.5 reports. For some of the reports I can paste into word and printout, BUT the Legal Size Landscape are causing me a problem, so was...

We are running Crystal 8.5 with VFP 8.0 My question is previous to IS doing system upgrades my reports had ArialRoundedMTBold as the selected fonts on the fields. Now, when I open my reports the fields default of Arial Western is shown, BUT when they get exported to a PDF the fields are...

We are using Crystal 8.5 with VFP 7.0. My enduser needs a report that shows all customers that have ordered a product line but only those who have NOT ordered a particular product of both that product Line or other product lines. Example: Maker is the Product Line Cust A has ordered 20...

I'm having a major problem where I have specifically selected from my data set records with 0.00 discount. When the report prints (I have 3 groupings) my Order group has 0.00, my Company group has 0.00 but my product group has the total from the WHOLE data set as though I did not select only...

When using the Label Report Expert (Crys 8.5 with VisFoxPro 7.0) I get the perfect set up for 2 across labels in the detail section, but since we only need labels once for each customer that has multiple shipments in selected weeks I need to get this data printing in Group Footer section. When...

I have a situation in Crystal 8.5 using VisualFoxPro 7.0 where the Database programmers set up a descriptive field with a type within it. EXAMPLES: College Paper 8X11 College Paper 11X14 College Paper Yellow Lined Highlite Markers Fluorescent Yellow Highlite Markers Fluorescent Pink So I want...

I have a situation where I have to link more than 9 tables (Visual FoxPro issue) so to get around this I need to bring in a subreport for the additional tables, but not all the records in the Main report have records that occur on the sub report. We are using Crystal 8.5. When I link the...

I need to round UP (only) my formula field results to the next whole number whenever I have a decimal value . For Example: 10.70 = 11.00 .80 = 1.00 1.40 = 2.00 ETC. I have seen some threads using truncate, but I don't see how I'm able to get it to work for this situation. Of course, I'm...

in the Show SQL Query. Why would this occur? All of my other reports show the order by clause as my groupings are set up. Also would using a formula field as one of my groupings be a culprit? We are using Crystal 8.5 with ODBC. Thank you, Cindy

Now that I have successfully passed the parameters within the crystal report I guess my REAL concern is whether the Visual FoxPro 7.0 View processes based on the parameters FIRST or does the View itself execute its own query and then Crystal parameter selects based on the resultant view fields...

We are using dbf's from Visual Foxpro 7.0 and since I'm limited by the amount of links when I execute in Crystal, ACTUAL ERROR MESSAGE IS: ODBC error[Microsfoft][ODBC Visual Fox Pro Driver] SQL: Too Many Subqueries so I've had to set up a couple of local views which is fine, BUT my crystal...

We use Visual FoxPro 7.0 for our database and there are occasions in using Crystal 8.5 where I will need to recall orders that have been deleted. The database does not get "packed" so essentially I need to do a "dirty read". Is there a way to set this up on a report basis...

I have a situation where I need to differentiate between an actual net difference (using numerics from 2 tables)of zero vs. a null value showing as zero in the cross tab. Using Crystal 8.5 here is data for my NetDiff Cross tab report: Row= Item, Column=Shipweek, Summarized field =...