Search results for query: *

Thank you very much.

What would I need to setup a home wireless network? I have a cable modem, so I assume I would just plug the incoming cable to a wireless router. Then, would each of the PC's/Laptops need a wireless card to connect? What type of card. Sorry, so basic questions. I checked FAQ's and White...

Super. Thank you very much.

Awesome! Thank you very much.

I've tried using Whileprintingrecords; stringvar MyDate:=totext({APDISFIL.AP_DIST_DATE},0,""); val(mid(MyDate,5,2)) and it seems to sort correctly, but I also need to group by the month and when I try it the @month formula, which I uesed above, does not show up a a group option.

I have a field that is a number field and is displayed 20,051,101.00 which is a date 20051101. I need to take just the 5th and 6th char's to be able to sort by Month. I've tried (ToText(mid({APDISFIL.AP_DIST_DATE},5,2))) but get error "A string is required here" and it highlights...

Thank you. I'm embarassed. I must have had a really bad brain cramp this morning. Thanks again for your assistance. Gene

I have a report where I have a parameter that selects from a drop-down menu that display's all the default values in a field. There is only 1 table in the report. CR9, PSQL9, W2K3. When I select one of those values, it displays all of the values in the field rather than just the one I...

Good morning. I'm very new to PSQL and need to create a view. Is it possible to take a value, have that value in a view and take the first 5 char's and put that in another field and the second 5 chars and put that in another field. My result should be like: Item Main...

Worked super. Thanks synapsevampire !

I have a report where I do not want to include any item numbers where the 8th & 9th char's are PE or RE. CR9, PSQL9 Server 2003. This is my formula: (not ({IMITMFIL.ITEM_NO} startswith ["ALMISC", "ALSCRAP", "AWELD"])) and {IMITMFIL.ITEM_NO} >= "A%" and {IMITMFIL.ITEM_NO} <= "AZ%" and (not...

I may not have been specific enough. CR9, PSQL9, W2003 server. The user is only going to know the 4 digit number, not the whole string. Is it possible to have them enter a parameter of 4402 and have the report select file xxx4402xxxx ?

Thanks all. I'll try it. Gene

Is there a way to take a field, xxx4402xxx, and in the parameter select only char's 4,4 to run the report on? I thought I could do it with mask, but am having some difficulty. Thank you. Gene

Yes, grouped on {imitmfil.item_prod_cat}

I put: if isnull({imitmfil.item_prod_cat}) then 0 else {imitmfil.item_prod_cat} in a formula but it's giving me an error that says: "A number is required here" and it highlights the last line of the formula {imitmfil.item_prod_cat} The field item_prod_cat is a char field with a size of 3...

Thank you. I tried using this as a formula in the Group Header if Count({cphsttrx.hist_trx_sale_amt},{imitmfil.item_prod_cat}) > 0 then sum({cphsttrx.hist_trx_sale_amt},{imitmfil.item_prod_cat}) /Count({cphsttrx.hist_trx_sale_amt},{imitmfil.item_prod_cat}) else 0 but I still get the error A...

Actually for Sale Amount, I'm taking (Sale Amount)/Total Qty Sold. I couldn't enter a Sum for a formula. All these calculations I'm putting in the Group header because I'm grouping on the Code.

Crystal 9, PSQL 9, W2003 server. I have a report where I'm taking a specific Code Category, Sale amount, dividing it by Lbs sold to get $/Lb. Code Total Lbs Sold Sale Amount $/Lb 60 172.80 $392.80 $2.2731 For Total Lbs Sold I'm using {Qty...

My mistake. Thank you.