Search results for query: *

Hi, I am working with CR XI R2 and SQL Server 2005 stored procedure. I have a requirement wherein, I need to split a row into multiple rows if values of a field is greater than e.g. 20 million. So 66,000,000 should split into 4 rows of 20, 20, 20 and 6 millions. /*** For Example ***/ SQL...

Dear friends, I have a crystal report that uses XML file as a data source - ADO.NET (XML). I have published this in Business Objects XI R2 envt which is a cluster of 2 identical BO servers. This report when gets scheduled on server A's report job server, it runs perfect but when gets...

Hi all, Is there any way of generating password protected pdf/xls output file from business objects xi r2? Any help appreciated.

Friends, Is there any way to generate password protected PDF/XLS file off Seagate Info 7.5? New requirement has come up to have all these files to be password protected. Please help.. Thank You,

Hi all, I have set of reports in Seagate Info 7.5 that are designed using Info SQL Designer. The set up is: I have three Query Templates ('.qry' files) that run on stored procs (Let's name them A, B, C). Then I have recurring jobs set on these Query templates which stores data in Crystal...

Thanks for reply synapsevampire, It works fine. I didnot change any set up. I was setting up ODBC wrong way. My experience - seagate info 7.5 works perfect with SQL Server 2005. Thanks for your help.

Hi prgmrgirl, This is one of the most encountered error msg when scheduling a report. I have similar set up and get this error quite often. First thing I check is set Location Properties. Open report in designer --> Database menu --> set Location --> check server Type/ Server Name/ DB/...

Hi prgmrgirl, This is one of the most encountered error msg when scheduling a report. I have similar set up and get this error quite often. First thing I check is set Location Properties. Open report in designer --> Database manu --> set Location --> check server Type/ Server Name/ DB/...

Hi all, Can someone please help me here? I need to upgrade Visual basic 6.0 application which is using Seagate Info 7.5 to use Business Objects XI. This app was designed few years back to use seagate Info 7.5 to generate Invoices and summary for customers. General Process flow is...

Gentlemen, We are migrating from Seagate Info 7.5 to BO XI and Crystal Reports XI. Our Billing System is a Visual basic 6.0 app - which uses SI 7.5 to generate Invoices, summary, etc. This VB app uses CVWAX32.EXE and SENTNL32.EXE. Also ciapi32.dll/ciapi32.bas comes into picture defining...

Hi, Sorry for being late to reply - was bz on other project. I tried new report - that works fine. 2nd - changed ODBC to new 2005 server. when I refresh report from its template it works fine but when I schedule it from INfo Desktop - fails with same error: PEStartPrintJob : Error detected...

Hi, We are in process of migrating from SI 7.5 to BO XI and upgrade of SQL Server to 2005. I was wondering if SI 7.5 is compatible with SQL Server 2005? As a simple test I pointed ODBC to new SQL 2005 box and ran report - which failed with following error: PEStartPrintJob : Error...

Hi synapsevampire, I am sorry, don't know what I was thinking, they are fields not parameters. In final select clause, I don't have any function but I am selecting one of the parameters passed and one declared variable in SP and two fields from temp table. Query (Final select): select...

Hi all, I have a set of reports that are running in Seagate Info 7.5. They are based on Info Query Designer (.qry) file. I have .qry file that runs 6 times a day and sets event. I have reports in Info Desktop having recurring schedule for each customer that picks up data from that .qry...

Hi all, I am not sure if issue belongs to this forum. I did not find much about this error in any forum. I migrated a report from Seagate Info 7.5 to Crystal Reports XI using Data Source Migration Wizard. So far I have migrated @ 50 reports. When I open report in CR XI and try to Verify...