Crystal Reports

I am curious if anyone is using a reporting app such as Crystal with Livelink 9.x. I have seen a number of items related to Basis and IRIMS, but not much on whether it works with Livelink.

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkCrystal Reports will work with the Livelink schema.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, August 28, 2002 11:24To: eLink RecipientSubject: Crystal ReportsCrystal ReportsPosted by CAPONE012 on 08/28/2002 11:22 AMI am curious if anyone is using a reporting app such as Crystal withLivelink 9.x. I have seen a number of items related to Basis and IRIMS, butnot much on whether it works with Livelink.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

John_Shoun

We have done some trials and it is possible to use Crystal Reports against the Livelink database. The challange is training the report developer to understand the Livelink schema if they are not already familiar with it.In the area of reporting, our largest challenge has to do with the new schema for categories and attributes. It is better than the previous one for providing flexibility, but we are running into problems where is does not scale with large data sets. If you have large numbers of objects that use the same category, reports that filter on a given attribute values are very slow.

Jamal_Saket_(offsup023_-_(deleted))

I think it's better to create view first(save it in schema), even index it if it's sql2000 for instance and use it in crystal.By the way, does anybody know how incorporate crystal into livelink - rpt files can be open in crystal viewer from client machines?Thanks, Olga.

eLink User

Message from Mohsin Jessa via eLinkI have noticed that in some cases creating an index on the right column forthe llattrdata table will help significantly.It all depends on the sql being used in the report. Each report may requireit's own index or a set of indexes. If you have an oracle d/b you may alsoexperiment with various index types (bitmap, reverse, etc..) depending onthe data (cardinality, datatype etc...) in those columns.Hope this helps.> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [mailto:livereportsdiscussion@elinkkc.opentext.com]> Sent: Monday, September 02, 2002 11:13 AM> To: eLink Recipient> Subject: Crystal Reports and Livelink>>> Crystal Reports and Livelink> Posted by NortelNC Admin on 09/02/2002 11:09 AM>> We have done some trials and it is possible to use Crystal> Reports against the Livelink database. The challange is training> the report developer to understand the Livelink schema if they> are not already familiar with it.>> In the area of reporting, our largest challenge has to do with> the new schema for categories and attributes. It is better than> the previous one for providing flexibility, but we are running> into problems where is does not scale with large data sets. If> you have large numbers of objects that use the same category,> reports that filter on a given attribute values are very slow.>>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Crystal Reports> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objI> d=2830746&objAction=view>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objI> d=2249677&objAction=view>> Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe>>>

eLink User

Message from Alex Kowalenko via eLinkMohsin is right, John, additional indices can improve attribute queryperformance. I have also found that structuring a complex query in terms ofsubqueries for attribute data can have a dramatic performance boost. Writeme directly for more details.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, September 04, 2002 11:02To: eLink RecipientSubject: RE Crystal Reports and LivelinkRE Crystal Reports and LivelinkPosted by eLink on 09/04/2002 11:01 AMMessage from Mohsin Jessa via eLinkI have noticed that in some cases creating an index on the right column forthe llattrdata table will help significantly.It all depends on the sql being used in the report. Each report may requireit's own index or a set of indexes. If you have an oracle d/b you may alsoexperiment with various index types (bitmap, reverse, etc..) depending onthe data (cardinality, datatype etc...) in those columns.Hope this helps.> -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion> [mailto:livereportsdiscussion@elinkkc.opentext.com]> Sent: Monday, September 02, 2002 11:13 AM> To: eLink Recipient> Subject: Crystal Reports and Livelink>>> Crystal Reports and Livelink> Posted by NortelNC Admin on 09/02/2002 11:09 AM>> We have done some trials and it is possible to use Crystal> Reports against the Livelink database. The challange is training> the report developer to understand the Livelink schema if they> are not already familiar with it.>> In the area of reporting, our largest challenge has to do with> the new schema for categories and attributes. It is better than> the previous one for providing flexibility, but we are running> into problems where is does not scale with large data sets. If> you have large numbers of objects that use the same category,> reports that filter on a given attribute values are very slow.>>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Crystal Reports> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objI> d=2830746&objAction=view>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objI> d=2249677&objAction=view>> Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe>>>[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Crystal Reportshttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2830746&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Jamal_Saket_(offsup023_-_(deleted))

