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...
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...
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...
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.
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 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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.