Recent content by cinbh

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

THANKS to both of you. The double ticking with the single quotes finally worked.

Actually, I should clarify that we use the single quote as the apostrophe.

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

Thanks for the quick response TurkBear. Worked like a "charm"!! [thumbsup2]

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

NEVERMIND, I just went ahead and kept doing nested replaces THANK YOU AGAIN! HAPPY HOLIDAYS Cin

Thanks for your quick response! Works great, but now my enduser just told me she also needs to take out puncuation too in addition to replacing the spaces with underscores. So since the customer name field may have commas, periods, apostrophes or quote marks is there away to reprocess those...

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

Again, thank you. I am humbled by your [smarty]expertise/knowledge of this subject. I learn something new every time I get on this site.

Okay has worked great until the endusers started to abbreviate the product forms. [sadeyes] So now I have a situation where not only do I have the orginal product forms of Unrooted Cutting in the description, when a new item is added some are now being abbreviated to URC (rather than typing out...

Thanks, but I'm not permitted to create tables in our version of VFP and the way they currently create their MondayDate info is with an Function(?), so I'm outta luck. Unless I'm missing the point of your FAQ I think I will have to create a seperate report that has a formula on the date field...

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

Thank you LBass that was the ticket. I had tried originally using the group record select and was getting a summary total error, but I'm sure I had set up something incorrectly, probably the wrong grouping. NOW WORKS!!! Cin

Well, I am printing my data in the license grouping, but the Top N Sort is greyed out. Not exactly sure why? In the other reports I have it's not.