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

Thank you all for all your replies! The suggestion by mstrmage1768 worked fine! Thanks! Br cristian

Hello! Thank you for your answer. Unfortunately its sql server 2000. Br cristian

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

GREAT! You are my hero!!!! Br Cristian

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

I don't want to use the HTML-tool for this.

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

Is it possible to set the -requestport? Where can I do that?

I see on the firewall log that different (random?) ports are used by BO?

Well there's a firewall but everything is open and all ports needed too (port 6400 and another port). The first problem was that port 6400 wasn't open (error message said that port 6400 had be open). Then I opened it and it still didn't work (no error message though). Looking at the log files...

The input server is up and going, also enabled. //cristian

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, I have the same problem. The input server is running. Don't know where to look. Any suggestions? Any or all suggestions are appreciated. Br Cristian

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

Yes I would need separate running totals for each month. How can do this? /cristian

ok, there's only one problem left. With a running total I just add a new amount of subs ID's to the group. So if if the amount of month_1 is 10 then the amount of month_2 is (10+x). Suppose that 2 of the first 10 does not meet the criteria in month_2 then it should be 8+x instead of 10+x. The...

yes I can.

I have the same formula several times in the same cross tab with different Numbervar. Twelve formulas, one for each month in columns. I don't have any column field and in the row field I have a formula for grouping my products. What the formula above is supposed to do is to find a 'Subs ID' that...