Recent content by techie2

Thanks guys, I figured it out. I should have used "ALL" statement before to handle nulls. This is how the stament should look like. ({?Parameter} = "ALL" or {table.field}={?parameter}) Thanks.

If database filed has null or blank, those records are not showing up in the report output. Do you know how to pull the null values with this statement: ({table.field}={?parameter} or {?Parameter} = "ALL") I have null's / blanks in {table.field}. Thanks, techie2

Hi, Using CE 10.0 + SP4, CR 10.0, CMS is SQL Server, Reporting database is Oracle 8i, Authenticating againts LDAP. This environment has been up and running from couple of years now. Whenever we have new LDAP user in the system, I assign the folder to each user and along with these rights, I...

Can somebody please give me some insight to start with this request? or If somebody has some sample code, which can get me started, that would be really helpful. Thanks and Happy Friday :-)

I definately think this is related to CE 10.0 limitation or some bug. We have CE 10.0 + SP4 setup and I am never able to schedule any of my jobs to printer directly. I have tried so many thing and only 1 way I was able to work was having that printer installed on the CE Server. With having a...

Hi Folks, Using CE 10.0 + SP4 with SQL Server as CMS Database and Oracle as Reporting Database. I have been asked to list down the names of reports which has Email Distribution List (With all the Email addresses), FTP Distribution and its properties and any Unmamaged and Printer Jobs set on...

Thanks LB They do change quite frequently. Do you have any other suggestions to get this implemented or this is just not possible. I know I can do that by having a lookup table but then updating that lookup tables is almost impossible. techie2

Main report only have cost centers and does not save VP's names on the database For getting VP names, sub report is going against Oracle DB and displaying the VP name. Next part of the requirement is group by VP name and display the subtotals. VP report can not be main report becuase main...

Hi, Using CR 10.0 Main report is pointing against SQL Server DB. Sub Reports is pointing against Oracle database. Both reports are linked by cost center. Sub reports pulls names of VP's based on Cost Center. I want to group on this VP name on the main report. Is it possible? Thanks in...

Thanks for the reply. I read the platforms.txt file for CE 10.0 and it says only client and reporting database supported for oracle are 8i and 9.2 I just wanted to make sure that it will work fine with 10G Client and Reporting database even though it is not said in the platforms.txt

Hi, I have CE 10.0 + SP4 setup on production servers using iPlant LDAP Authentication. I am trying to setup same environment on our new development boxes. I know I can use the import wizard to import everything from Prod to Dev, but do I need to do some steps before start migrating everything...

Hi, We have CE 10.0 + SP4, with Oracle 8i clinet. Reports are going againts 8i Oracle Server. We are upgrading Oracle 8i server to 10G version and as per our Oracle DBA, we should also upgrade Oracle 8i clinet to Oracle 10G on CE Server. My question is, does CE 10.0 support Oracle 10G clinet...

I am sorry, I meant to start a new thread.

Hi, We have CE 10.0 + SP4, with Oracle 8i clinet. Reports are going againts 8i Oracle Server. We are upgrading Oracle 8i server to 10G version and as per our Oracle DBA, we should also upgrade Oracle 8i clinet to Oracle 10G on CE Server. My question is, does CE 10.0 support Oracle 10G clinet...

Refer to this article for getting headers on each page of sub report: http://technicalsupport.businessobjects.com/Publishing/74/c2005103_f.html For getting same information on footer for each page of subreport, refer: http://technicalsupport.businessobjects.com/Publishing/315/c2014229_f.html