Search results for query: *

Hi, my environment: BO XI 3.1 database: DB2 I have aliased a table (fairly large) and wanted to create objects that check condition in this alias table and another table before bringing data from this alias table, but I get below error when I try to parse: Parse failed: Exception: DBD...

i can certainly bring the selection criteria into the command object SQL, but the issue is that I m using database tables for this report besides the command object and the command object is not Linked to the tables. If I move the selection criteria to the command object which is not Linked to...

Hi Dell, thanks for your reply. Perhaps, I should have mentioned earlier that I have some conditions in record selection for this report and I m using the report parameters in there as well. So, once I delete the report parameters and create them in my command object, can I still use them in my...

Hi All, SCENARIO: I have a report that contains a command object besides some database tables. I do not have the command object linked to any tables. I have 3 parameters in the report that I require the user to enter. ISSUE: Is there a way that I can pass these 3 parameters to the command...

Hi All, Scenario: using crystal report 2008 I have a sub report that pushes its contents to the next page if records are more than 3. I have placed that sub report in the main report's Group Header 1c. I have a part of the report that I want to be able to display on the first page of the...

i m sorry that was a typo. I m actually adding the 1 to the counter so that it increments. Let's suppose i have the following data: column A Column B A NY B London C Paris D London E London F Berlin G...

someone please suggest something. I m out of ideas at the moment...[sad]

Hi Madawc, Thanks for your reply. I m afraid the summary count on the group wont work because the condition (based on which the records in the Detail section need to be printed on the new page) needs to be calculated on the records in the Detail Section Level. The condition is that the...

Hi Gurus, Scenario: I have a requirement where I need to print all records on a new page if field values meet condition and if such records are more than 4. I have a grouping on the report so i m assuming i would need to use the "New Page After" option on the Group Header immediately above...

Hi All, I have a requirement where I need to print all records from the detail section on page 2 if number of records are more than 3. So, no records (from the detail section) will print on first page if the records are more than 3. Please help. Thank you.

Hi Gurus, After lots of unsuccessful searching on the net, I m posting my question hoping to get an answer. SCENARIO: I have a subreport containing crosstab table that spans on multiple pages horizontally. The crosstab is in the Report Header section in the Subreport. The crosstab is in the...

Hi Gurus, I m trying to develop forms in crystal reports using text boxes. Once I align the text boxes, I deploy the report to Business Objects Enterprise to see how it looks there and surprisingly, some boxes are not aligned anymore. Please help. Thank you

I sincerely apologize for not seeing this. You are right. Thanks for pointing it out. Best Regards.

Hi lbass, thanks for taking the time to reply to my post. I tried what you suggested, but the Record Selection Formula still does not take into account the time portion of the End Date parameter. I m testing this functionality on Northwind access database and i modified my record selection as...

Hi Gurus, Environment: Crystal Reports 2008 Business Objects XI 3.1 I have 2 date parameters (?StartDate and ?EndDate) that take user input for Beginning and End dates. I want to change the date that the user inputs so that the date part remains the same but gets time stamp of 11:59:59 PM. I m...