Search results for query: *

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...

Hi, I do hope someone can help on this. The db is SQL Server. I am Working on Existing report. This existing report has xml source, now I need to add two tables from MS SQL Server db and I have linked both these newly added tables but not to xml tables. So these two are connected but they are...

I have created new group to an existing report and added a new 3 tables to my report. Trying to copy one field from newly added table to a new group record. Following error occurred: Cannot determine the queries necessary to get data for this report. Can anyone help me? -nb

Hi, I have existing report I need to modify it. Wanted to add a new field and that field needs to display using following sql: select a.com_balance from [fmdprod1213].[dbo].[commit_hdrs] a, [fmdprod1213].[dbo].[commit_items] b where a.com_id = b.com_id and a.com_xref_num =...

Hi all As you all know I am new to CR development. Need help! I have main report and sub report. I wanted to use sub report field in main report. My sub report displays commint_amt and I wanted to use this field in the formula of the main report. Is it possible? Can anyone help me? Thanks -nb

Pete, thanks for your quick response. I have created dynamic Cascading parameters. It is working fine. However something little different than what I am expected. As I said I have 5 parameters P1_code, P2_code, P3_code, P4_code,P5_code All five are "allow range values" expected each parameter...