Search results for query: *

Hello, I am trying to figure out a way to build a table of each hour of every day from 1/1/2003 through 12/31/2010. The table needs only a single datetime column. It will be used to develop a shared datetime dimension in analysis services that other tables with "real" datetimes will...

How do i program a column to show a shift based on the time value od a date field ie if the time portion(HH:MM) of the date time field is between 07:30 and 16:30 then 'Day shift' if between 16:30 and 23:30 then 'Eveneing Shift' etc. Thanks, FB

I have a string field that shows hours, minues, seconds in the following format HH:MM:SS. This field does not map to an actual time format because the hours part could span tousands of hours ie a typical value could be 4458:32:00 which means 4,458 hours, 32 minutes, 0 seconds. I would like to...

Hello, I need to build a view which will be used as a fact table in an Analysis cube. I'm having alot of difficulty trying to extract data from the detail table I'm pulling information from. This is a sample of my detail table clrAlarmTest: alarmID clrDT...

Hello, I do not know much about VBscript but i need to use it to manipulate some data imported to SQL Server from an Excel spreadsheet through DTS. I have two datetime columns in a spreadsheet one has the valid date and the other has the valid time (I know this is dumb but it is how info is...

i have a report in which I've calculated the average of a running total of a datediff field divided by the distinct count of a key field called ticket#. I have #rt, sum distinct count, @avg formulas for each group(one of which is month) in the report and as well as a total for the entire report...

I have a table that contains many records 6 mil today and may grow to over 20m when done. I have a column called alarm_id which can be common to different rows of data. I have other columns called action_a and userid. When a new record comes in with a unique alarm_id the action_a filed is...

Is it possible to create a chart with more than 2 "on Change of fields" I have a report that groups by: Month closed | |-> Region (3 different Regions) | |-> Technology (2 different Technologies) I build a line chart with the "On chage of&quot...

Hi, I've built a rather large report for an entire distrcit that I must also show broken down by Manager level. The data/formulas at the manager level is almost identical to the district level. My plan is to save a copy of the original report with the Save As command. In the new copy of the...

I built a Lotus Notes database which resides on a Domino server. I loaded CR 8.5 Pro on my PC and have written several reports. I would now like to integrate the reports into the Notes DB using RDC(with an action button). I have ordered the upgrade to Developer edition for the RDC. Crystal...

I am doing an org. chart from a Lotus Notes personnel database. Each employee has a record w/ name, ssn, address , supervisor name, manager name, etc. I am grouping by manager name then supervisor to show the organization. Instead of just the manger or supervisor name appearing as groupname, I...

I am new to Crystal Reports. Using version 8.5 Pro. When I read in a Lotus Notes view all of the fields are string datatypes. Even those that are truly Date/Time fields. How can I correct this so I can do a record selection based on a date/time value? Thanks, Frank B.