Recent content by idd

This is still causing me problems, any other ideas

Thanks for responding Denny, sorry for the delayed response I have been out of the office for a few days. I had recreated a folder, Also I checked the location you mentioned msdb.dbo.sysssispackagefolders and that table does not seem to exist, I have also checked this for that folder on...

Hi I am using SQL 2005, ----------------------------------------------------- Summary Maintenance plans are not showing under database engine under the manangement section, so I cannot view or modify it ----------------------------------------------------- I had a few maintenance plans on...

Hi There fortunately are baclup team managed to salvage a proper backup of the server from the night before, That was just lucky, note to all who read this thread, make sure you have backups of all systems and databases. Thats my first task, take backups of all individual databases and then...

Hi, Ignore the previous thread the title was wrong. Big Problem, hoping for solution soon. Using SQL 2000 A database on SQL 2000 was deleted by a script which dropped and re-created the database. We checked for a backup but it seems the backup failed the night before and there are no .bak...

IDOMillet, Thats a good suggestion, Can I use temp tables in a Crystal report or would this have to be a standard table. Idd

CR85User, The field {activity.act_action_date} is a date time field. the example I will give below is a simplified example of the situation but for the purpose of this thread it would be suitable. Activity table Act_ID Act_start date Act end_date Act_Room Sample data 1...

Madawc, It is grouped by date (Start Date) of the booking. {Activity.ACT_ACTION_DATE} >= {?Startdate} and {Activity.ACT_ACTION_DATE} <= {?Enddate} But the grouping will show the record on the date which matches only the start date. It won't show it for every other day that the booking...

Hi, I am using Crystal 10. I have a report which shows room bookings. it is grouped by start date of the booking. It shows one day per page, with all rooms bookings for that day and will usually be printed of for a week at a time (Monday to Friday) The user can enter a date range (start...

ESquared, I totally agree with that last post, however, the database has been created by an external supplier. I cannot change the statuses but still have to be able to report on them. Idd

Thanks All for your thoughts and comments, I will take these into account and try and implement as many as possible, I will let you know of any outcomes Esquared I usually use this method described by you --better is (not only simpler but tolerant of unicode): (mep_status >= '02' and...

FredericoFonseca, I not too sure what you mean by and mep_status between '02' ||x'00' and '24'||x'FF' Mep Status is not part of an index, It is a varchar field, and the status in the fields are along the lines of 10 - renewal created 12 - reminder 1 13 - reminder 2 22 - current 25 -...

Thanks to all of ou for your advice, I will look into trying this techniques. Idd

I am using SQL Server 2000 and have created a stored procedure so that it can be called in a crystal report, I used the stored procedure to possible speed up the report. however it still takes an awful long time to run and resource utilisation on the Server (Processor usage) goes sky high while...

Thanks for the clarification. Idd