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 Mike Lewis 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. DozAdmin

    xp command line ftp

    The built in XP / ftp.exe program uses a strange port config. If I remember correctly it uses 21 as normal but when the connection is made it wants 1063 - I'm not sure of the port - but it needs another port additionally. I was hoping the cisco could be configured to allow this. I can replace...
  2. DozAdmin

    xp command line ftp

    looking to help someone run an ftp script. Firewall is Cisco 5055, I suspect it is the problem, but not sure. users can ftp with IE or ftp program but are not able to ftp with a fpt command line. New software requires ftp script to run for updates. I've tested with ftp.microsoft.com and I'm...
  3. DozAdmin

    xml data

    Sorry, that is the way I put the question... Thanks for responding! I'm building a form - a document. The whole report will be text boxes. Different text will be displayed based on data fields. Some text will be omitted completely based on data fields. Here is an example text box that fills...
  4. DozAdmin

    xml data

    I need to write a formula on a filed that is, I think, xml based. this is new for me. I need an if/then statement based on data in the middle of this and the field data looks like this. <OPTIONS><WEB><PERSONALDATADISPLAY enroll="O"> <Name value="Y" edit="Y" enroll="N" /> <Address value="Y"...
  5. DozAdmin

    Checkboxes - font style in formula

    Thanks - that was simple. :) didn't know the formatting would follow but guess that is obvious. The space is there so I can instert it at the begining of the line that will have the checkbox to maintain uniform spacing on each line at each checbox. Thanks
  6. DozAdmin

    Checkboxes - font style in formula

    I'm working on a report that is a form, I need many checkboxes. These will be "checked" manually but I'm looking for an easy way to insert the checkbox quickly. I created a formula Totext(Chr(168)+' ') But with this I have for format to use wingdings everytime I insert it. Is it possible...
  7. DozAdmin

    Cross-Tab in sub report

    I have a cross-tab report that I want to insert as a sub-report. The report links and runs fine but cuts off columns that go past the first page edge. If I double click and open the subbed crosstab I can see all of it. Is there a way to format the report so the subreport will show all columns?
  8. DozAdmin

    Add blank column in crosstab

    Sorry - Crystal Reports 2008.
  9. DozAdmin

    Add blank column in crosstab

    I have a crosstab report and would like to create a blank column for a "fill-in" box next to each existing column.
  10. DozAdmin

    Another manual cross tab

    Sorry for duplication, searched through other cross tab questions but didn't get me there. I need to create a manual cross tab report CR 2008. The report is to show investment_model allocation percentages of employee, by fund. If I didn't need cross tab it would be simple group ss#, group...
  11. DozAdmin

    recurring 3 month date.

    Grrr! Well I have it accept for the last day of the month thing. with this formula, if the firstrebday is on the 30th, then the formula will retun the 30th, unless it's feb. I've seen a couple last day formulas but not sure I know how to insert them in to this.
  12. DozAdmin

    recurring 3 month date.

    Well there may be a better way but I got it.. I am comparing the months but adding that the number must also be less that 12, I also had to add -3, -6, -9 months as options. Local numbervar m:=month({PLANEESTAT.REBSTARTDATE}); Local numbervar mc:=month(CurrentDate); if m > mc and m<(mc+4)...
  13. DozAdmin

    recurring 3 month date.

    using my formula a firstrebdate of 7/04/2007 would return false or blank because the formula option that would hit the correct date 4/04/2009 would have to add 9 mos or 3 qtrs. But this will not work with the formula because the year would be 2010. My idea to extract the months and compare...
  14. DozAdmin

    recurring 3 month date.

    I'm trying this... what if I put Local numbervar m:=month({Planeestat.rebstartdate}); Local numbervar mc:=month(currentdate); Then run the comparison part of my fomula only on the months?
  15. DozAdmin

    recurring 3 month date.

    I was just thinking only need to compare months, when years come then the comparison is inaccurate. You lost me on this - what is my quarterly formula? Here is what I have - it works if the date falls in this year, but next year doesn't fall in the >current <current+4 if...
  16. DozAdmin

    recurring 3 month date.

    Thanks Ian! I think I am 90% there, but my logic lacking. :) My formula above is missing something. The quarterly date has only for possibilities, startdate, startdate+3mos, startdate+6mos, startdate+9mos. I need my formula to evaluate which of these 4 is the NEXT one, then which is the...
  17. DozAdmin

    recurring 3 month date.

    Can I set some kind of variable or statement that says Rebalance date equals year(currendate)month(rebdate)day(rebate) To prevent having to type it out? We are always comparing the current year but month and day of the rebalance date.
  18. DozAdmin

    recurring 3 month date.

    I think below will work ??? but I have to adjust the last day of the month. if currentdate > date(year(CurrentDate),month({PLANEESTAT.REBSTARTDATE}),day({PLANEESTAT.REBSTARTDATE})) and currentdate < date(year(CurrentDate),month({PLANEESTAT.REBSTARTDATE})+3,day({PLANEESTAT.REBSTARTDATE})) then...
  19. DozAdmin

    recurring 3 month date.

    The start date is a date field, field name is PLANEESTAT.REBSTARTDATE. I typed a different name in previous post to save typing - now I'm pasting :) I am thinking I could do.... if currentdate > date(year(CurrentDate),month({PLANEESTAT.REBSTARTDATE}),day({PLANEESTAT.REBSTARTDATE})) and...

Part and Inventory Search

Back
Top