Search results for query: *

I am trying to create a "previous week" filter in the universe to use to schedule a weekly report. I have a datetime field and it's giving me issues. PSSI3_DM.AGENTACTIVITYLOG.STATUSDATETIME I thought I could just do something like this. PSSI3_DM.AGENTACTIVITYLOG.STATUSDATETIME >=...

I am trying to create a previous week filter in the universe to use to schedule a weekly report. I have a datetime field and it's giving me issues. PSSI3_DM.AGENTACTIVITYLOG.STATUSDATETIME I thought I could just do something like this. PSSI3_DM.AGENTACTIVITYLOG.STATUSDATETIME >=...

I'm new to BI Platform 4. Using the IDT I need to connect to a SAS dataset. I've created my project, my connection, my foundation and my business layer. When I add the SAS table I saved it's not showing any columns. Does anyone know why this is happening has the occured for anyone else?

I'm trying to create org charts for our business. The org data is in an oracle table. The problem is, I'm not sure how to get the data formatted to work the way it needs to in an org chart. Currently the table has the following columns: Employee Name, Division, Bureau, Section, Unit...

Hi I'm developing a Crystal Report (2008) based on a universe (Oracle). In this universe there are derived tables and multiple contexts being used. I'm getting errors in Crystal that I can't have multiple SQL returned. Does anyone have any suggestions on how we can resolve this issues?

My company is using Crystal Reports 2008 and we have several SQL statements that update temp tables that the crystal report is going to reference. Is there anyway to set it up so that the SQL can be executed before the report is run? We want to eliminate the need to time things and so we can...

I'm using Crystal reports 2008 with a Oracle DB for this report. I have a field called Completed_Date_Time if I display this field in the layout it looks like this. 1,319,637,601.00 This should be a date time field and I need to parse it out to a date so I can pull from a parameter date range...

I am using crystal 2008. I have a chart that is based on formulas I created. In the graph the lables are displaying the @ symbol and the functions (sum of @repair and @Serice AHT etc). In preview I can edit these labels however they do not remain after a refresh. Is there a way to rename...

Using Crystal Report 2008 I've created a report to display the total number of calls per Trunk Group and the total number minutes (duration) of calls per trunk group. Now I'm trying to display the maximum calls (during the specified date range) per trunk group.(peak trunks) Trunk Group...

Does anyone have any suggestions on how to quickly modify existing recurring report instances when a database is moved to another server. Not only do each of the reports have to be opened - pointed to the new server - save - then refreshed... the recurrings also have to be set up from the...

Crystal 2008 I am trying to build a report which groups emails resolved in <=8hr, <= 12hr and <=24hr. I had this working until with this fromula: Datediff datediff('n', ({KC_MESSAGEHISTORY.ACTIONDATE}), {KC_MESSAGE.COMPLETEDATE}) Then I created 3 formulas Resp<=8 : If {@DateDiff} <= 480...

I am running Crystal reports 2008 version 12.2.290 as CR Developer. I have a report with a subreport. In the subreport I have a graph included. Randomly on various runs one of the graphs will mess up. The data labels will overlap and be in an odd order. I initially thought this was related...

If I have this post in the wrong forum I'm sorry..I tired to find the place to post. I am using BO CMC with Crystal Reports 2008. I have a report that I can run locally on my machine that is based on an access database. This database is stored on one of our shared public drives and does not...

I'm working with a cross tab...and I am having difficulty getting a precentage column to function correctly. I have 3 columns Survey Top Box % Top I have 5 rows that are the business units. I would like the % top column to be the % top box to survey. So for example Business Survey Top...

A crystal reports developer is running Crystal Standard V10 on an XP machine. Recently she has been getting a pop up from Windows Installer saying that a resource in unavailable for crystal V10 installer.msi. We've tried a reinstall and we've tried to remove Crystal V10 installer from...