IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Profile: tuanvoooooo1
About
User Name: tuanvoooooo1
Forum Rank: Member
Real Name:
Location
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Friday, June 29, 2018
Last Visit: Tuesday, July 31, 2018 11:50:49 AM
Number of Posts: 11
[0.06% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: Group by in XSLT1.0
Posted: Friday, July 13, 2018 11:34:09 AM
thanks for the reply!
I found a way for it using XSLT1.0 tho.
You had to group the attributes in a different rowset in the XML scheme, and then use variables and xpathfilters to categorize them
Topic: Group by in XSLT1.0
Posted: Wednesday, July 11, 2018 11:46:14 AM
Hi.
I want to simulate a groupby-operation in XSLT1.0 (it has to be in XSLT1.0). The goal i want is shown in the image attached
How do i group the different attributes in different tables as shown? I want the attributes to be grouped by the <PROJECTNAME>

Suppose i have a XML that looks something like this:

<?xml version="1.0" encoding="UTF-8"?>
<DOCUMENT>
<ROWSET>
<ROW>
<ID>13815</ID>
<FULLNAME>Andrea Natloh</FULLNAME>
<DATE>04.10.2016</DATE>
<UNITS>1.00</UNITS>
<DESCRIPTION>Some Placeholderteext </DESCRIPTION>
<ISSUE>11322</ISSUE>
<PROJECTNAME>Modul1<PROJECTNAME>
<PROJECT_SUM>56.00</PROJECT_SUM>
<TOTAL_SUM>269.00</TOTAL_SUM>
</ROW>
<ROW>
<ID>13815</ID>
<FULLNAME>Andrea Natloh</FULLNAME>
<DATE>04.10.2016</DATE>
<UNITS>1.00</UNITS>
<DESCRIPTION>Some Placeholderteext </DESCRIPTION>
<ISSUE>14427</ISSUE>
<PROJECTNAME>Modul2<PROJECTNAME>
<PROJECT_SUM>45.50</PROJECT_SUM>
<TOTAL_SUM>269.00</TOTAL_SUM>
</ROW>
<ROW>
<ID>13815</ID>
<FULLNAME>Daniela Minelota</FULLNAME>
<DATE>04.10.2016</DATE>
<UNITS>0.50</UNITS>
<DESCRIPTION>Some Placeholderteext </DESCRIPTION>
<ISSUE>11322</ISSUE>
<PROJECTNAME>Modul1<PROJECTNAME>
<PROJECT_SUM>56.00</PROJECT_SUM>
<TOTAL_SUM>269.00</TOTAL_SUM>
</ROW>
<ROW>
<ID>13815</ID>
<FULLNAME>Eugenia Kazakova</_FULLNAME>
<DATE>05.11.2016</DATE>
<UNITS>1.00</UNITS>
<DESCRIPTION>Some Placeholderteext </DESCRIPTION>
<ISSUE>20427</ISSUE>
<PROJECTNAME>Modul3<PROJECTNAME>
<PROJECT_SUM>4.50</PROJECT_SUM>
<TOTAL_SUM>269.00</TOTAL_SUM>
</ROW>
Topic: Table without the grid
Posted: Monday, July 9, 2018 12:15:04 PM
Hi,
Im working on a table that is illustrated in the attachment, and im doing this in Altova Stylevision. I want to make a table without the tablegrid, but with the spacing s.a. it's clear that its a table
Any suggestions on how i should make this table s.a. it looks similar to my illustration?
Ive already tried Stylevisions Static table and then manualle put the spaces, but problems occure when the stringsize differ.
The fields are populated by a XML schema
Thanks in advance :)

Topic: Nested Loops
Posted: Monday, July 9, 2018 8:13:05 AM
I got a followup question on this topic.
Consider the same case as mentioned above, but now each person want to have a unique image representing the animals attached to their page as well. (ea Carl wants a picture of his goldfish on his page, John want a group picture of the Kagaroo, Chimpanze and Iguana etc... point is only one picture per persona page)
How do i implement that?
The images are stored locally.
Topic: Embed images in header
Posted: Friday, July 6, 2018 7:54:49 AM
I want to embed a logo in my header s.a. it appears on my db system.
Per now, i do the following:

