Search results for query: *

Hi, I need help to create below summary report. The report is group by Department and need to count FileID for each column values by department. For example: Service Department ErrorCategory TypeOfError ErrorDesc User = 11 Random = 9...

Hi, Thanks for your response. I just put the 5 fields but actually there are 12 fields. So it will be very difficult. Instead of that even this works for me. How would i get this? Group: (where value = 1) Err1 ABC DEF Err2 XYZ DEF Err3 DEF Err4 ABC XYZ...

Hi, How would i do conditional grouping from the multiple fields? For example, Id Name Err1 Err2 Err3 Err4 Err5 1 ABC 1 0 0 1 0 2 XYZ 0 1 0 1 1 3 DEF 1 1 1 1...

No, there is no field i can link these 2 tables. Even though some members are different in these tables i tried to link them but not getting any records. So it's not working if i joined these tables. Is there any way i can get this without joining these 2 tables? Thanks

Hi, Most of the members are common in both the tables but some members are in the SQL table but not in the Orcle table and the other way also (Some member are in the Oracle table but not in the SQL table) Thanks for the response.

Hi, I am creating a report from 2 database sources. 1 table from SQL and 1 table from Oracle. But there is no way I can join these 2 tables. I need below information from these tables and report should look like this. Member Name TotalServices FROM SQL Table ABC 10 FROM...

Sorry, I have to create this report based on Stored Proc only. It's a rule. We have SQL Server 2008

How would i get all those 10 fields into 1 column? Is there any other way to get this? Other than Cross tab report? Thanks for response. -gh

Hi, Can anyone help me to get this? Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Field1 sum of sum of sum of sum of and so on….. Field1 Field1 Field1 Field1 For Jan For Feb For Mar For Apr Field2 sum of Sum of sum of sum of and so...

Thank you LB so much for your help!! You save my life today.

Hi, I am using CR Xi. I created a parameter to give the client flexibility to select range of company number they want to include in the report. In the parameter, i did Allow Range Values = True and Allow Multiple Values = True. Now when i ran the report i passed below values to the...