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 wOOdy-Soft 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: mmarino
  • Content: Threads
  • Order by date
  1. mmarino

    xmlns:xsi namespace in an element

    Hello, I'm new to XSLT transformation, and I can't find an answer to this. My XLST file contains the following: <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" encoding="utf-8"...
  2. mmarino

    vsFlexGrid printing

    I'm using ComponentOne's vsflexgrid (version 7.0) to show data from a SQL database. I need to print the grid but I have to add a header to the page. I looked up the function they have vsflexgrid.PrintGrid, and all I can do is add a footer. I don't want to use a reporting program like Crystal...
  3. mmarino

    Wizard Manager

    I'm trying to make it very easy for my users to get the initial setup of my program. I want to have a wizard that takes some info and enters it to the database (MS-SQL 2K). I was looking at the Wizard Manager and it seems like it handles the display, so all I have to add is the functionality. I...
  4. mmarino

    How to add reference so dll resides in system32

    This might be very simple, but I can't find an answer. I have a vb6 group project (.vbg) that contains 2 dlls and one executable. It all works fine until I want to install on a different machine. If I put all 3 files (dlls and exe) in the same directory (the App dir), it runs correctly. However...
  5. mmarino

    formula with number range

    Hi everyone, I'm using Crystal XI and connecting to a MS-SQL database. I'm trying to get a report that selects one or multiple locations (and groups on them). Basically in SQL it would be something like "select * from table where Location in (1,2,3)". I added a number parameter LocId and set...
  6. mmarino

    licensing question

    Hi there, I hope I'm in the right forum, if not please redicrect me. I can't find a straight answer to this question, so hopefully someone here has run into the same situation. We have Crystal Reports XI Developer. We are creating a website for a client, and will be hosting the site for them...
  7. mmarino

    open existing excel spreadsheet in browser

    I have an excel spreadsheet that lives on the server, I'm trying to get it to open on my browser window. This is my code (openxl.cgi): $excel="\/usr\/common\/reportdir\/excelsample.xls"; print "content-type: application/vnd.ms-excel\n"; print "content-disposition: inline\n\n"; print...
  8. mmarino

    subreport when detail section is blank

    Hi there, I have a report with a few subreports, they're all linked by customer id (the main report is on only one customer id). Ocasionally, the details section of my main report will be empty, but I still want the subreports to show (it has different information about the customer). What...
  9. mmarino

    How to pass a parameter from subreport to stored proc

    Hi guys, I have a main report that uses a parameter. This parameter is passed to a subreport that needs to use a stored procedure. Up to here it works fine, except it takes too long, so I need to limit the data by passing the same parameter that links the subreport to the main report to the...
  10. mmarino

    &lt;!--#include in cgi

    I'm pretty new to apache, so this might be a very simple question. I have a cgi script that reads a template shtml file and replaces some tags to produce a new page. My template has 3 includes (2 headers and a footer) and it also uses style sheets for fonts and colors. I can't get the include or...
  11. mmarino

    .NET webservices and Unix

    Is there support for .NET webservices in the Unix environment? I basically need to exchange data between a Windows system and a SCO Unix server. Is that possible? I will develop in a Windows system, so I don't need the developer environment or tools on Unix. Can anyone point me to some...
  12. mmarino

    columns pushing subreport off page

    I've search this forum for this, but I can't find an answer to this particular question. I would like my report to look like this: code1 desc1 coden descn code2 desc2 code3 desc3 subtitle code4 desc4 codeA descA code5 desc5 codeB descB . ...
  13. mmarino

    Suppress field if blank

    Hi everyone, this is my problem: I have an address that comes from 2 separate fields, I use the following formula to display them: [COLOR=red] if isnull({tbFlashComment.BusinessAddress1}) then stringvar addr1:="" else stringvar addr1:={tbFlashComment.BusinessAddress1}; if...
  14. mmarino

    Suppress group header if detail section is blank

    Hi there, I'm using CR 11. I have titles (labels) in my header, and summaries in the footer. If there is no data returned for the detail section I would like to suppress both the header and the footer, and instead print something like "no data on file". Is that possible? Thanks, mm
  15. mmarino

    Subreport for last 4 quarters

    Hi there, I'm trying to create a subreport and I'm not getting the right data. I have a table with the following fields: date, numberA, $amount I need to show the sum of numberA and the sum of $amount per quarter for the last 4 quarters, so I would end up with four lines. I tried creating a...
  16. mmarino

    rounding in formula field

    Hi everyone, I have a problem trying to put integers in a formula field. Basically I want to say "(# Lines") where # is my number. My formula looks like this: [COLOR=red]if tonumber({tbTradeLineHistory.NumberOfLines}) = 1 then "(1 Line)" else "(" & round({tbTradeLineHistory.NumberOfLines}) & "...
  17. mmarino

    reports from VB using MySQL database

    I can pull and save data from my VB program without a problem. When I try to use Crystal Reports I can display a report if it has no parameters, and if the &quot;Save Data with Report&quot; option is checked. I need to be able to pass parameters, when I try this, it complains and gives me an...
  18. mmarino

    calling CR with a query from VB

    I'm using CR8 and VB6, and I'm using the ocx method. I have an rpt file that I need to call from my VB application, the report gets its data from a SQL designer query. My problem is that when I try to run the report I get an error 20553 &quot;Invalid parameter field name&quot;. I know my...
  19. mmarino

    VB and CR how to connect from a system DSN

    I'm writing an VB app that needs to display reports. The reports are already in .rpt files, so I just need to call them (I'm using the OCX method). I have gotten it to work by hardcoding the database information, like this: With frmReportSelect.rptReport .Connect =...

Part and Inventory Search

Back
Top