I just added my first report (datasource, mysql, sql file in sites/default/sql), created my data block, then my report and everything works find (pdf/doc/csv, ...)

Now, I wanted to add my 2nd report (same datasource, different sql file), so I wanted to add the data block:
admin/structure/forena/data/add
but I won't the form for adding data there. It only displays the full list of data blocks like under:
admin/structure/forena/data

So admin/structure/forena/data and admin/structure/forena/data/add are the same page (eventhough 5 min ago for the first data block admin/structure/forena/data/add contained the normal form).

D7, Forena Reports 7.x-4.1, I didn't see anything in my apache error log - only access log - a 304.

Do I make a mistake?
Do I need to create a data source for each sql file?
Or is there anything wrong?

CommentFileSizeAuthor
#2 2392999-add-link-2.patch1.09 KBmetzlerd
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

metzlerd’s picture

Yes, it looks like there is a small bug in forena where the "Create New SQL" query link is still provided when the Forena Query Builder module is disabled. IF you want to create SQL files with forena's query builder please enable that module. Otherwise if you've created the second data block already as a .SQL file then proceed directly to the reports tab and create the new report there. Or perview the data on the admin/structure/forena/data page and then use the Quick Report fieldset to create the report from there.

metzlerd’s picture

FileSize
1.09 KB

  • 15469de committed on 7.x-4.x
    #2392999 Create SQL Query link should not display.
    
Transmitter’s picture

Oh .. I see - now it worked. Thank you :)

metzlerd’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.