I have a couple of reports that were developed in Crystal which needs to be migrated to BO XI 4.0 InfoView.
In most of it, the display of the records is in two columns i.e., similar to the data display in a dictionary - first the left column is filled and then the right of a page before the next page is filled in.
Now this is a feature in Crystal where I can specify the printing order.
Does anyone know of any way to achieve this in BO XI 4.0?
I’m not sure I understand. If it works in Crystal Reports, why not keep it in Crystal Reports? It can be viewed, refreshed, and interacted with, in BI Launchpad (Formerly known as InfoView).
Sorry, but I guess I should have explained it. The purpose of moving it to BO XI 4.0 is that in Crystal the report was using stored procedure. Now the logic in the stored procedure is being moved into a universe (with tables, not the stored procedure) and the report needs to be developed (from scratch) in InfoView.
So is there any way of getting this in InfoView or is it expecting too much from BO?!
I’m still a little confused (though the fog is starting to clear). InfoView is not a reporting tool. You don’t actually build reports with InfoView. However, you can build Web Intelligence documents in InfoView. Is that what you mean?
Web Intelligence does not currently have the ability to split a table into multiple columns, like you can do in Crystal Reports. So, what I suggest, is that you continue to use Crystal Reports, but use the universe as the source for Crystal Reports.
Yes, that’s what I meant (guess I really have to work on framing my words into a more meaningful manner!)
Okay. So getting that functionality in Web Intelligence (or InfoView) is out of the question. But you say that I can get the universe to act as the source for my Crystal report. So would this mean that I can get the Crystal report (that was using stored procedure as its source), change its source (like how we change the source universe in a report) to the universe and get the report to run? Sorry if my query is silly, but I have not worked on Crystal.
I haven’t worked a whole lot on Crystal, either. But when you start a Crystal Report, and open up the list of connections, you’ll find a folder called Universes. When you select that folder, you will be prompted to log into BusinessObjects, and then will be presented a list of universes.
However, I don’t know if you can take an existing Crystal Report, and change it’s data source to a universe. I’m going to move this topic to the Crystal Reports forum, and perhaps someone there can answer the question.
Technically yet, under the Database menu item, select Set Datasource location. You should be able to select any data source that you have access to. Now if the field names do not match, then you will need to map them.
(BOB member since 2002-08-08)
(BOB member since 2002-08-08)
(BOB member since 2010-06-23)