Search results for query: *

Hi All, Dont know if this is in the correct category but I'm trying to calculate amounts in sql. This what I have: One table with transactions. That's it basically. Every transaction represents an "deposit" or "withdrawal" of a product from a shelf. There's no data of the amount of products in...

Hello all! I have a table like this: PersonID, PersonName, ManagerID 1, Joe, 45 2, Chris, 45 ..... ..... 45, Marc, 99 ... ... 99, Jessica, - I would like a query that shows me: PersonID, PersonName, ManagerID, ManagerName, Manager2_ID, Manager2_Name I need to join the same table several...

Hello all! I have a problem joining two tables with date ranges. Maybe anybody here can give a suggestion how to solve this problem. I have two tables,Tab1 and Tab2, and I would like to join them and get the resulting table Result. Any suggestion is appreciated! Br cristian Tab1...

Hello, I would like to create a list of all reports and their parameters that are stored on the server. Is this possible? I don't know what the default database or tables for report definitions is/are. Any one out there have some suggestion? Br Cristian Ivanoff

Hello, I cannot open or save reports from CR XI to/from BOE XI. When I open a report directly from CR I can log in to the system and I can see all reports on the server. But, I cannot open the reports. I get the following error message: "The report could not be opened from BusinessObjects...

Hello all, I'm trying to use a XML file as data source and I have two problems: 1) I don't get any data at all even though I have done everything (I think) as it should be done. I made a new 'Data source (ODBC)' and used CR ODBC XML Driver 4.10. The location is a folder and the table creation...

Hello all, I have a cross tab with string fields in both rows and columns. Rows are {global_comp_pivot.Bandwidth}(string looks like: 8 Mbit/s) and the summarized field I have this formula: if right({global_comp_pivot.Bandwidth},6)="Kbit/s" then...

I have this formula in a cross tab with the Distinct count as summary type: numbervar nummer:=12; if {Melody_subs_status_log.affective_from}<=date(dateadd("m",-nummer,{?SlutDatum})) and not ({Melody_subs.subs_status_id} in [3,7]) and (isnull({Melody_subs_status_log.affective_to}) or...

Hello all, I have a mainreport that links with a subreport with a number (Prodgroup). This number is then used in a formula like this in the subreport: if {?Pm-@Reportprodgroup}= 221 then {TMS_SE_PRGRP.pg-code} in "500" to "599" else if {?Pm-@Reportprodgroup}=222 then {TMS_SE_PRGRP.pg-code} in...

Hello, I have a report that I want to be executed once a week (from CR enterprise). I want this report to execute once per customer with status X. That is, if there are 20 customers with status X this week then I want 20 reports (or copies of the same report) to be executed. Each report has...

Hello, I have a report that i want to be executed once a week (from CR enterprise). I want this report to execute once per customer with status X. That is, if there are 20 customers with status X then I want 20 reports (or copies of the same report) to be executed. Each report has information...

Hello all. I would like to make an array with date ranges in the elements. 12 elements and the date ranges are calculated from a date given by the user (the user gives the last date). The date ranges are whole months. If the date given by user is 2006-11-12. The last element (12th element) of...

Hello All! I have a table with these fields: {Period},{Paym},{Prodcode} My cross tab: Period1|Period2|Period3 etc Prodcode1 Prodcode2 .. .. In the summarized fields I have the sum of {Paym}. In period3 I want to show the result of [period3+period(3-1)+period(3-2)]/3. The same...

Hello all, I would like to extract all numbers from a string. I have a field {TM_SE_sbreg.Reference} that can have these strings: 's-12344','r-se-123456','r-se-123455-3' I need only the numbers that is: 12344, 123456, 1234553 I made the following formula: if {TM_SE_sbreg.Reference}...

Hello all! I have two questions (excuse my English): 1. I have a cross-tab with three formulas in each column. I want a fourth formula to divide the result (the total) of two previous formulas. Formula1|Formula2|Formula3|Formula4 100, 200, 300, 200/300 I thought i just could divide formula2...