Recent content by Cris

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...

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

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...

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...

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...

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...

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

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

I'll try it. Thank you ;-)

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

I'll try it. Thanks ;-)

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") =...

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

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

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