8 Replies Last post: Jul 22, 2008 9:24 AM by Stephano  
Alessandro   17 posts since
Jan 14, 2008
Currently Being Moderated

Jul 11, 2008 1:42 PM

Copy project with problem in field SEQUENCE

When I created a new project from a copy of another project, I supposed that the informations about SEQUENCE of all the copied itens must be there. But this is not working.

The field SEQUENCE, mapped in the BIRT library (originary from ITEMS data set, and accessed by row is null on the table. This field is used to define the identation of itens in the reports like srs_idented.rptdesign.

Althought I'm creating new itens in the new project (created from another project), this field SEQUENCE was generated as null.

Stephano   167 posts since
Jan 14, 2008
Currently Being Moderated
1. Jul 11, 2008 2:56 PM in response to: Alessandro
Re: Copy project with problem in field SEQUENCE

If you run the report named "System Specification - Left Aligned", it will fill in the sequence numbers.  That report generates the squence each time it runs, so if anything changes, it still has the correct order.

Kevin DeVries   48 posts since
Jun 29, 2007
Currently Being Moderated
3. Jul 16, 2008 12:39 PM in response to: Alessandro
Re: Copy project with problem in field SEQUENCE

 

I'm having a similar problem, only with an existing project (in 2.3.4)

 

 

Some of my items don't have sequence numbers at all. Editing and/or moving the items don't create a sequnce number for that item. I've even tried moving from the folder to another. New items seem to get a valid sequence number, new folders don't.

 

 

In reports, some items that have been moved from one folder to another show up under the old folder with a sequence number belonging to the new folder (this is without 'Sort' selected for the report - selecting 'Sort' just makes things worse).

 

 

Some items have the same sequence number.

 

 

See attached image from a partial report.

 

 

Attachments:
Stephano   167 posts since
Jan 14, 2008
Currently Being Moderated
4. Jul 16, 2008 2:27 PM in response to: Alessandro
Re: Copy project with problem in field SEQUENCE

Alessandro, are you running the report named "System Specification - Left Aligned" in Contour?  It should fill in the sequence numbers for all items, even folders.  You cannot just run it in BIRT though, it has to be run in Contour.

 

I've tested this with new items and new folders in 2.3.4 and it works fine on my end.

Stephano   167 posts since
Jan 14, 2008
Currently Being Moderated
5. Jul 16, 2008 2:25 PM in response to: Kevin DeVries
Re: Copy project with problem in field SEQUENCE

Kevin, see my response to Alessandro above.  You have to run an "SRS" report in Contour.  When you do that, Contour will look at the order of all items and folders in the set you just ran it on, and sequence them accordingly.  If you change the sequence in any set, you have to run an SRS report for that set to get rid of NULL values, and disordered items.

Stephano   167 posts since
Jan 14, 2008
Currently Being Moderated
6. Jul 17, 2008 2:53 PM in response to: Kevin DeVries
Re: Copy project with problem in field SEQUENCE

 

Just for the record, Kevin's problem was a bug.  He was getting an error that we had to fix in one of the xml config files.  So if anyone is getting a hard error with this problem, email me at scetola@jamasoftware.com.

 

 

 

 

 

 

Alessandro, if you are still not getting a sequence number, please let me know.  

 

 

Stephano   167 posts since
Jan 14, 2008
Currently Being Moderated
8. Jul 22, 2008 9:24 AM in response to: Alessandro
Re: Copy project with problem in field SEQUENCE

Glad that worked out.  We'll be adding more features to reports and making them easier to use in the future.  Let me know if you run into any other issues.

More Like This

  • Retrieving data ...