Alpha Video Training
Results 1 to 7 of 7

Thread: Report like an excel file

  1. #1
    Member Cristiano's Avatar
    Real Name
    Cristiano
    Join Date
    Jan 2007
    Location
    Venice (Italy)
    Posts
    384

    Default Report like an excel file

    Hi guys,

    I have a problem, you can make a report with five alpha 11 as the excel file that I attach?
    I have these fields:
    customers in columns and months in the rows, and the name of the various suppliers of course will go to groups.

    Anyone can help me ?


    Thank you
    Attached Images Attached Images
    Cristiano
    cristianodona@gmail.com

    Skype: cris-do

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,657

    Default Re: Report like an excel file

    I make reports like this one of two ways.

    1. Define the columns as calculated fields with something like this. c1=if(col=1,sales,0)
    group on vendor on client.

    2. Make a crosstab operation to build the 'cells' and then an export to put the data in excel.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member Cristiano's Avatar
    Real Name
    Cristiano
    Join Date
    Jan 2007
    Location
    Venice (Italy)
    Posts
    384

    Default Re: Report like an excel file

    Hi Al,

    Thank you for your reply, but I do not wont to export any data in Excel I wat to create the report like the excel file but with the report of Alpha Five V11
    Last edited by Cristiano; 10-20-2012 at 04:41 AM.
    Cristiano
    cristianodona@gmail.com

    Skype: cris-do

  4. #4
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: Report like an excel file

    Hi Cristiano,

    What are the values in the browse? Total Sales for each Customer in every Month? Or are the values for Purchases? I'm not quite sure how or why you want to get values for Customers and Vendors on the same report.

    I think Al's suggestion about creating a crosstab operation is the way forward, the report would be based on the result table.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  5. #5
    Member Cristiano's Avatar
    Real Name
    Cristiano
    Join Date
    Jan 2007
    Location
    Venice (Italy)
    Posts
    384

    Default Re: Report like an excel file

    happy to hear you.

    I need to create this report because the person who commissioned the work,he had an excel file for billing with a summary annual sales list by supplier, customers of these suppliers for each month, and my problem is that I'm not able to make a report wit Alpha Five like the excel file
    Cristiano
    cristianodona@gmail.com

    Skype: cris-do

  6. #6
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,313

    Default Re: Report like an excel file

    Cris, show us some sample data by uploading part or all of your table.

  7. #7
    Member Cristiano's Avatar
    Real Name
    Cristiano
    Join Date
    Jan 2007
    Location
    Venice (Italy)
    Posts
    384

    Default Re: Report like an excel file

    ok,


    I really have to thank everyone, if it was not for all of you I never learned to use a crosstab. I must say that this forum is very useful.
    This is the steps to obtain a report like the excel file:

    I received from the customer some excel files . These file were historical data of her commercial agency ( billing) and billing summary .

    First of all, I imported all these excel files data (billing ) into one table and then I have prepared an operation that make a crosstab, from this table I obtain the report is the billing summary that is exactly the same of the picture that you have view before on my first post.


    Thank you
    Cristiano
    cristianodona@gmail.com

    Skype: cris-do

Similar Threads

  1. Cannot read Excel file
    By Jberry in forum Application Server Version 11 - Web/Browser Applications
    Replies: 12
    Last Post: 02-13-2012, 06:13 PM
  2. Excel export file
    By Nick Oldfield in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 04-01-2011, 01:51 PM
  3. Saving Report as text file or excel file
    By Michael Hadjimichael in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-02-2004, 05:46 AM
  4. Import of Excel File
    By Andy Rutland in forum Alpha Five Version 4
    Replies: 2
    Last Post: 07-10-2002, 12:27 PM
  5. import excel file
    By efrain chavez in forum Alpha Five Version 4
    Replies: 4
    Last Post: 05-26-2002, 07:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •