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...

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.

Can anyone please help?????

Hi All, I have a report in crystal 8.5 that I want only certain columns in the detail section to be shaded. I can shade all columns. For example, there are six columns on the report and I only want to shade the last four columns but not the first two columns. Any IDEAS Thanks...

My crystal reports are created on one drive in the network.I use OLE DB connection without using UNC to connect to the database because the databases are located on the same drive. Crystal reports on the web are not opening, sometimes by users in other countries. 1.Do I need to use Database...

Hi All, I open a web report in my environment and it works fine. When users open it they get an error message stating that the report cannot open for security reasons. The users enter a password and and login id.Does someone know the cause of this problem. It happens when they enter a...

Hi All, Mr.Big helped me out shortly. However, I have to insert data from five tables already imported into Access97 database into one table. I have written 5 seperate modules to do the load.It worked but took a longer time to load than I expected because I have 565650 records...

I have 700000 records in a text file and want to load it in a database table.Can someone please help me go about writing a code to load these records without waiting for 3hours to load in Access table.I am using rs.AddNew to add records to Access database. Any other solutions

I want to print NO DATA on a report if zero record is returned.Can someone please help? I tried using running total formula if 0 then suppress GF1a and placed NO DATA in GF1b to print when record count is zero.Any other suggestions.