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 TouchToneTommy 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: mrdjsm1th
  • Content: Threads
  • Order by date
  1. mrdjsm1th

    Formula Logic to Format String Data into Fixed Columns

    We have a business requirement to print a list of ticket numbers into a fixed column format and include an asterisk at the beginning of each row. The following @PopulateList formula is currently used within the detail section of the report: // {@TicketNo} is the trimmed Ticket //...
  2. mrdjsm1th

    Limitations of Subquery or View

    I am using Pervasive 8.70.014 and trying to work with a denormalized table in a third party database. The difficult table has 12 columns to store bill of material mix components and I am attempting to normalize the columns into a view or derived table for a reporting solution. I am having...
  3. mrdjsm1th

    Report Viewer for Saved Data and On-Demand Subreports

    We are using Crystal Reports XI with Microsoft SQL Server 2005 using SQL Server Authentication. We have reviewed some of the Crystal Report viewers on http://www.kenhamady.com/bookmarks.html and would like to select one that allows users to drill-down on data that is saved in a report in...
  4. mrdjsm1th

    Crystal Report Viewer with On-Demand Subreport

    I have reviewed some of the Crystal Report viewers on http://www.kenhamady.com/bookmarks.html and would like to select one that allows users to drill-down on data that is saved in a report and launch on-demand subreports within the same report. The on-demand subreports contain sensitive...
  5. mrdjsm1th

    Pervasive 8.70.014 ODBC with SSRS 2005

    I am trying to convert a SQL command from a Crystal XI report to a SQL Server 2005 Reporting Services (SSRS) dataset. I am using the Pervasive ODBC client interface with the Crystal XI report and the SSRS dataset. The Crystal XI SQL command successfully uses several parameters, but I can't get...

Part and Inventory Search

Back
Top