Search results for query: *

When is it necessary to use a table variable, a temp table and a derived table in a stored procedure? Does it depend on the total number of records. Lets say the Stored Procedure1 returned 10,000; Stored Procedure2 returned 100,000 and stored procedure3 returned 1,000,000,000 rows. When...

Insert into problem I have information in table variable as: Table1 Location Letter Amount 12 A 0 12 B 0 12 C 1 The information above placed in another table variable must look like: Table 2 Location Letter Amount 12 A 1 12 B 1 12...

How can one call another exe application from a visual basic environment using command line ?

I have a report that has column name CurrentVBDate. I want to populate this column (CurrentVBDate) with data from other columns. The other columns are PreviousVBDate, NextSequentialVBDate and NextSequentialVBDate. I am using CR8.5. Any assistance will be appreciated and thanks in advance for...

Hi There, Can someone tell me how to create a group tree in CR8.5 when a main report has a sub report in it's footer section. Is there a way of showing a group tree when a sub report is embedded in a main report. I need to drill down based on the first group header in both report...

I am using Access in a multiuser environment. The database is used for users accessing information by calling into the system.Users at the same time run reports and do package ordering. The database get corrupted many times in a day. How can this be averted. How much users can access accomodate...

Both some clients we use ASP and the other strict URL.However we are trying to Standardize through ASP code

Web.

I need to drill down without showing the drill-down box for users. All what the user need to do is to click on the header and see all its contents. For example, Group = Country, Second Group = Site. Country is USA and Sites are 123, 456, 789, 800. I need users to click on USA on the report to...

Is there a way of implementing immediate ifs(IIF()) within immediate ifs(IIF()) in access queries. For example, If visit4Days and visit5days does not fall within demand days then order 1. If visit4days and visit5days does fall within demand days then order 2. I have four fields that get...

Thanks. I actual want to use UNICODE.But I do not know how.

Any ideas on how to print or show greater than equal to sign. I do not mean >=. I mean greater than > and the equal to sign is -. Then minus sign needs to be below the greater than sign. Thanks in advance.

How can I use UNicode2265 in vb. Is it like Chr(2265)? Thanks inadvance

I need the >- sign. The - must be below the > sign.

Can anyone please help?????

Hi Naith, I placed one box to cover the first two column fields on the report and another to cover the rest of the report after the sixth column. The color of the boxes set to white and only the four column fields I needed colored were colored and the rest was white-out. Thanks for...

Hi Naith I do want all fields displayed but only the last four columns must be highlighted as noted above based on the formula. Thanks.

Hi Naith, I cannot find in the Box format editor conditional formatting. Is there a way of finding this out so that I can place my formula to color last four columns . The formula is : IF({TableName.Fieldname} <> NEXT({TableName.Fieldname }) ) THEN crwhite else crsilver ONCE AGAIN THANKS...

Hi Naith, Yes I am using the box in cr8.5 Sorry for being a pain but I inserted the box control from crystal 8.5 into the detail section but not formula(x+2)appeared. Is there another way to insert a box in crystal 8.5.

As long as the tablename.fielname not equal to next tablename.fieldname then White else gray. Is there a way for the box to show white or gray based on this condition in the datail section.