Search results for query: *

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

LBass, Thanks for the help, it worked a treat. I would never have known that inrepeatedgroupheader was a reserved word. Only when I came to work today and typed it in Crystal and the text turned blue did I realise. Could this have been done with Grand totals or summaries, or is there really...

LBass, I just thought it would be you who replies, Thanks for the response, I will try this tomorrow when I am at work. I'm fairly new to Crystal, so will require things written so that a newbie can understand. In the first formula is that if not {repeatedGroupHeader} then or is that that...

Sorry if I've misunderstood BUT Isn't that what everyone really wants, for output to be displayed which meets the criteria? Idd

Hi, I'm using CR 9 I have created a manual Cross tab sort of report. I shall explain the report first then explain what I require. My report is set out as below: GH1 User Initials GH2 Payment Type GH3 Invoice Ref Detail Invoice and payment Details (Suppresed with Drill...

Hi There, My Mistake, the Activity_Xref table values would have unique Identifiers for each row, not the values that I have displayed above. I am referring to the field ActXref_ID the values would not be the same for two records so it would be more accurate as Act_Xref_ID 22 23 24 25 26 27...