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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.