Recent content by AurobindoSaha

Hi, We have around 45000 reports in BOXI 3.1 environment. Many of these WebI and Crystal Reports are scheduled multiple times. I would like to find how many duplicate recurring schedules are there with same parameters. How many of those instances has failed, succeeded, pending and running...

Hi We are trying to connect Crystal 2008 to SAP ECC We have installed the following in our training server, which is one standalone machine - 1. SAP GUI 2. BOXI 3.1 3. SAP Integration Kit 4. Crystal Reports 2008 Now we are trying to connect Crystal Report 2008 to 'SAP Tables, Cluster, or...

Hi We have BOXI3.1, BO MM pre-installed installed in Windows 2003 SP2 32-bit machine and trying to install SAP Integration Kit for Business Objects 3.1 We are facing the error - "The installation of BOXI Integration for SAP Solutions cannot continue because WACS has been installed with BO...

I am using Crystal Report XIR2, on Windows XP, using Sybase Database as my source. I use a commmand object to the write a query to pull records from database tables I am using a cross tab in Crystal Report to find the count (expressed as percentage) of phone calls in every month for last 13...

I think the solution is this - We can pass parameters to OLAP Cube from Crystal reports through OLAP Grid. While refreshing it asks for parameter. This parameter will be passed to OLAP Cube. Find the attached sample report and screenshot that describes the way to define the...

But the challenge I was mentioning was how to use parameters there. Looks like you can not create parameter from field explorer menu and pass to the datasource. Thanks Aurobindo

MDX (Multi Dimensional Expression) is included in Microsoft Analysis Services 2005. http://msdn.microsoft.com/en-us/library/ms345116.aspx Yes, I believe so, it can be connected through ODBC driver. Thanks Aurobindo

Hi Can Crystal Report XI R2 connect to a MDX query? I like to use a parameter that will be passed from Crystal Report to the MDX query (cube) and return the records that match the value of that parameter. In nutshell, I'm looking for a way to pass a parameter to the cube as I pulls back data...

Thanks for your reply Dgillz. I was trying to avoid the table creation complexity as its handled by a different DBA group here. Can the SQL_Expression somehow help to generate the dates?

No, Here I am asking if the user name and password can be passed via the link that will open the report directly in infoworks. - Sort of Single Sign On

Hi, I am using Crystal Report XI R2 and MS SQL Server 2005. Will publish the reports in Infoview. Background - User has input parameters - 1. Input_Date (which is a date parameter) 2. Frequency (which is a string parameter with values - "Monthly" or "Weekly") Requirement - Based on the...

Can anyone help he with this question. Sorry to bounce the thread, but if some one can help me here, it will be appreciated.

I am getting a NullPointerException while trying to open the crystal report using JRC. Attached is the crystal reports version, java version, the program snippet which is used, the output and Exception thrown. I have also attached the config file. It would be great if you could help me debug...

Thank you IdoMillet.

Hi, I am using a dynamic prompt which selects the value from a particular table.column Allow multiple value selection is set to true. While running the report I select multiple values in the dynamic prompt. When I place that parameter in the report header only first value is pulled. Why am...