Search results for query: *

Hi All, Could you please any one tell me the differces between Drill down report and Sub Repot in Crystal reports. According to my understanding. Drill Down: We can convert a report based on grouping as a drill down report by hiding the details( If you have sub groups with in a group hide...

Hello All, I am planning to take the BOCP-BOE Certification exams. I know that, i need to pass three exams to get the certifctaion ( SABE201, SABE301, SABE401). Can anyone please tell me what are the best books to read to pass these exams , how much effort is needed and are the courses...

Hello All, I need to create a crystal report with 30 fields. How can i increase page size to fit all these fields. In file>Page set up option, I changed the orientation to landscape. But even the landscape is not enough to accomdate all these fields. How can i increase my page size...

Hi, I have a dynamic Prompt DYP in my report which is pointing to a stored procedure STP, Stored procedure has input parameters SDate and EDate. So, when refreshing the report, It is asking for the dates twice, first time to get the values for dynamic prompt DYP and second time for the...

Hi, I have a report, which i need to group it by based on user selection. Ex: @groupprompt has four values: A, B, C, D. Multiple values are allowed. When the user selects A, i need to group the data by A. similarly for B, C and D. If the User selects A, B then i need to group the...

Hi I have a field 'A' of varchar(20) from the stored procedure. and i am creating a dynamic prompt PromptA on this field A. In the report selection formula i wrote A={?promptA} While Refreshing the data, i am getting the following error List of Values Failure: fail to get...

Hello All, I have a report built on tables. Can i make a union of the sql generated by this report and another query(new query). Thank you

Hi All, I have a report which is grouped by a field A. In this report i have a field B ( count of C calculated from Stored Proc). I need another field in the report which should be % of B for each record. Which Means % of B ( with the total B) So, I write a formula (B/sum(B,A))*100 to get...

I Have a field in Database table A. I need to check for NULL Values in the Record Selection? How Can i do that. I mean what is the substitue in Crystal for A IS NOT NULL in SQL Thanks for ur help Keertana

Hi All, I Have a crystal report A, which was scheduled in Business Objects. I Made changes to the report by adding a new parameter and over written the existing Report A on Business Objects Server. The Report instances ( Scheduled daily) are failed because the new parameter is...

Hello Guys Is there a way we can supress report title while printing. I have a requirement, where they need a report title while they view, but not when they print the record. Is this some thing we can do in crystal reports or some thing to do with printer options. Thank you

Hi All, I have 5 groups in my report and i need to insert record count for each group and as well for the whole report. If i am inserting RecordNumber special field, it is picking up the record count as the count irrespective of the group. Ex: if i have 4 groups A, B, C, D with counts...

Hi All, I need to create a report, which should run weekly. Suppose when the report runs on each Sunday, i have to get the information from Last Monday to Sunday. I can actually put prompts for start date and end date and it will get the info for that period. But instead ,How can i...

HI ALL, I have a staic prompt, which selects A,B,C,D. and Now i want an additional static prompt, if the selection of earlier prompt is A. Is this possible using Crystal Reports XI Thank you

HI ALL, I have a staic prompt, which selects A,B,C,D. and Now i want an additional static prompt, if the selection of earlier prompt is A. Is this possible using Crystal Reports XI Thank you