Search results for query: *

Hello I am working on Seagete Crystal Reports 8.0 and trying to exec a report via VB 6.0 (yes, some of us are still working on that..) I am getting this error message: "Error in File D:\xxx.RPT: Error in formula <Record_Selection>. ' ' The remaining text does not appear to be part of the...

Hello all I have tried to exec a report with this record selection formula - it doesn’t accept "exists". Any solution will by helpful. F_STRUCTURE.LIFE_STEP_ID} = 1 and {F_STRUCTURE.STRUCTURE_STATUS} = 1 AND exsists (select 1 from F_BUILDING where {F_STRUCTURE.INT_STRUCTURE_KEY} =...

hello all i am using this code to get the pagebreake location so i can put a border line at the end of each page (until row 100): For j = 1 To ActiveSheet.HPageBreaks.Count If ActiveSheet.HPageBreaks(j).Location.Row < 100 Then i = ActiveSheet.HPageBreaks(j).Location.Row...

pls help i am working on cr ver 8.0. i have a report that i show on a web site. every thing is going well untill i try to export to exl. i was able to export until a point when i started to reciev this message: "CRAXDRT Error Occured on Server. -2147190908 : Failed to export the report." on...

Hello All i have a cr9 report opend in an ASP page. i want to import it to excel 7.0 (extand)format (or excel 5.0 extand) witch is avalable in the design but not on the browzer. any ideas? thank you

hello we have a pivot table which is very long. when we merge cells printing causes an error and excel is closed. we r working on excel 2000. any sugestions? thankx

hello all i am tring to insert a recordset numeric data from vb to a sheet in ecxell 2000 . for some resone i am gettin a comma (') in evry numeric cell therfore i cant make any calculations or other manipulations on my data in the excell workbook. any help? thank you michal

hello all how can i print all details even if some of them are not seen. they are not hide - i have 2 parameters in a higher level . thank you michal

hello all i am trying to run an auto_open procdure from a vb6 code how can i do it? thank you

Does somebody know how can I set the report zoom when I come from ASP page? It sometimes show &quot;100%&quot; in the ZoomControl, but still looks very small and I have to change it manualy to bring it to a normal size.

hello all i can not show a report based on ODBC from an asp page any sugestions

hello i am using cr 8.5 calling to the report form an asp page. i am using the field &quot;page n of m&quot; but when the report is up on hte screen i get for example :page 1 of 4,444,444. when i jump to the last record this is fixed but how can i make it be ok in the first place?

hello i am using cr ver 8.5 how can i pass selection formula to subreport thank u all michal

Hello i am working on cr ver 8.5 i am building a table where the table header is in the page header. sometimes the grand total of the report (outside of the table)is on a new page so i am getting the table header with no table content and the grand total. how can i make a new page with a blank...

hello all i am working on asp and sending parameters to crystal report v 8.5 for some reason the crysatl wouldt show the parameters unless i send a &quot;fake&quot; parameter witch is an empty string thank u for help michal

I'm trying to call to the crystal report from asp page. I know that I have to send a different code for every type of parameter (12- for string, 7- for number, and ect..) I wolud like to know how can I send a range parameter? (like range of ages - between 10 and 20) Does it have a special code?

hello i am working on CR ver 8.5 and ASP pages. how do i send a range parameter (number type) from ASP to the report? (no allow multiple values, no discrete values, yes range values) thank you

Hello all i am working on orecle v 9.2 client. (server v 9.2) i have tried un succefuly to open the cursor with execute immediate while having a dinamic sql. this is my procedure: CREATE OR REPLACE PROCEDURE P_415 ( r_415_Cursor IN OUT pa_rpt_415.rpt_415_Type, param1 IN...

hello all i am having dificulties tryin to use this stored procedure for building a report: create or replace procedure rpt_415( pDateFrom in date, pDateto in date, TotalReq in out number, TotalRecvd in out number) when i am trying to select it i am getting the next error:memory full. if i am...

Hello all I am having dificulties of putting this sql formula into a crystal report. when i am trying to use a running total field i cant use another running total. thank you for a quick advice select count(subcount)from ( select count(str_person_id) subcount from ( select c.str_person_id from...