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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: dande
  • Content: Threads
  • Order by date
  1. dande

    Creating multiple XML elements from related table

    What syntax is required to have multiple elements generated to XML? Example 1 table of people relates to a table of phone numbers. The phone numbers table can have different types... home, cell, spouse...etc. This is what I have MS SQL2008: select p1.id as '@id', rtrim(p1.first) 'first'...
  2. dande

    Report exports but shows "Loading" when viewing

    A friend has sent me a question worth asking.. The issue is regarding Crystal Reports XI installed on our Windows Server 2008 64-bit server. We currently use Crystal's ActiveX interface to access the reports using our PHP based database interface tool. Everything works perfectly fine until the...
  3. dande

    Bulk Fax using Crystal XI

    Is there a way to bulk fax using Crystal XI? Or any creative way to get a bulk fax from a report? Such as pages 1 - 3 faxed to Company ABC, pages 4 - 6 to Company XYZ where the report is producing a 3 page report for each record reported.
  4. dande

    Starting Scripting Basic

    New to using VBScript (any scripting outside of DOS batch files). Designing a custom form in Outlook. I have a frame I want to toggle enabled based on a check box selection. Am I correct that the best way to do this is scripting? And if so, what would the basic syntax look like?
  5. dande

    Tomcat in a Citrix-xpa thin client setup

    Our software vendor has informed us that their next version upgrade will require a dedicated app server with Tomcat. Their current app is a Delphi front-end hitting a MS SQL datebase. They are starting to migrate from Delphi to Java based. This is a new area for an old code cruncher like...
  6. dande

    AD OU's and group policies

    I am cleaning up almost 4 years of group policy mis-management that include a pair of Citrix Servers. My question is that there are 2 OU's that have group policies. The 1 OU contains all users that connect to the Citrix Servers, the other OU contain the 2 Citrix Servers. I know the order of...
  7. dande

    MMC difference 2003 vs 2000

    We recently moved to 2003 domain from 2000. Still have a couple 2000 member servers and 2000pro workstations. Is there a difference running the users & computers and other tools in mmc in 2003vs2000? If so, can I and how do I update the 2k member servers and 2k pro workdstations? Thanks, Paul
  8. dande

    Group running total counts recaped in the report footer

    I have never worked with variables or arrays in Crystal 8. With that being stated, is there a way to capture Group Id and a running total count from the group footer and display a recap in the report footer. Example: group footers show that Worker A has 20 clients the next group, Worker B, has...
  9. dande

    2003 upgrade from 2000 sp3

    We recently had an outside vendor do our upgrade from 2000 to 2003. This was new 03 servers that took the place of the older 2000 servers, so it was clean 03 installs on new hardware and not in place server upgrades. Since the move to 03 we are only able to run 3 to 6 hours before the network...
  10. dande

    Tape type for upgrade

    Replacing a couple older W2k servers that have tape backups installed on them. They are unsing NTBackup called by a scheduled task batch. Looking at an HP network solution using Veritas for different servers (SQL, Exhcange) to 1 tape location. Any suggustions of SDLT vs LTO would be helpfull...
  11. dande

    problems for current configuration

    Looking to put ISA server 2004 (HP package) on network with the following items. 2000 enviroment in mixed mode includes Exchange 5.5, SQL 2k, 2 citrix servers, AD server and a member file server all 2k - and a watchgaurd 700. Can isa just be a member server on the 2k mixed mode setup? Can...
  12. dande

    Another layer of linkage

    In the following I need to link 'clientlink' to another table - ar.client to pull names and other fields. Since 'clientlink' is controled by the case statement, is a link possible here, or should this be a 2 step process where the second step links these results to the client table? select...
  13. dande

    Crystal 544 error

    Running a Delphi application connecting to SQL database in a Citrix enviroment. The software vendor uses Crystal to do their reporting. I have 1 mapped, shared folder that has all application reports. The problem is when 1 user runs and is viewing the report on the screen and a second user...
  14. dande

    Sharing reports error 544

    Our client information application is a Delphi application connecting to a SQL database. We are also a Citrix enviroment. The software vendor uses a "plugin" Crystal to do the reporting from the application. If 1 user runs a report and is viewing it and another user attempts to run the same...
  15. dande

    Specific criteria for record group

    We have a table the contains staff assignments to a client. There can be multiple staff assignments to a client by programs(which are distinct programs). clientid_c staffmasterid_c program_c ------------------ ------------------ --------- 00A009 0406 900...
  16. dande

    How does Outlook & Exchange work together for Internet Mail

    Using Outlook 2000 (with 2 services - Exchange & Internet Mail)w/Echcange 5.5. 1)Can email internal user to user. 2)Can pop emails from external host.(Outlook configuration) 3)System Administrator Error sending internet mail (system wide) "No transport provider was available for delivery to this...
  17. dande

    Outlook 2000 Internet mail problem

    Using Outlook 2000 w/Echcange 5.5. 1)Can email internal user to user. 2)Can pop emails from external host. 3)Error sending internet mail (system wide) "No transport provider was available for delivery to this recipient." Been working fine for years, no chages done recently. Have internet...
  18. dande

    Selecting group of 1 only

    We have a table that lists client enrollments. Each record may assign a 'program' and a 'reporting unit'. There may be mulitple enrollment records for a client. I am trying to produce a list of clients that only have an active program assignment of '900' and no other active enrollments. I...
  19. dande

    TS license delayed rollover

    Running W2K server and Citrix xp 2 server farm load balancing connecting with Compaq T20 Thin Client devices. When the TS license expires a Citrix connection always ask Reconnect and like endless loop? As time passes it will eventually issue a new license and allow connection. In testing it...
  20. dande

    Another Join?

    In the following how can I pull the staff name (first and last) from the staffmaster file instead of staffmasterid_c from the enrollments table (ec,ew & ed)? select c.uniqueid_c, c.clientcode_c, a.type_c as a_type, a.address1_vc, a.address2_vc, a.address3_vc, a.city_vc, a.state_c...

Part and Inventory Search

Back
Top