Search results

  1. W

    On load event not firing

    Created a web page using asp. I have included a onload event on the body statement. It works fine As soon as I add a include statement in the body of the html that event does not fire up any more Don't understand Here is the code If anybody can help I would really appreciate...
  2. W

    How does Crystal do its record selection

    I have to tables vendor ap I have linked them up in database link on a key field vendor-num and said the vendor table is an outer join In the report in the Select Expert: I have another requirement to state that AP record the field balance <> 0 Now Does crystal first do the outer join...
  3. W

    Parameter fields Displaying

    I have a parameter field that allows multiple selections for it. I can put the parameter on the report and see the first value. How can I display all the values selects for that parameter? Thanks for any help
  4. W

    Grouping out of Order

    I have two tables. A history table and an Address table. I join history table to address table using left outer join. The field I am grouping on though is in the address table. When generating report, grouping is all mixed up. I can go to design mode, go to group section change the...
  5. W

    Crystal report viewer 2008 Problem Paramater changes

    I have created a report using Crystal Reports XI I am viewing it thru crystal report viewer 2008 It has some parameters for selection of data In viewer I cannot change those parameters to select different data It states contact report creator Can you not change parameter selections in...
  6. W

    How to stop printing records in a subreport

    I have a sub report I only want to print say 10 lines in the sub report and not all the data it retrieved I created a running total field and count each record Then on the detail line, I created a formula to test the running total field If it is less than 10 I print the record information...
  7. W

    Group By option

    I have a report that is grouoped by a date field In the group options there I see I can change to display data by: for each day for each week Can I change that option dynamically say using a parameter value or a formula? say: Ask the user to group dates by day by week? I know I can do two...
  8. W

    setting cursor in textbox field on initial load of form

    I want the cursor to appear on the first text box in my screen when user goes to the site I have coded this but no cursor is placed in textbox <form id="Form1" defaultfocus="TextboxTelephone" method="post" runat="server"> I have to tab to get cursor in first textbox telephone Any ideas?
  9. W

    formview object and empty daata source

    I a formview object I have created an edit temple and an empty template When there is data in the table nor problem When my table is empty i got the empty template to display when I click insert I get the error " Form must be in insert mode" How can I tell if there is no data on the page...
  10. W

    Gridview object and editing data

    I have loaded up a gridview object with data I have turned on Edit on the grid It lets me edit the data, but I also want to put some code to check for correct data in each field I tried to assign a requiredfieldvalitor, comparevaliditor but they don't work Is there an event I can capture...
  11. W

    How to check a return code after executing sql statemnt from aspx page

    I execute an insert sql statement into an Oracle Database How can I check that the statement executed okay my code is db = createobject(ÀDODB.Connection`) db.open(`Provider=MSDAORA........) strSQL = ìnsert into fuel.....`) db.Execute(strSQL) what do I check after thisÉ
  12. W

    Reports

    In asp.net is there a way to create reports? I am using a oracle datase and crystal reports at the moment to generate some Just wondering if asp.net generates reports also
  13. W

    Validating a textbox for numeric data

    I have a text box where user enters data I want them to enter only numeric values and a decimal place I was thinking of using the regularexpressionvalidtor control In there I set the field to validate and was looking at the ValidationExpression option What would I put there? Any help is...
  14. W

    Two dropdown list boxes accessing values

    I have two dropdown list boxes I select the first one and I get the index value of what i selected say item number 2 Using that indexvalue I would like to acccess the second dropdown box and get the value of it Both boxes will have the same amount of items in it Is there not a way to do...
  15. W

    Enter key press and button OnClick event firing

    Have a form with a button and some text fields on it When I hit enter after filling a field the event for the button fires up event onClick How can I get around this since on one of the fields I have a textchangeEvent I to fire up Why would this occurs?
  16. W

    combining Xcell sheets into one HOW

    I found this code to copy all sheets ina spreadsheet into one It works until a certain limit and then stops I don't know much about vba excel so any help would be appreciate I have 4 sheets and trying to combine them all into one sheet Sub Combine() Dim J As Integer On Error Resume...
  17. W

    Created a function Cannot get it to work

    I have created a function to check for three dates passed in Which ever one is not null return that date I call the function from a form for an unbound field I set the control source of the unbound field to call this function Anyone of the dates can be null Can't I not pass down a null...
  18. W

    Subreport in Report Fotter

    I have placed a sub-report in the Footer of the main report This subreport is a report all on its own. I would like to have it run after the main report finishes so i put it there Is there another way to call this subreport after main report finishes? Also I get the Page header of the main...
  19. W

    Eliminating repeated data in detail lines

    Is there a way to print out first detail line with all the info for that line Subsuent lines have the same data as first detail line except for some fiels that might be different I woul;d like not to [print the fields that are the same Is there a way to do that in Crystal
  20. W

    Cystal Syntax question

    Have this syntax WhilePrintingRecords; numberVar Discountable; if (Datbase.Field1 = 1 ) then Discountable := Discountable + (Datbase.Field2 * Datbase.Field3) else Discountable := Discountable Question: Is := the same as an = syntax in Basic syntax...
Top Bottom