Recent content by PBS2

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

Yes sorry I am using Crystal V.8 for this particular report. I have tried accessing my data by setting up an SQL expression but I get the error:- "No rowset was returned" I recently managed to setup an SQL expression on a different Report in Crystal V.10. Can anyone tell me what I am doing...

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 now fixed the problem with Maxlength - I was populating the textbox with the value from a table including trailing spaces. Consequently the trailing spaces were included in the Maxlength calculation. So when I tried to amend a 3 character Username to make it longer it would not let me...

Sorry vbkris I am new to asp.net so am not sure how to check the HTML output in the browser. How do I check this for you?

This is the HTML for the text box:- <TD style="WIDTH: 161px"><asp:textbox id="txtSMSUsername" runat="server" CssClass="StdTextBox" MaxLength="11"></asp:textbox></TD> Does this give you any clues?

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

Yes - I have looked at Subreport linking but do not fully understand what I need to do. Could anyone give me a beginers course in how to use this feature to solve my problem.