Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Tigger9969

    ODBC.Net Question

    I'm fairly new to VB.Net and am developing a database app. Here's my problem. I have lots of books that tell me how to do things like update datasets with dataadapters,etc. But none of them show how to do it with the odbc data provider. So far I have a windows form, with my data showing in...
  2. Tigger9969

    Printing 2 records per page

    I do have a group header for the member, but I only want to show 2 records, not foce a new page. So something like this: {Member Group Header] Joe Blow 1234 Here Street ... .. Payments: [Detail Section] 02/02/02 $30.00 02/10/02 $60.00 Then Have the same...
  3. Tigger9969

    Printing 2 records per page

    I have a report that groups member information and displays transactions made in the detail. This is a statement that is mailed out to the member showing their account info. Each record needs to be starting in exactly the same position on the page so that they can take all their print outs and...
  4. Tigger9969

    Creating a crosstab in sql server 2000

    Can anyone help with create a query for sql 2000. Here's a sample of what I'm trying to output. employee Jan Feb Mar Apr May Jun Jul Aug Sep Nov Dec emp1 sum of amount for each month " " then use crystal reports to sum each much, and calculate a acumulative sum...
  5. Tigger9969

    Using Subreports with stored procedures

    Here's what I have: I have a main report that uses a stored procedure. Here's what I want to do... I need to create a subreport that summarizes the data from the main report. If I add an unlinked subreport, can I pass the stored procedure parameter values from VB to the subreport? Or is...
  6. Tigger9969

    Datetime field -- VB and Crystal reports OCX and SQL Server 2000

    Thanks for your help but I found a way around it differently. In my Stored procedure, I used the cast function and casted the datetime field to a varchar, this way when I pass the values in I can send them as strings instead. Thanks again. Tigger9969
  7. Tigger9969

    Datetime field -- VB and Crystal reports OCX and SQL Server 2000

    I know there is a lot of dicussion about datetime fields, but I couldn't find something that would help. Here's the question: I have a stored procedure in sql server 2000. In crystal reports, when I view the data and it prompts me for the parameter, I have to enter the exact date and time...

Part and Inventory Search

Back
Top