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 Mike Lewis 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: Cris
  • Order by date
  1. Cris

    Repeat frame - more than one page

    I'm designing a report using Oracle Reports 6. I have a repeat frame where I have to put some information that spans 2 pages so I have designed de first page and have tested it (it works fine) but when I have resized the repeat frame and put data in the second page I have got an error when I...
  2. Cris

    On demand subreports

    Can I create a on-demand subreport (as a link) that when clicked it presents it's data in the main report, not on a new page? Or can I print the entire report without having to click on the subreport link? I'm using CR 8 Thanks
  3. Cris

    Print button in Netscape with Java smart Viewer

    Hello! I'm using the Java smart Viewer to display my reports in a Web page with an applet. When I load the page with Internet Explorer I see the print button but when I do it with Netscape Navegator it doesn't appear. Anyone knows why? Thanks ;-) * I'm using Seagate Crystal Reports 8 and...
  4. Cris

    Getting only maximum values

    For each PUESTOG in each GRUPO_ENT, I want to get the values of all the fields of the row with the maximum value of "ANOTACION". Something like: SELECT NHOPG.* FROM "NORMA50I"."NHOPG" NHOPG WHERE NHOPG = (SELECT MAX (NHOPG2.ANOTACION) FROM...
  5. Cris

    Getting only maximum values

    No. The complete problem is: I get a date value from a parameter (ej: ?date1), and for each GRUPO_ENT, PUESTOG, I want to get the row (or rows) that contains the maximum value of "ANOTACION" date AND ?date1 is between FEDESVIG and FEHASVIG (two date fields). Because I have to get the...
  6. Cris

    Getting only maximum values

    Hello I'm using CR 8 and Oracle 8. The joins between my tables require getting only maximum values for a date field. I've tryed a simple query like: SELECT NHOPG."GRUPO_ENT", NHOPG."PUESTOG" FROM "NORMA50I"."NHOPG" NHOPG WHERE...
  7. Cris

    What is an SQL statement field?

    Thank you, I thought It allowed inserting additional SQL statements. I'd tryed it but it didn't work
  8. Cris

    What is an SQL statement field?

    What is an SQL statement field in CR 8? How can I use it? Thanks ;-))
  9. Cris

    Access only from main page

    I'll try it. Thank you ;-)
  10. Cris

    Access only from main page

    How I can control that the access to my Web is only possible from the main page? Thanks
  11. Cris

    Passing values from an web page to Crystal Reports

    I don't use the URL to pass the parameters, instead I use an ASP page to pass them to the crystal report. In that ASP I'm using something like this: Set Session("oApp") = Server.CreateObject("CrystalRuntime.Application") Set session("oRpt") =...
  12. Cris

    Passing values from an web page to Crystal Reports

    Within the records selection formula: e.g. &quot;...WHERE FD1>=CDate('10/02/2000') AND FD1<=CDate('10/05/2000')&quot;
  13. Cris

    Passing values from an web page to Crystal Reports

    I'm passing From Date and To Date field to Crystal Report. I want the From and To date values to printed in Page Header of the Report. ¿Is it possible? Thanks ;-) I'm using: Version of Crystal Reports: 8 ODBC Connect Programming: HTML, VBScript, ASP and the Web Component Server
  14. Cris

    Using opener property

    How can I know if my window was opened from another window or not? I've tried: if window.opener<>null then... if not IsNull(window.opener) then... but they don't work. Any idea? Thanks
  15. Cris

    Getting a different description for 2 fields

    I have a table named FINCAS that contains 2 fields named: CODPOS and CODPOSP that store the zip-code of a house and the zip-code of the owner of the house. This values are often distinct. In my report, I show the information of FINCAS and I have to put the name of the country associated to...

Part and Inventory Search

Back
Top