Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cristianivanoff

    Calculating amount from transactions...

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

    Easy left join problem

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

    Easy left join problem

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

    Easy left join problem

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

    join with date ranges?

    GREAT! You are my hero!!!! Br Cristian
  6. cristianivanoff

    join with date ranges?

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

    List of reports from Crystal Enterprise

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

    List of reports from Crystal Enterprise

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

    Reports can not be opened from BO Enterprise

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

    Reports can not be opened from BO Enterprise

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

    Reports can not be opened from BO Enterprise

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

    Reports can not be opened from BO Enterprise

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

    Reports can not be opened from BO Enterprise

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

    Crystal Reports Server Errors

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

    XML as data source

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

    Formula and cross tab shuts down CR?

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

    Cross tab formula?

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

    Cross tab formula?

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

    Cross tab formula?

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

Part and Inventory Search

Back
Top