Search results for query: *

I am using Crystal V6.0 to report on a FoxPro dbf table. In the table I have a numeric value stored to 2 decimal places. In the report I have a Grand Total Sum of this value at the bottom of the report. If I repeatedly refresh the data in Crystal I keep getting different values for the Grand...

I have a Version 10 Crystal Report which has 2 levels. The Report when opened shows summary values in the Group Footer. On drilling down the detail level is displayed. I have noticed that on drill down I lose my Page Header/Footer. In addition, although on Page 1 of the drill down I have the...

I have 2 existing Version 10 Crystal Reports that show show employee earnings information by Year and Period in different formats. Report A is a summary report while Report B is more detailed. Both reports use record selection formulae to limit the report results to the Year and Period selected...

I have to amend an existing report which works from 4 linked tables. I now need to include data from a fifth table which contains only 1 row. This fifth table contains no links to any of the other tables. I can add this table to report and create formulas, however, when I run the report the...

I am trying to write a stored procedure in SQL2000 which will be called from an ASP.NET webpage. The procedure needs to create a table but as the name of the table varies I need to pass it as a parameter. The code I am trying to use is as follows:- CREATE PROCEDURE XX_SamTest @UserCode...

In my Crystal V.10 report I need to access 6 consecutive rows in a table. There is a field in the table called firstrow which when set to 1 identifies the first row I need to access. I need pick up the value of a field called mydata from each of the 6 rows to use in formulas on the report. I...

I have a singleline textbox in which I want to restrict the entry to 11 characters. I have tried setting the MaxLength prperty of the textbox to 11. However, when I do this I cannot enter more than 3 characters into the textbox?? Can anyone tell me why this might be please.

Hi, I am new to ASP.net - could someone please give me some simple VB code to POST xml to a given URL. I am building my XML as a string variable and have tried using Webrequest but cannot get this to work.

I have a requirement to sort my report by Date and Time. My data has separate fields for date and time. I have figured out that if I Group Sort on the Maximum of the Date field the report displays in Date order. However, how I can sort on Time within Date ?

I have a table which needs to look like this:- Branch# Sales Rank 1 325 3 2 450 2 3 301 4 4 206 5 5 598 1 My stored procedure updates the Branch# and Sales figure correctly. What SQL code can I write to update the Rank column...

I have a main report which has 3 separate Subreports. The main report has 2 formulas @FromDate and @ToDate which are passed into the report as parameters. I then want to use the values of @FromDate and @Todate as start and end dates for the record selection in each of the 3 subreports. I have...

I have a report which is structured as follows:- Details a SUBREPORT1 Details b SUBREPORT2 Details c SUBREPORT3 Group Footer#1 Branch @Total1 @Total2 @Total3 branch Where the formula @Total1 on Subreport1 is:- whileprintingrecords; shared...

I have two formulas on my report @FromDate and @ToDate. These two dates are the from/to date range for the report. The report always displays a weeks worth of data from the @FromDate (always a Sunday) to the @ToDate (always a Saturday). If the @ToDate is a known date how can I calculate the...

I have main report that needs to looks like this:- Total A Total B Totals A + B 55.00 45.00 100.00 60.00 10.00 70.00 20.00 90.00 110.00 where Total A is a formula on the MAIN report and Total B is a summary field from a SUBREPORT. I have...

We have a client who uses pcAnywhere 10.5 to download data using Remote icons setup with AutoTransfer files. This approach works fine when he connects to systems running Windows 9x. However, some of the pcAnywhere Hosts run Windows XP Home - on this systems pcAnywhere connects but the...

Can you please help with a VB.NET syntax question? Say you had 50 controls on your form called txt1 to txt50 which you wanted to disable. In Visual Foxpro you can use something called macro substitution in your code to help with this as follows:- FOR i = 1 TO 50 STORE LTRIM(STR(i,4)) TO n...

I have a main report in which I use a number of formulas. I created a subreport which also uses some of the same formulas as the main report. I then created a second subreport but when I click on the Report Explorer none of the formulas I used in the main report or the 1st Subreport are...

Hi, I need to create a report as follows:- BRANCH Ave.Sales Rank Per Customer Brighton 50.67 2 Worthing 30.96 4 Hove 67.45 1 Horsham 44.67 3 I do NOT want to change the sequence of the branches in the report. The rank...

We have a client who uses pcAnywhere V10.5 to transfer data from Hairdressing salons to a central Head Office. The Hairdressing Salons all wait as a pcAnywhere host - the Head Office runs as a Remote and has a tick in "Run the AutoTransfer upon connection". When the Head Office connects to the...

A customer of ours has installed pcAnywhere V10.5 on his laptop. After installing pcAnywhere the laptop reports the following error:- BC CODE 10000050 BCPI:E160B000 BCP2 00000001 BCP3:BF9BC3CC BCP4 00000001 OSVER:5_1_2600 SP1:1.0 PRODUCT 768-1 If the laptop is rebooted it reboots OK but the...