Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jeffcis

    logon script update

    Hi, I'm new to VB and the guy I replaced created a logon VB. We have 60 computer plus and we are using CA for deploying hot fixes and service packs. The CA server (this server releases the updates has record of all the machines) has recently died so I have replaced it with new CA server. Now...
  2. Jeffcis

    Cannot connect to Internet

    Still no luck after adding the above config. I added some more access list but to no avail. PIX# show running-config : Saved : ASA Version 7.2(3) ! hostname PIX domain-name default.domain.invalid enable password ZbQo4qnRYkNuQ.12 encrypted names ! interface Vlan1 nameif LAN security-level 100...
  3. Jeffcis

    Cannot connect to Internet

    I cannot still connect, below is my latest running config PIX# show running-config : Saved : ASA Version 7.2(3) ! hostname PIX domain-name default.domain.invalid enable password ZbQo4qnRYkNuQ.12 encrypted names ! interface Vlan1 nameif LAN security-level 100 ip address 10.49.0.5...
  4. Jeffcis

    Formula

    I've used the running-total with formula like the below on the change of group, but I get a ZERO result {'GL_LOI_'.Payer} = '100440' and {'GL_LOI_'.BC} like ['he','ho','li','np','tu','vc'] //100440=Jacobsen//
  5. Jeffcis

    Cannot connect to Internet

    Hi For some reason my ASA 5505 router has stopped connecting to the internet. Few days, ago the ADSL router for some reason, it stopped functioning so it has to be replaced. So bought in a new ADSL router, configured and everything is working find. Configure the ASA WAN as DCHP client to obtain...
  6. Jeffcis

    Formula

    The reason I asked is because, I have another CR report but it is grouped by BC, and Region (eg NSW) but I wanted to include in this report selected customers only (eg Jacobsen and Nuplex). The idea is to combine the two reports into one single report.
  7. Jeffcis

    Formula

    Before I posted this question, I have the report made exactly was has been described above. Is there anyway I can do this with formulas?
  8. Jeffcis

    Formula

    i'm using CR 11
  9. Jeffcis

    Formula

    Hi, My table shows the following information: Bc Name m2 Sales HO CarpetOne 100.00 $1,500.00 LI Crampton Carpets 100.00 $1,500.00 NP Crampton Carpets 100.00 $1,500.00 NP Crampton Carpets 100.00...
  10. Jeffcis

    Formula

    Thanks nobull613, it worked perfect
  11. Jeffcis

    Formula

    Hi Ian, Correct me if I'm mistaken, but i'm not sure if that is going to work because below is HEADER name of a table so you cannot replace it with the customer name itself. {Sheet1_.Sold-to party}
  12. Jeffcis

    Formula

    Hi Tek-Tips, The value of my customer_name table, are shown below: Kym Woolford Carpet Choice SN1517 City Carpet Choice SN1702 Dubbo Carpet Choice SN1220 Hirns Carpet Choice Mt Isa SN1906 Hirns Carpet Choice Mt Isa SN1906 The below formula given to me below, drops part of the customer name...
  13. Jeffcis

    Ignore comma (,) or or dot (.) in formula

    Hi, One of the column in my datasource has some commas or dot which is happen to be the product name. For example, the below are product names with comma and dot WALLGARD 1,3 WALLGARD 2.0 My particular string formula for product name is shown below. if {@subtotal} > 0 then...
  14. Jeffcis

    a number, or currency amount is required here

    Hi, The below formula has no errors found but when I save it, an error pops up,i,e a number, or currency amount is required here. if {Sheet1_.Net value} >=0 then Cstr ({Sheet1_.Net value}-{Sheet1_.Condition value},2,'') The error formula is shown below: if {Sheet1_.Invoiced Quantity} <> 0...
  15. Jeffcis

    Suppressed 0 appears when exported as CSV

    I'm using CR XI, then I download a 30 days trial of CR 2008 full version and the issue still popping up. Which export driver hotfix you are referring to that is compatible with CR 2008?
  16. Jeffcis

    Suppressed 0 appears when exported as CSV

    Hi Madawc, The value is zero and suppressed if zero in CR is turned on. When I export my CR report as CSV, when viewed in NOTEPAD, the suppressed zeros are coming out with commas too - pls see below. ,,,,,0.00,0.00,0.00,,,,,,,,0.00,,,,,,,,0.00 ,,,,,0.00,0.00,0.00,,,,,,,,0.00,,,,,,,,0.00...
  17. Jeffcis

    CR versions?

    Hi, I just need some clarification about CR versions and releases. At present, I'm running CR XI. There are also CR XI Release 1 and patches available for this version and CR XI Release 2 and patches available for this version. My questions are as follows: is CR XI and CR XI R1 and CR XI R2...
  18. Jeffcis

    Suppressed 0 appears when exported as CSV

    Hi dgillz, i'm CR v11. Thanks, Jeffcis
  19. Jeffcis

    Suppressed 0 appears when exported as CSV

    Hi, I have a CR report whereby some of my strings were suppressed with zero value. When this same report is exported as CSV file format, the zeros all appearing when view the file in NOTEPAD, EXCEL etc. Is there a way to stop this in CR, ie, excludes zero from being exported? Appreciate any...
  20. Jeffcis

    A number is required Here

    Hi, Im getting error on my formula "A number is required here" Formula: if {Sheet1_.ZFR1 - Airbag}>0 then sum ({Sheet1_.ZFR1 - Airbag}, {Sheet1_.Bill#Doc#}) else "" I'm trying to show if {Sheet1_.ZFR1 - Airbag}>0 then sum ({Sheet1_.ZFR1 - Airbag}, {Sheet1_.Bill#Doc#}) else show {Sheet1_.ZFR1...

Part and Inventory Search

Back
Top