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

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

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

Hi I am new to CR, need urgent help. any quick response would be appreciated. I am creating a report with 5 parameters P1_code, P2_code, P3_code,P4_code,P5_code All five are "allow range values" p1_code is fine there is no dependence. But when I select drop down box for P2_code, I wanted a...

Hi, I have 5 parameters (all are allow range). Right now report is running fine, but I pass all 5 parameter values.( All parameters are mandatory) How can I make them make them optional? See the code below: {coa_elem_desc.element_id} = {?P_Element_1} or {coa_elem_desc_1.element_id} =...

Hi, I have a 5 parameters (all are allow range). right now report is running fine only if I enter valid values for all parameters. all are mandatory. how can I make them make them optional? see the code below: {coa_elem_desc.element_id} = {?P_Element_1} or {coa_elem_desc_1.element_id} =...

Hi, I have created an on demand sub-report with option “select data in sub report based on field”, This report takes the voucher_id field from the main report (details section) and runs. I made a room by dragging down details section frame to place a sub-report. I ran it and I see a...

Hi I am kind of new to CR. I want to use one of the fields (vouchr_item.element_1) from my report and get the description field from another table (elem_desc.element_desc). These tables not connected with 1 to M relation. I want use a function and return the element_desc. Can anyone help me...

Hi, I am quite new to CR. Trying to understand how to schedule reports? I wanted to schedule about 30 reports some are daily refresh and some are weekly reports. ~NB

I am learning to create templates in CR 2011. First question raised. While creating a @<TemplateField> fields in report details section, how many of these fields we need to insert. For example if i create only 3 @<TemplateField> in template and then how does it will work for a report which...