Search results for query: *

I am using Crystal Reports 8 on MS sql server 2000. I need to compare the total of accounts such as 2xxxx7801 with the amount of account 27801. The 2 in the example stands for the fund, and there are several different funds. I can't seem to construct the report so that the 5 digit account is...

I'm a newbie to powerpoint. I created next and previous buttons on each slide, but they are different sizes and at different locations. Is there a way I can make all the buttons the same size? Also, is there a way I can make all Previous buttons at the same location on each slide? Thanks...

I'm using Sql Server 2000 on the client, and Sql Server 7 on the server. I copied sql generated by Crystal reports into a stored procedure and modified it to include 2 new tables--budget_lists, and budget_list_accounts. When I run it in query analyzer, it parses ok, but when I try to execute...

I am just getting started in asp.net. I am running Windows XP and Visual Studio.Net 2003. When I tried to build an ASP.Net Web Application, I got the following message: Could not copy built outputs to the Web. Unable to add folder '../labfiles' to Web project. Server error: '../labfiles'...

I have a Crystal 8.0 report that is running off a stored procedure(SqlServer 7.0). The stored proc is returning the period amount for the current fiscal year, but not for the previous fiscal year. I just get 0's for previous fiscal year amount when I add the condition that fiscal...

I have a Crystal 8.0 report that is running off a stored procedure(SqlServer 7.0). The stored proc is returning the period amount for the current fiscal year, but not for the previous fiscal year. I subtract 1 from the current fiscal year to get it to return last_fiscal_year, and it does do...

I am using Crystal 8.0 and Sql Server 7. I have a report that is not incorporating the selection criteria into the sql sentence. This report works in a slightly different form, with fewer tables. But when I add a couple tables to limit the people who can view the information, it does not...

We are running Sql Server 7 on Windows 2000. I need to create a stored procedure that the users can run, but I need to be able to modify it if a problem occurs. The dba is the only one who has sa permissions. Is there a way to create the stored procedure so that I can modify it if necessary...

In Excel 2000, I have a vba macro that selects the worksheet, unhides columns that were previously hidden and saves the spreadsheet under a new name. This is the code: Cells.Select Selection.EntireColumn.Hidden = False ThisWorkbook.SaveAs "C:\Invoices\excel_upload.xls" The...

I have several Crystal reports that need to be put on the web. In testing, when 14 people tried to access the reports, the locks forced a number of people to hang. It was suggested that the report be changed to call a stored procedure, and that the 'read uncommitted' command be issued to...

I am using Crystal Reports 8.0 on Ms Sql Server 7.0. Many users will be viewing a Crystal report on the web, so I need to SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in order to prevent locking. I know I can do this if I run it as a stored procedure. I would need to convert several...

I'm a newbie to Access, and I can't get my report to fit on to one page. I've tried shortening the fields that are created by the wizard, so that it looks as though they will all fit. But I still get a blank page, or a page with just a part of the top and bottom border lines. I've tried...

I am using ms sql server 7.0 and Crystal Reports 8.0. The Purchasing Department currently uses a different system, and prints their PO's in triplicate on a dot matrix printer. I've created a Crystal PO, and we would like them to switch to a laser printer. However if the PO doesnt' print in...

I'm using Crystal Reports 8.0 and MS Sql Server 7.0. I want to add a table to an existing report so that I can include the ledger account in the report. I want to link bank_register.document_number (datatype is int) with gl_cost_transactions.document_id1(datatype is char(25). I was able to...

I am using Crystal Reports 8.0 against Sybase 11.0.3 database. I'm trying to modify a general ledger activity report which ran fine previously. It had 2 input parameters--fiscal year and period. I'm trying to add a 3rd parameter so that only those accounts in the approver's department can...

I'm using Crystal Reports 8.0 with Sybase 11.0.3. I've had a crystal report in place for more than a year. Trying to add two tables to the report has been a nightmare. I finally got it to almost work by playing around with the sql, and copying and pasting it in. For example, the report...

I am trying to add two new tables to a report. When I link one of the tables to an old table, the new table does not show up. It is not in the sql, and if I request an input parameter equal to one of its fields, I get an error message saying that the column_prefix does not match with a table...

I am retrieving data through microsoft query from a sybase database. There is one column that could have a "V" or a "C". I would like to retrieve the record regardless of whether it has a C or V in the column, but I want to display the contents of that column only if it is...

I'm creating a file in reportsmith that I need to import to Crystal. I can save it in a text file format, or an Excel file format. Does anyone know if there is anyway I can import a reportsmith file into Crystal? If not, what would be the best way to import an Excel or text file. I've seen...

In excel 2000, I need to remove the decimal point from the amount field, but retain the decimal places, and 0 fill the field to a length of 10. The amount needs to be the absolute value For example, the amount -234.56 needs to become 0000023456. I've tried formatting the column with...