Announcement

Collapse
No announcement yet.

Reporting to an Excel file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reporting to an Excel file

    for over 2 weeks, when running a report to find diskspace and then export to and excel file it now repeats the same entries 4 times. It has worked perfectly for years.

  • #2
    Re: Reporting to an Excel file

    Give us more details on how you are running this, etc.

    Comment


    • #3
      Re: Reporting to an Excel file

      Thanks for getting back.

      We are running Active Directory in Native mode. NT server, logged with administration rights. Reports on servers over differing subnets and across leased lines.

      Comment


      • #4
        Re: Reporting to an Excel file

        How are you running the reports? Are you using File->Export, or are you selecting the computers in the right window and choosing Drive Space?

        Comment


        • #5
          Re: Reporting to an Excel file

          First of all highlighting all the servers, right click and drive space.

          After that has finished, printing, then tools>run report. When in access, file and export and then exporting it to disk as an XLS file

          Comment


          • #6
            Re: Reporting to an Excel file

            When the data is listed in the right window do you see duplicates there?

            When you run report, try selecting (if you aren't already) the option to Overwrite Existing Data.

            Hyena takes the data from the right window, creates a text file, then an Access macro takes over from there. So, if you are getting duplicate information from this process, either there is data in the Access table already, or something in your export/import to Excel is going wrong.


            [This message has been edited by cmccullough (edited 11-06-2003).]

            Comment


            • #7
              Re: Reporting to an Excel file

              It was as simple as that, to be honest I hadn't even seen the append option.

              Many thanks for all your help and speed of response

              thanks again

              Comment

              Working...
              X