Search results for query: *

Hello, I uploaded a Crystal report to Business Objects using an ODBC connection to a SQL Server. The DBA does not want me to have the SQL Server login credentials so I asked our BO server admin to create a DSN on the BO server. Can the report on the BO server use the credentials stored in the...

I accidently hijacked another thread with my own question and I apologize for that. I'll start a new one here. I need help constructing a query that will read a column in a table and assign a unique value to the record (but not necessarily sequential) every time the current record does not...

Hello, I'm using Crystal XI and need some outside advice. I have the following two tables: Claims Claim# EventID EventDate 00123 1 4/22/10 1:23pm 00123 2 4/22/10 1:24pm 00123 3 4/22/10 1:25pm 00299 5 3/31/10 9:26am 00299 14 4/1/10 10:02am...

Hello, I'm using Crystal XI and need some outside advice. I have the following two tables: Claims Claim# Event_ID Event_Date 00123 1 4/22/10 1:23pm 00123 2 4/22/10 1:24pm 00123 3 4/22/10 1:25pm 00299 5 3/31/10 9:26am 00299 14 4/1/10...

Hello, I'm using Sharepoint 2007 and am trying to modify a site using Microsoft Sharepoint Designer. The particular content placeholder I want to modify is PlaceHolderSiteName. I want to change the text and center it in the box instead of having it flush against the logo. I modified the...

I have a simple crosstab in Report Studio that looks at a measure for months throughout the year across a few intervals. I have a calculated member at the bottom of my crosstab that creates an average for each column. My problem is that Cognos is treating nulls as 0 and including them in the...

Using Cognos 8.4, what is the javascript syntax to return the number of entries in a value prompt? I'm not a javascript coder and have been struggling with this. I've tried variations of the code below with no luck. var theSpan = document.getElementById("fromDate"); var theSelect =...

Using Crystal XI... Is there a way to produce alternate line shading for every two lines of detail? white white gray gray white white etc.

Hi, I have Crystal 10 using Oracle DB. I looked at thread767-1345144 for the solution to this, but my setup is a little different. In my main report and subreports, all the data is in crosstabs in the RFs. I want to put 5 subreports in the main report (one each in RFb, RFc, RFd, RFe, RFf)...

I am using CR 10 with Oracle. Data looks like this: RPT_MONTH PRODUCT PERSIST_INT ACCT_PERSISTENCY 05/01/2007 Protect 0 7161 05/01/2007 Generic 0 5 05/01/2007 Protect 1 6306 05/01/2007 Generic 1...

Hello, I'm using CR 10 with Oracle. I've got what is a fairly common problem I imagine, but I can't find any posts here that address it. I want to calculate the maximum of sums and put them in group headers. My group footers are designed to be blank and suppressed. I have data that looks...

I am using CR 10 with Oracle database. I have a crosstab in my report and the user wants the final output format as Microsoft Excel (data only) and all crosstab values as numeric. The first column in the crosstab is a percentage calculation that by design returns 0.00% all the way down the...

Hi, I am using Crystal Reports 10 with Oracle. I have a drill down report with groups set up like this: group 1: quarterly stats for products group 2: quarterly stats for subproducts group 3: monthly stats for subproducts There are two products, A and B. Product B has two subproducts; A has...

Hello, I am using CR 10 and CE 10. I have a report with many columns and margins set to legal size (8.5x14). When I export this report from CR 10 to my desktop in pdf format, I get exactly what I want: a legal size pdf report. When I save this same exact report to Enterprise and run it there...

Hi, sorry the earlier incomplete post. I accidently hit submit instead of preview. I am using Crystal 10 and am having a problem with a crosstab. I am calculating capture rates on a daily then weekly basis in any given month. Capture rate is calls captured/calls handled. I have columns...

Hi, I have a cross-tab that shows # of phone calls by day for any given time period that is determined by begin and end date parameters. My problem is that I want to see zeros for days which may not be included in my data table. For example, instead of this...