Questions tagged [forena]
Use it for the module that creates tabular reports or charts from SQL data: the Forena module.
27
questions
0
votes
1
answer
50
views
Forena Reports, does not appear in the Drupal menu Structure
I installed the downloaded the 8.x-1.x-dev version of the Forena module, and it installs correctly. When I go to the menu Structure to start creating the report, the Forena Reports link doesn't appear....
1
vote
1
answer
24
views
How do I remove all references to the Sample DB when using the Forena reports module on a server without PDO Sqllite?
We have Forena installed on a server that doesn't have the PDO driver for Sqllite and would like to remove all references to the Sample DB repository so that Forena pages don't display an error about ...
- 874
1
vote
2
answers
60
views
How do I specify a Forena PDO data source in settings.php?
I would like to override my Forena data sources in a local settings file for development. I would also like them in settings.php on production for database independent deployment.
I have checked the ...
- 874
0
votes
1
answer
65
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 ...
- 119
1
vote
1
answer
42
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.
...
- 431
1
vote
0
answers
111
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).
...
- 261
1
vote
1
answer
154
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
2
answers
918
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
1
answer
78
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
1
answer
108
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 ...
- 1,269
2
votes
1
answer
44
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 ...
- 1,269
2
votes
2
answers
392
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:[email protected]:5432/database.
The problem ...
- 1,269
3
votes
1
answer
137
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 ...
- 2,761
2
votes
2
answers
212
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 ...
- 874
1
vote
1
answer
39
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 ...
- 161
2
votes
1
answer
186
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 ...
- 161
0
votes
1
answer
82
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. ...
- 161
0
votes
1
answer
840
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 ...
- 161
1
vote
1
answer
212
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 "...
- 874
1
vote
1
answer
212
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 ...
- 161
1
vote
2
answers
146
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 ...
- 161
2
votes
1
answer
511
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. ...
- 2,453
1
vote
1
answer
1k
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 ...
- 35.8k
0
votes
1
answer
1k
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 ...
- 35.8k
1
vote
1
answer
482
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,453
2
votes
1
answer
319
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. ...
- 889
2
votes
2
answers
521
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 ...
- 277