Search results for query: *

Thanks!!! Good point and good catch. Are there Any ideas or suggestions on where to start with the SQL syntax. To convert date/time? I've only worked with date objects in the past.

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

For WEBI reports you can connect to a Universe or other datasources are Text/Excel files or Web Services. Unfortunately you will have to create a universe that connects to your SQL data source. m Otherwise you can use Crystal reports it can connect with an ODBC directly to the database. Good...

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?

Is that on the online help section with SAP?

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

Thank you for the suggestion. The universe is also being used by WEBI reports. We decided to use a COMMAND in crystal to call the fields that we need. So far it is working appropriately.

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?

Thanks everyone...I'll give a run on the stored procedure angle and if that doesn't work out I'll have some other options to try with the UFLs and the crystal command. I appreciate the help.

Awesome, this is done within the SQL stored procedure then not within the report. So the initial data connection would be made to the stored procedure and the report would always be up to date. This sounds like it would work. Thanks for the great suggestion.

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

No they are not for the same row at all they are completely different from each other...on e is for a completed activity and the other is the date an article was created. They will never be associated. I've filed a ticket to find out more details on the fields. I just have to wait.... I was...

Sorry, it was funny and I was laughing at myself that I was just looking at 2 different pieces of information. When he asked me if I was sure that the number I was looking at was the same. I am working with the Completed_Date_Time field in one table and DATE_TIME_INSEC field in another...

Hahaha...no. I used a different number then I was looking at in the table.... 1,315,575,091,648 is what I am currently seeing....I am converting to12/13/1901

When I used dateadd("s",{EGPLR_ACTIVITY_SNAPSHOT.COMPLETION_DATE_TIME},date(1970,1,1)) The results I got were 12/13/1901 which seemed weird...how are you arriving at 10/26/2011?

I am trying to find out what the date actually is...it's a new development so I don't have access to the tables...I'm only seeing what I can see through Crystal. I also am not sure on the field is defined in the table...hoping to have some answers very soon. @ Lbass - there was mention of the...

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

Thank you for the explaination on the count vs sum on a contional formula. These variable formulas worked great. I hadn't even heard of the function inrepeatedgroupheader. Thank you for the help.