Recent content by ns130

Well, passed the level 2 exam with 88%, Very poor exam again, so many questions that just didn't make sense or were completely ambiguous. I had the same question distribution as you.

Thanks, that's very helpful, I'll let you know how I get on ns130

Well done, I took the Level 1 exam last week and passed (91%), I just used Annette's CRCP Book for CR10, read through section 2 and did the sample exams. I too felt the exam was very poorly written and many of the questions were ambiguous or didn't give enought information. I have the level...

Try SELECT COUNT(1) As 'NiceFieldName' FROM oradba.up_user WHERE TRUNC(date_created) >= ADD_MONTHS(TRUNC(sysdate), -12) To change the name of the field

Hi, I am looking to take my CRCP exams soon and have been reading through Annette's book. I have only ever used version 9 but am not too worried as not too much seems to have changed in 10 and XI. What does worry me is that the exam seems very much about how thoroughly you know the product...

Thanks Juliane, I didn't think there would be. I got round this by returning all the rows and hiding the ones I don't need in the datagrid (working in an ASP.NET project). It is just a small internal project and I am in control of the data so returning everything isn't a problem, Thanks for...

Hi, I have a query which runs against a set of columns which changes quite often. I would like to run a SELECT * FROM XYZ, but exclude certain named columns, is this possible? Thanks

I think the option only appears if you are using a compatable datasource (such as SQLServer), what are you using?

Just a note: You should always use ToNumber({X}) with NumericText({X}). This function will return true if the string can be converted to a number and prevent the error you are getting: If NumericText ({X}) Then ToNumber ({X}) Else 0

Hello, I have a number of reports (written in CR v9) which currently run off my personal PC on our intranet. I add the reports to a Visual Studio ASP.NET web application and it works fine. I really need to move these reports onto a server now but am unsure of the way to go. I have followed...

Hi people, I have a report (in Crystal Reports 9 Dev Ed) which uses the 'Outlook' data source to pull in appointments from some calendars. I use this data to create a report showing multiple calendars at one time. This report works fine on my PC, but I need to host it on an intranet. For...