Is anybody know what's the best technique to implement Crystal Reports within LiveLink?I installed Crystal Web Component on the same Web Server LiveLink is accessing and by adding urls to LiveLink I'm able to process Crystal Reports, I can't use simple LiveReports because the reports I'm creating use a lot of "totals" on object attributes (LLAttrData), the subreports is not the option as well, because user would like to see and print "the whole picture" without clicking.The problem with Url solution is report parameters - i can pass them to crystal via url, but how am I going to get them from user? I want to use as much as possible LiveLink out of the box functionality.If anybody has any suggestions - I really appretiate your response. Thanks, Olga.

eLink User

Message from Alex Kowalenko via eLinkOlga,Try this and tell me if it works... create a "customview.html" file with aform to gather the user inputs. Use a JavaScript function to take the userinputs and put them into a URL that calls the Crystal report. Open the URLin a new window to get the output.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Friday, September 20, 2002 09:46To: eLink RecipientSubject: Crystal Reports on LiveLinkCrystal Reports on LiveLinkPosted by OFFSUP023 on 09/20/2002 09:45 AMIs anybody know what's the best technique to implement Crystal Reportswithin LiveLink?I installed Crystal Web Component on the same Web Server LiveLink isaccessing and by adding urls to LiveLink I'm able to process CrystalReports, I can't use simple LiveReports because the reports I'm creating usea lot of "totals" on object attributes (LLAttrData), the subreports is notthe option as well, because user would like to see and print "the wholepicture" without clicking.The problem with Url solution is report parameters - i can pass them tocrystal via url, but how am I going to get them from user? I want to use asmuch as possible LiveLink out of the box functionality.If anybody has any suggestions - I really appretiate your response. Thanks,Olga.[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Crystal Reportshttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2830746&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Jamal_Saket_(offsup023_-_(deleted))

Alex, thanks a lot for suggestion it works!It looks a bit strange though I created a folder with the name Financial Report, saved customview.html in it and configured folder to hide customview.html. So now when user clicks on the Financial Report folder, he/shes prompted with reports input parameters.But its a bit strange for them to click on folder object as oppose to LiveReport or document.Anyway, thank you very much - Olga.

eLink User

Message from Alex Kowalenko via eLinkThat's great. You could embed the folder URL as a button called "FinancialReport" in another customview at the parent or enterprise level.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Tuesday, September 24, 2002 12:09To: eLink RecipientSubject: It Works!It Works!Posted by OFFSUP023 on 09/24/2002 02:22 PMAlex, thanks a lot for suggestion it works!It looks a bit strange though I created a folder with the name FinancialReport, saved customview.html in it and configured folder to hidecustomview.html. So now when user clicks on the Financial Report folder,he/shes prompted with reports input parameters.But its a bit strange for them to click on folder object as oppose toLiveReport or document.Anyway, thank you very much - Olga.[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Crystal Reportshttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2830746&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Bruce_Sandeman_(brucesandeman_-_(deleted))

Hi Olga,I am currently trying to research how best to integrate Crystal Reports with Livelink.Could you tell me how you've done this such that you just pass a url to retrieve a report? Does it use Crystal Enterprise? If so which version?any advice would be most appreciated.cheersBruce

Harry_Johnson

Hi Olga, Like Bruce I am currently researching how to integrate Crystal Reports with Livelink. You appear to have already accomplished that. I have similar questions as Bruce. I would like to see as an example one of the URLs that gets created to retrieve a report. My plan is to write an asp page which gathers the information and passes the URL. This asp page can be called by a URL object in Livelink. And did you install Crystal Enterprise on the same server that Livelink was installed on. And where within the folder structure of tha server was it installed. Thanks, Steve

Sally_Plows_(splows_(Delete)_2164872)

Is there any documentation on how to use/build Crystal Reports with Livelink? A client is looking for this.thanks,Sally