nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calling a DataSet via script and display the results in the same script.

mikaru · 2014-04-11T06:02:17+00:00

Hi everyone , I express my question. First let me explain where I am , I have a DataSet that first appoint Query1 whose results…

mikaru

Hi everyone, I express my question.
First let me explain where I am, I have a DataSet that first appoint Query1 whose results are displayed in a table but through the script of a dynamic text. What I mean is that based on a value of a specific field in a result row I change the CSS display. What I want to do is based on a value in a field (eg Name = 'Smith') I call a DataSet Query 2 passing as parameter 'Dupont' and then display the results in the same script. So basically look like this:

Line 1 Query 1
Line 2 Query 1
Line 3 Query 1 (Name = 'Smith') I call the query 2
Display Line 1 of the application 2
Display Line 2 of the application 2
Display Line 3 of the application 2
Line 4 Query 1
Line 5 Query 1

etc ...

If possible can you tell me the method to execute / call to do this.

Thank you and good afternoon.

Find more posts tagged with

Comments

micajblock

If performance is not an issue then nested tables is the easiest way to do this. There are examples in DevShare.

mikaru

Where are this examples please ? i don't find.Thank you for your advice.

micajblock

<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/devshare/_/designing-birt-reports/530-sample-birt-sub-report-example'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/530-sample-birt-sub-report-example</a>

mikaru

Thank.I have a question , i can launch the second query or table if for example row["code_champ"]=='Country" , or in nested table the second table is launched for all values of row["code_champ"] ?I want specifie when launch the second query like my example.

micajblock

Again, if performance is not an issue. Set the visibility of the inner tables based on your condition. Another option is use joined data sets. One for the main query and the second for the nested query. Filter the nested query on your condition and set the join to be an outer join.

mikaru

Okay! ,I'll try I understood.Thanks.

mikaru

Hello, I tried the nested table but it appears to me that result is to say that I have made â€‹â€‹my position on the "dataset parameter binding" So I get out the field whose I need except that if there is a ";" I want to do a split on the answer to be able to run 2 times in a row the request of the nested table.

example:
if (row ["CODE_CHAMP"] == 'LISTEPAYS')
{
d = row split. (';');
for (i = 0; i <d.lenght i + +)
{
d [i];
}

}

This is my condition in the dataset parameter binding.
I want that if row = 'FRANCE, SPAIN' that displays the query is done for the value France and Spain but this value appears to me that the result for the value France.
Will he has a way to display two or more results? Thank you.

micajblock

Do you have sample data that we can play with?

mikaru

No , unfortunately

micajblock

You will need to write some script I think to create a In clause. Again if you create sample data (even dummy data) that illustrates what your data looks like, I could build an example.

mikaru

I don't arrive make my database Mysql localhost in BIRT data source.

micajblock

Create a dummy CSV file the demonstrates what your data looks like.

mikaru

I have a file CSV but i don't where we create a datasource with a file slq, csv or other.I send file CSV , it's just a example ,That looks like a little the truth datum. Requete1 : SELECT * FROM produit where produit='VOY1'.My condition :if(row=='LISTEPAYS'){d=row.split(';');// normaly d[0]==France and d[1]==ESPAGNE// and here i launch second query with parameter d[0] in first and d[1] in second etc} SQL because i dont upload : -- phpMyAdmin SQL Dump
-- version 3.3.5
-- <a data-ipb='nomediaparse' href='http://www.phpmyadmin.net'>http://www.phpmyadmin.net</a>
--
-- Serveur: 127.0.0.1
-- GÃ©nÃ©rÃ© le : Lun 14 Avril 2014 Ã 15:53
-- Version du serveur: 5.1.49
-- Version de PHP: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @CHARACTER_SET_CLIENT */;
/*!40101 SET @CHARACTER_SET_RESULTS */;
/*!40101 SET @COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de donnÃ©es: `test`
--

--

--
-- Structure de la table `champs`
--

CREATE TABLE IF NOT EXISTS `champs` (
`champs` varchar(64) NOT NULL,
`libelle` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `champs`
--

INSERT INTO `champs` (`champs`, `libelle`) VALUES
('CAPITAL', ''),
('POPULATION', ''),
('LISTEPAYS', '');

--

--
-- Structure de la table `produit`
--

CREATE TABLE IF NOT EXISTS `produit` (
`produit` varchar(64) NOT NULL,
`champs` varchar(64) NOT NULL,
`titre` varchar(64) NOT NULL,
`paragraphe` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `produit`
--

INSERT INTO `produit` (`produit`, `champs`, `titre`, `paragraphe`) VALUES
('FRANCE', 'CAPITAL', 'CAPITAL', 'PARIS'),
('ESPAGNE', 'CAPITAL', 'CAPITAL', 'MADRID'),
('FRANCE', 'POPULATION', 'POPULATION', '1millions'),
('ESPAGNE', 'POPULATION', 'POPULATION', '2millions'),
('VOY1', 'LISTEPAYS', 'LISTEPAYS', 'FRANCE;ESPAGNE');

micajblock

Where is the CSV file?

mikaru

My second query is : SELECT * from produit where produit='FRANCE' (d[0])

mikaru

The CSV file not want uploaderThe message error is :You aren't permitted to upload this kind of file.

micajblock

What version of BIRT are you using?

mikaru

v3.7.1

micajblock

Attached is a sample. Hope this helps.