Hi Qaseem,

I have been caught multiple times with earlier Crystal Reports and when it first comands/SQL within the Page/Header/Footer begin and end sections. I normally tried to build a...

Hi

Sorry about the original SQL, it was using MS SQL syntax and not Oracle. Anyway try this. I tested this on Oracle Express 10 and it looks like...

Hi

To find out if Crystal Reports is behavioring correct you really need to speak to a DBA to run SQL profiler. They will want to know why something is...

Hi

By default the connection timeout is set to 30 seconds, so if the connection does not have timeout=600; in it, it willl default to 30 seconds.

I normally set...

Hi niall

You can do the same thing with PRINT command

declare @retcode int

set nocount on

select @retcode = 0

while @retcode < 1000000

begin

print @retcode...

Hi

If SUTTER-CHS\SC.IT_Data_Services is a domain/local group then you cannot change the login, it is by design.

See http://msdn.microsoft.com/en-us/library/ms189828.aspx

See http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3544179&SiteID=17

If it is a domain/local user then you can do...

Hi Steve,

Have you used SQL Server Profiler to confirm it is the queries that are taking that long and the connection startup itself.

If not I would start using...

Hi

Of the top of my head I would suggest the following for the SELECT. It should work, but I don't know the exact layout of your tables.

SELECT...

Hi Grasshopper,

I spotted a simple mistake, you forgot to execute the command! You open the connection and then close it.

Try putting

cmd.ExecuteNonQuery();

between the Open and Close statements this is way...

Hi

Try

ALTER LOGIN [SUTTER-CHS\SC.IT_Data_Service] ENABLE

It normally works with [] around the domain\username.

Regards

Richard...