Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ianclarke

    Unknown Member & Null Processing

    Hi I have followed Kimball methodology by including an unknown member in each dimension in the relational database. In the case of a time dimension I have an unknown member with key value -1. All time related fields, e.g. FullTime, Hour, Minute, etc are NULL in the database. I have a field...
  2. ianclarke

    Some dimensions not processing

    Hi All I'm building a new cube. When processing some dimensions will process successfully, but others won't. All dimensions are in the same database, so security should be the same. If I take the queries and run them in management studio I get results without any problems. In the Process...
  3. ianclarke

    Passing a date parameter value from a report to another Excel rendered

    Hi Geoff Thanks very much for your help. After fiddling around a little with string you provided, it is now working. The final working url is: ="http://server/ReportServer?/reportsfolder/Test1&rs:Format=EXCEL&rs:Command=Render&Date=" & Parameters!StartDate.Value It actually accepted the date...
  4. ianclarke

    Passing a date parameter value from a report to another Excel rendered

    Hi I've been trying to put a link on a report (SQL Server 2005 Reporting Services) to a url which will render another report in Excel. I have successfully linked test reports to get the Excel export without any parameters, I have successfully passed a parameter through with a constant, but I...
  5. ianclarke

    Dual boot XP Home with XP Pro

    Hi I currently have Windows XP Media Center Edition installed on my desktop. I have also got a lot of media, files, work, etc on the desktop. I don't have an external or second hard drive to back up my data. I want to learn more about ASP and PHP but unfortunately XP Media (based on Home)...
  6. ianclarke

    Data Execution Prevention

    Hey All I have just solved the problem by removing Atomic Log from startup. I can't believe it caused all these problems. I have not uninstalled it - just removed it from startup. What a relief. Thanks for your time and replies. Ian
  7. ianclarke

    Data Execution Prevention

    I have just shutdown and restarted. Still the same errors!
  8. ianclarke

    Data Execution Prevention

    Your responses are much appreciated! Jason: I have checked the DEP settings and they were already on for Windows services only - it is only Windows services that are returning the errors, i.e. Explorer / Task Manager / ConnectionsTray / rundll32.exe. I have run AVG anti-virus again and all's...
  9. ianclarke

    Data Execution Prevention

    Hi I'm getting a repeating error since rebooting my laptop immediately after scanning with AVG, Ad-Aware, SpyBot and Bazooka and then running a disk check which required the reboot. The scans returned no viruses and only 3 objects were removed by Ad-Aware. I missed the end of the disk checking...
  10. ianclarke

    Not ready not displaying pn phone

    Just configured a call centre phone. For some reason when logged in it does not display not ready status on the phone but does through Symposium. Replaced phone and still the same, and checked the configuration and its the same as other call centre phones. Any ideas to what could be wrong???
  11. ianclarke

    win2k to xp networking

    Hi Is there any difficulty in setting up a home network over Windows 2000 Pro and XP Home? If possible, would there be any disadvantage in using the Win2k system as the internet server? I am setting up a wireless network between an XP laptop and a 2000 desktop. As you can imagine, I'd like to...
  12. ianclarke

    Scheduled Jobs

    Hi Denis By 'create the data source on the sql server' do you mean create the DTS and job while on the sql server? Or do you mean create the ODBCs on the server? I have checked the Data Sources on the server from Control Panel - Administrative Tool - Data Sources (ODBC), and they are fine. Ian
  13. ianclarke

    Scheduled Jobs

    Hi I am having a lot of difficulty setting up scheduled jobs to backup tables from Symposium Call Centre Software. The DTS packages are running fine, when called manually, but the jobs always fail to run. The following is the error returned: Executed as user: NHSDW\sqladmin. DTSRun...
  14. ianclarke

    Automatic SQL Server backups

    Hi I am having a lot of difficulty setting up scheduled jobs to backup tables from Symposium. The DTS packages are running fine, when called manually, but the jobs always fail to run. The following is the error returned: Executed as user: NHSDW\sqladmin. DTSRun: Loading... DTSRun...
  15. ianclarke

    Intervals?

    Hi Can anyone tell me what period of time an interval covers. For example, is the 07:00 interval summarising the activity from 06:45 to 07:00, or is it covering the period from 07:00 to 07:15? Ian
  16. ianclarke

    how do export the rpt to excel without the space?

    Hi Align your data in the Crystal Report using the vertical tabs with a tab for the begining and a tab for the end of each field. Use the end tab of one field as the start tab of the next so that all your fields are vertically aligned into columns and there are no empty gaps between them...
  17. ianclarke

    Voice Recordings in CallPilot

    Hi We have recently had CallPilot installed. This means that the Voice Prompt Editor may no longer be used and voice recordings can be played through CallPilot Player. Unfortunately, the messages cannot be altered/edited with CallPilot Player. Can anyone recommend an alternative method to edit...
  18. ianclarke

    Skillset Script Variables

    That answers my question - thank you very much. Ian
  19. ianclarke

    Skillset Script Variables

    I have not yet tried to, but if you can't queue to a skillset script variable, what do you use them for?
  20. ianclarke

    Skillset Script Variables

    Hi If you assign a group of skillsets to a script variable, does this mean that a call queued to the script variable is in fact queued to each of the group of skillsets? Ian

Part and Inventory Search

Back
Top