1. Make a header
2. Click on insert images
3. Adds the static address

the picture then appears on stylevision and the generated pdf

However, when i try to do it on my system, the picture dissapears. Every other attributte/content still remains except the picture.
Any suggestions?
Topic: Nested Loops
Posted: Wednesday, July 4, 2018 1:19:57 PM
it worked! thanks :)
Topic: Nested Loops
Posted: Wednesday, July 4, 2018 11:31:50 AM
I'm going to make a case that demonstrates what I want to achieve.

I have three people James, Carl and George.
Each of these people have pets.

James => cat, mouse
Carl => goldfish
George => Kangaroo, Chimpanze, Iguana

I want to make a three page PDF that display the person and the pets that he owns on each page.

Page 1:

Name: James

Pets: Cat, mouse

Page 2:

Name: Carl

... and so on

Suppose that the XML look something like this:

<?xml version="1.0" encoding="UTF-8"?>
<DOCUMENT>
<DATA>
<ROWSET1>
<ROWSET1_ROW>
<PERSON_ID>1</PERSON_ID>
<PERSON_NAME>James</PERSON_NAME>
</ROWSET1_ROW>
<ROWSET1_ROW>
<PERSON_ID>2</PERSON_ID>
<PERSON_NAME>Carl</PERSON_NAME>
</ROWSET1_ROW>
<ROWSET1_ROW>
<PERSON_ID>3</PERSON_ID>
<PERSON_NAME>George</PERSON_NAME>
</ROWSET1_ROW>
</ROWSET1>
<ROWSET2>
<ROWSET2_ROW>
<PET_ID>1</PET_ID>
<PERSON_ID>1</PERSON_ID>
<ANIMAL>Cat</ANIMAL>
</ROWSET2_ROW>
<ROWSET2_ROW>
<PET_ID>2</PET_ID>
<PERSON_ID>1</PERSON_ID>
<ANIMAL>Mouse</ANIMAL>
</ROWSET2_ROW>
<ROWSET2_ROW>
<PET_ID>3</PET_ID>
<PERSON_ID>2</PERSON_ID>
<ANIMAL>Goldfish</ANIMAL>
</ROWSET2_ROW>
<ROWSET2_ROW>
<PET_ID>4</PET_ID>
<PERSON_ID>3</PERSON_ID>
<ANIMAL>Kangaroo</ANIMAL>
</ROWSET2_ROW>
<ROWSET2_ROW>
<PET_ID>5</PET_ID>
<PERSON_ID>2</PERSON_ID>
<ANIMAL>Chimpanze</ANIMAL>
</ROWSET2_ROW>
<ROWSET2_ROW>
<PET_ID>6</PET_ID>
<PERSON_ID>2</PERSON_ID>
<ANIMAL>Iguana</ANIMAL>
</ROWSET2_ROW>
</ROWSET2>
</DATA>
</DOCUMENT>

I'm kind of stuck on this problem, so thanks in advance to any one that respond :)
Topic: Dynamic Pages
Posted: Tuesday, July 3, 2018 7:09:33 AM
Stupid question, but how do i open the sps file correctly? when i open it, a warnings saying a Critical Error has occured.
("DB connection or data retrieval failed. Database Connection Error.
Reason: Failed to connect to the database
COM Error: "unkown error 0x800A0E7A" Description: "Provider cannot be found. it may not be properly installed"
Warning: the selected db objects have not been loaded because db connection could not be established!
Warning: Could not resolve match "Names" in template (DB table)")
Topic: Dynamic Pages
Posted: Monday, July 2, 2018 7:35:15 AM
Hi!
Was wondering how to make dynamic pages?
ea. where i got multiple names, and want each name on each seperate page. the name is from a db schema.
Topic: Correct Lineshifts
Posted: Friday, June 29, 2018 8:46:01 AM
Hi!
Are there any ways to allign text at the same way as if you were using tab in some other texteditor?
im generating pdfs from xslt-fo files with Stylevision, and it doesnt seems to support the tabfunction.
Any other way to fix it so that i dont have to manualle type in spaces?

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.