Recent content by bandarna

Hi, I have been working on modifying several reports. All existing reports are created using .xml sources. Now I am adding SQL Server DB tables and joining with one of the XML source. exp_vchr_id (string) from xml file joins with exp_vouchr_iteam.exp_vchr_id from DB table. As of now I have...

I have a 12 Summary fields in my Group footer Jan_Total to Dec_Total amounts. Then I have created formula as f_Tot_Orig_Amt. and added 12 summary fields to get Year total. But in some groups all 12 totals are 0 so my Year_Total also zereo. But the requirement is that If all are zero there is no...

I have report Detail section has been Hided, showing only Summaries on group footer section. Jan_Amt Feb_Amt March_Amt Apr_Amt…..until December 100 200 600 400 I wanted to sum all Summary fields from Jan_Amt to Dec_Amt and display at the end of the row (in the same sectin) Jan_Amt...

I created a parameter in my report where I want the users to enter partial text and get the result. For example, the field is 6 character long. User can enter first 4 character and run the report This is the data in the field – 100000 100200...

Hi, while serching how to create optional parameters in Crystal report, I found this thred is very much lelpfull tome. looks like it is working for someone. I wrote this code in Select Expert (CR XI Ver.). but I am getting error as " The ) is missing" (IF not(hasvalue({?P_Element_2}) = true)...

I did not resoved this issue can any one help me? nb

I have a main report and subreport. It is linked with exp_vchr_id. It is working fine. Executing each row level for each exp_vhr_id and populating data. However I need to modify sub report to pass a parameters in to it like p_elemet1,p_element2 this is creating a problem for me. After I merged...

I am working on existing report, this report was developed sourcing several xml files. Now I wanted to import some SQL Server tables and need to link to the xml files. Does this works? When I create a link I have a Visual Linking message as: Your current link configuration contains multiple...

I found some info in the google. http://scn.sap.com/thread/1503212 now I am thinking why my first onw is working. it has only tow distinct values. now I noticed that my pick lists are limited to 10 items only. above gave me how to do but it is for CR 2008. I am not finding same regedit path...

Thanks Madawc. sorry for cross-posting.

I have created report with 5 dynamic parameters. All are range values. User will select from and to values from pick list. Database field names are element_1, element_2 element_3, element_4, element_5. What I am expecting from these five parameters are distinct values from each elemnt...

I need to pass values from unlinked subreport to the main report. I have created a shared variable in my subreport using my summary field. See the code below: whileprintingrecords; shared currencyvar v_jul_comm_amt := sum ({@Jul_Comm_Amt}) and then I have used below formula Colum code in main...

I have created a shared variable in my subreport using my summary field. See the code below: whileprintingrecords; shared currencyvar v_jul_comm_amt := sum ({@Jul_Comm_Amt}) and then I have used below formula Colum code in main report. whileprintingrecords; shared currencyvar v_jul_comm_amt...

Just wanted to update the status after the previous post: I have created a shared variable using my summary field. See the code below: whileprintingrecords; shared currencyvar v_jul_comm_amt := ({@Jul_Comm_Amt}) and then I have used below formula Colum code in main report...

Thanks for your response, I have created a sub report. This sub report is unlinked subreport. This sub report need to display only one row total of the recorded, therefore I have suppressed all other sections except report footer group and added to the main report to display as only single row...