#302 Formating report output

open
nobody
None
1
2012-11-02
2012-10-31
knjigor
No

Hi, is where can i sett width of first column in report page results, or type of view? Problem is that first column is about 18px width and i can't see it's content, can it be setup to fixed width or to flex (depending on longest content of cell).

Second, is there any chance to create results as separate page and without scrolling for rest of table, or to define what fields can be shown, or maybe a print support only for results table?

Discussion

1 2 > >> (Page 1 of 2)
  • You can change the width of the left hand column by editing line 116 of js/report.js.php. In the line

                                                   "iLeftWidth": leftWidth,
    

    replace leftwidth by eg 400 for 400px. (This solution will work in the short term. In the long term it probably needs something better).

    You should be able to define what fields are shown by using the Show/Hide Columns button above the table on the right. Your selectrions will be remembered.

    You can also change the number of results shown by using the "Show" select button at top left.

    Campbell

     
  • knjigor
    knjigor
    2012-10-31

    Thanx for express help :), i have changed that and it is greate.

    About visible fields, the trouble is that i'm setting booking system for my Faculty and it should be used by students (they would insert they study group and year of study to get timetable), for creating reports for teachers depending on they name so they get they timetable, and administrators. Also there is some type of print report (paper that should be putted on dors).

    Any way, i can explain to them that they must use show/hide button.

    :)

     
  • knjigor
    knjigor
    2012-10-31

    One more question, where are defined widths of right columns, I have realised that if I entries of some columns aren't long and column width is.

     
    Last edit: knjigor 2012-11-01
    Attachments
  • knjigor
    knjigor
    2012-11-02

    Can someone help me with this project, I'm thinking about creating msword or msxecell output format for reports?

     
  • Is the CSV output not sufficient?

    If you really need Excel output it's quite easy to do. I have already extended MRBS in my own implementation to output reports in .xls or .xlsx format. I used PHPExcel (http://phpexcel.codeplex.com/) which worked very well.

    Campbell

     
  • knjigor
    knjigor
    2012-11-02

    Wel It should be enough, but when I open csv with excell i get what is in the picture, all data is in one (1st) column, no matther what separator I define, allso, it is possible to export it only with utf-16, and i have used utf-8 and don't wont to redefine all from start.

     
    Attachments
  • Have you tried playing around with the two config variables?

    $csv_charset = 'utf-16';  // try 'utf-8'
    $csv_bom = TRUE;  // try FALSE
    

    Campbell

     
  • knjigor
    knjigor
    2012-11-02

    yes, but then i don't see characters, and it is still formated in one column.

     
  • If it doesn't contain sensitive data could you post a sample .csv file please?

    Thanks,

    Campbell

     
1 2 > >> (Page 1 of 2)


Anonymous


Cancel   Add attachments