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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: Saners
  • Content: Threads
  • Order by date
  1. Saners

    Combine SELECT UNION with Cursor

    I am developing SQL reports in Visual Studio 2005 and have written a report that processes the following records. 1. A case has 1 case record. 2. A case record has 1 or more related service records. 3. A case record has 1 or more related activity records. 4. A case record has 1 or more related...
  2. Saners

    CRM 4.0 passing attribute value to an iframe via a url on a form

    I’m using CRM 4.0 and I want to pass an attribute value as a parameter to a url in an IFrame. It works fine with the parameter value hardcoded into the url e.g. the url on the iframe is set to -http://test/ISV/NewPersonDetails.aspx?PersonNo=999999 However I want to pass the attribute value...
  3. Saners

    Continuous subreports calculating percentages

    My main report prints one record per page. In the detail section there are 2 continuous subreports. Subreport 1 shows how many items for sizes 1, 2 and 3 were available. Subreport 2 shows how many items for sizes 1, 2 and 3 were ordered. In subreport 2 the 3 sizes % ordered should be 100%. It...
  4. Saners

    Truncated incorrect DOUBLE value error using On Instr

    Hi. I have the following 2 input tables: 1. tblTempValue has 2 fields: Value (TEXT) and AssetID (BIGINT(20)) and holds the following values: Value AssetID 1,3,10 90 4 91 8 92 2 93 5 95 2. My lookup tblTextDOB has 2 fields: RaceNumber (VARCHAR(20)) and...
  5. Saners

    Formulas and sub-reports

    I have a problem calculating a formula using shared number variables and sub-reports. I have checked out FAQs and thread767-857392 but it still is not working properly. I am running CR10 using a Stored Procedure in SQL 2005. 1. I define 3 shared variables in the detail section of my main...
  6. Saners

    Continuous paper in a matrix printer

    Maybe someone can help! This problem has been mentioned before in thread703-516681 but unfortunately no one replied. I have the same problem. To recap I am printing to a dot matrix printer using continuous paper in Access 2000. The paper is 0.5cm longer than the usual A4 sheet so after...
  7. Saners

    Empty Crystal Report opened with SQL recordsource in VB 6

    I have created a report in Crystal Report 9 with a single date parameter. I call this report in some VB 6 code (below). The problem I have is that an empty report is printed each time I run the code with a valid date. (Running the stored procedure independently with a valid date always returns...
  8. Saners

    VB Code date parameters from SQL Stored Proc. to Crystal Reports 9

    I'm using Crystal Reports 9, SQL 7 and VB6. I want to write some VB code to prompt the user to enter 2 date parameters. I have written a stored procedure to select the records using these date parameters. I have designed a Crystal Report with this stored procedure set as the datasource. Can...

Part and Inventory Search

Back
Top