Search results for query: *

Hi, I use CR 8.5 on a DB2 database. It is not possible to write the sql our selves due to a webconnection on a citrix-server. The problem is that I have to use arrays which exceeds 1000. I try to find the data from the subreport by saying when arrPNR[Counter]={PNR} - But it seems that the...

Hi django, Gary Parker & lbass, Many thks for your help in solving the challenge !! It works beutifully, -fb

Hi LB, yes that's right I would like to place the subreport in the reportHeader Because that will speed up the reportdata collection how shall the loop variabel be in that case???? when using the variabels as created by Gary I find every time the correct pnr but the two date variabels is...

Hi Gary, thks for your help!! I get an error message when I create the variabel @pnrMatch 'An assignment is expected here and cursor flashes where I have written (here) /Loop through the pnr array to see if it exists For i (here)= 1 to Count(arrPNR) Do( If arrPNR[i] = {Table.pnr} Then...

Hi, I can naturally join on pnr but for speed of the report it would be better to add the subreport in the reportHeader of the Mainreport. I need the help with the syntax for finding the pnr and the equal startdate and enddate which belong to the indivual pnr. -fb

Hi lb, The report has 10225 pnr and it is only around 79 pnrs which have any data comming from the subreport therefore I would like to place the subreport in the reportheader and use, if possible, shared array variables. This way it will only take 1-2 minute to get the data for the whole...

Hi I'm creating af report where some of the pnr's have info in another table which I cannot directly link to - . Therefore I have created a subreport where I find all the info for all the pnr's. I want to place the subreport in the mainreport reportHeader so the subreport only send the sql to...

Hi -k, Unfortunately I can't provide sample data But if you can provide me with your e-mail address I can send you Print screen of the Report with data shown and explaination of the problem. FinnB

Hi, I have a report which has 10 groups. Report prints Salary Notes for each Employee. However when 2 Formulas is zero then Suppress the whole Salary Note for that Employee. The Formulas in question: Formula1: WhilePrintingRecords; numberVar sumydny; //Shows the total Salary Formula2...

Hi -k, Many thanks for your reply - I say many thanks for your suggestion. Is their any chance to do this without a subreport?? FinnB

In a Report I have to create a formula to handle this situation: An Individual has changed his PensionNo to 925 therefore All earlier records PensionNo has to changed to 925. I.e.: This is how the records are shown in the Database: PensionNo EmploymentNo StartDate Enddate 004 1448...

Hi Everyone, Do you have to reschedule a report in Crystal Enterprise after altering the report?? If not how do you avoid it?? We are using CE with a Citrix Server. Thanks in advance FB

I have found the reason! If you have used the Query file against DB2 and then alter the query towards a Oracle DB then this can happen. You have to create a new Qery file. FinnB

I have made a Report with 3 linked Subreports using Crystal SQL Query designer ! From Within Crystal Report Designer I'm asked twice when I open the Mainreport for the ODBC-driver and Userid and Password after I have entered the values for the Parameters I'm again asked twice for the Password...

Hi Ido, Many thks for quick response. I am using a subreport for page 2 - the challenge is to control the size of the subreport detail section to only stay 11 cm in hight from the bottom of page two. How do I control this?? What do you mean when you are writing: "The page location issue can...

The Tricky One - How to place Crew schedule in Detail Section formatted with multiple Columns – Twice! I am Developing a report where a Crew Schedule shall be shown in Detail Section at page one Formated with Multiple Columns ( 2 Columns). Then again the same Schedule but less fields for the...

Hi, I suggest this sql: SELECT DISTINCT A.ID, B.ID FROM Table1 AS A LEFT JOIN Table2 AS B ON (A.ID=B.IDX ) where B.Number=9 ---- Best regards, FinnB