Recent content by aks12

I found the answer to my own question... The DSN does not actually store the password, so the credentials have to be filled in manually in BO. I'll let my BO admin know.

That's the funny thing, it was a read-only password for the "crystal world" that was set up. The data being accessed though is highly propietary and the DBA doesn't want a generic login floating around. So I take there is no way to configure BO to use the DSN (which already has the password...

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...

taupirho, your solution did the trick for me. I should have explained in my original post that my table was ordered on a customer name which is why Branch_ID could be repeated in later rows. My ultimate purpose is to create a report where I can force a page break after each change of...

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 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 equal the previous record. Below is a sample of data and what I'd expect the query to return. I've tried a...

lbass, your solution is close, but it's giving me extra rows and assigning event end dates to claim# where it shouldn't. Here's the output I get when I set up the join and formula you suggested: Claim#  EventID Event_Begin_Date Event_End_Date 00123 1 4/22/10 1:23pm 3/31/10 9:26am 00123...

I'm using Oracle 10g. I don't have any write access to the database, so a command object would be great.

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...

Please ignore this post, I need to put in a better thread title.

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 hope I'm not misunderstanding your intentions, but if you just need a count of Mondays, Tuesdays, Wednesdays, etc. why not create a group on your weekdayname(dayofweek({CallArrivalPattern.CallDate})) field and then create a summary count on your group?

I solved this by first creating a calculation that creates a count of the months if my measure > 0. Then I created a calculation that summed the measure in each column. Then it was easy to create an average calcuation like [Count]/[Total].

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...