Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Forena is database report writing software built on the Drupal platform, use to create tabular reports and/or charts.

0
votes
0answers
14 views

How do I reference values from multiselect on page

I'm using forena in drupal 7. I've got an input parameter as a multiselect: <frx:parm id="stationname" label="Station Name (hold ctrl for multi)" desc="The name of the station" data_source="foo/...
0
votes
1answer
20 views

Using multiple parameters in Forena

I'm trying to pass multiple parameters from one Forena report to another one. Currently my link looks like this: reports/aen_multi?startdate={eventdate}&enddate={eventdate} but this does not ...
1
vote
1answer
28 views

Is it possible to use the Forena module in conjunction with the Flot module?

I need to plot based on some data that will be fetched from an external (non-drupal) database. I have found the Forena module, but in the part I do not like about the graph utility it uses by default. ...
1
vote
0answers
63 views

Customizing Forena reports according to the report type [closed]

I am using Forena reports to generate my custom reports. I want to use a custom PHP variable which increments its value under foreach loop in layout under (Create new reports through admin interface). ...
1
vote
1answer
119 views

How to make Forena render my SVG Graph properly?

I am trying to create a bar graph using Forena's SVG Graph facilities. But it shows output like this: As shown in the above image, it is not rendering the SVG Graph properly. I am using this SQL ...
1
vote
2answers
291 views

How to build my SQL statement to export all webform submissions using Forena?

I am using Drupal 7.54. and my users are grouped together through a custom user field. I want to export all webform's submissions for a given group of users in one CSV. So as suggested in the post ...
1
vote
1answer
59 views

How to display an image in a report created with the Forena module?

I created a report using the Forena module. In this report I want to display image which is saved in a private folder. I am fetching the image url from the file_managed table using file_load() method ...
2
votes
1answer
85 views

How to move the Forena report parameters block further down and give it a separate heading?

Can the Forena parameters block be moved further down and given a separate heading? The Forena Parameters block sits at the top of the page, but I would rather have it further down the page after ...
2
votes
1answer
32 views

Is there a way for Forena to restrict the debugging messages to selected roles?

The Forena data source has the option of displaying the generated queries on the screen via the Debug option. The problem here is that the messages are displayed for all users or reports while this ...
2
votes
2answers
283 views

What is the correct URI syntax for using Forena to connect to a Postgres database?

I am trying out Forena Reports and in connecting to a Postgres table I set the the Driver Type to Postgres Database and the URI to postgresql://username:password@127.0.0.1:5432/database. The problem ...
4
votes
1answer
114 views

Can Forena Reports be used with Organic Groups to create a report with a “page” for each member?

I would like a link in each of my organic groups where Forena would replicate some of my views and create a pdf document with a page per OG user. I've looked through the documentation and module but ...
3
votes
2answers
167 views

Why is my Forena report parameter not displaying as a textbox?

I created a Forena report using a data block that has one parameter in it, i.e. ":year". When creating the report, the parameter is detected and added to the report definition. When previewing the ...
1
vote
1answer
24 views

Why does legend not appear when the first bar value is zero?

I have created a chart using Forena reports. I have added the legend by using the property frx:legend_entries="legend" from the frx file. But when value of the first bar chart is zero or null, legend ...
2
votes
1answer
154 views

Use multiple data blocks in the same chart created using forena reports

I have created a chart using Forena reports. I need to set the chart title dynamically based on the logged in user's country. At present I have hard coded the title as "Your Country". The data for ...
0
votes
1answer
61 views

How to switch language on pages containing charts created using Forena?

I have created a chart using Forena Reports. I have created a menu with this chart as one of the links. I have also installed the Language Switcher Dropdown module for choosing between 3 languages. ...
0
votes
1answer
335 views

How to translate the title, axis labels and legend of a chart?

I have successfully created a grouped bar chart using the Forena module. My application supports English, Portugese and Spanish. But I am not able to translate my chart to Spanish and Portugese. I ...
1
vote
1answer
171 views

How to secure access to a Forena data block?

I have set up an external database source using the Forena reports module and the PDO driver. This data source has its data security method set to "Use Drupal permissions". The only other option is "...
1
vote
1answer
154 views

How to show the values on the bars of a stacked bar graph in 3D?

I have created a Stacked Bar Graph (in 3D) using the Forena reports module, which looks like so: I was able to successfully create this graph. But I am having problems in showing the corresponding ...
1
vote
2answers
126 views

How to add mulitple legends in chart created with the Forena reports module?

I have created a report using the module Forena reports. It's a compound graph of 3 items. I need to mention these 3 items in legend. But I am not able to add more than 1 legend. I am trying to ...
2
votes
1answer
453 views

How to display the value of a report parameter in a Forena Report and in a CSV export of it?

Using Forena Reports I'm wondering if it's possible to include in a report the PARAMETERS passed by the URL? I'd just like to output those parameters once in the report; probably at the top. ...
1
vote
1answer
718 views

How to add a link to the CSV download to my module page, for a report created with Forena?

How do I add a link to the CSV download created by the Forena module to my module page? Do I just copy the link in 'inspect element' and put that in my $output variable that I return on the ...
0
votes
1answer
864 views

How to format database fields in a report created with Forena?

How can I choose how to display the fields from the database returned by the data block (using the Forena module)? Such as a field just returns a number, but each number of that field represents ...
1
vote
1answer
430 views

How can I use session variables in a report created with the Forena module?

I've installed Forena Reports. It's basically working, but I have some questions (see bottom of post to get right to it). What I want to accomplish is the following I want an anonymous user of the ...
2
votes
1answer
260 views

How to access an external MySQL database in a view if SQLite support is not installed?

I would like to display other MySQL database by Views, and having the similar situation as this question. Except, I'm not able to enable the "SQLite", because I have no control on the server end. ...
2
votes
2answers
451 views

How to fetch HTML created via a Forena report and store it as a node?

I'd like to automatically (Rules) copy some HTML into a node . The HTML comes from a Forena report (already as an HTML document), created by the Forena module. In the Rules module I couldn't find ...