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!

Register Log in
  • Congratulations Chriss Miller 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. SergeS

    Problem grouping conditioned column?

    Hi all, I am encountering the situation in which Impromptu doesn't allow me to make one of my report columns a list header. Also, when I try to group this column Impromptu gives me the red circle with white cross and shuts down. In my reporting I use several groupings and associations along...
  2. SergeS

    Joins and subqueries

    Hi all, I would like to know something about main queries and subqueries. I've got 3 tables: A, B and C. The 3 tables have got the same PK, each composed of three attributes. Table B contains all possible combinations and is the leading table. The cardinalities are as follows: A -> B = 1:1...
  3. SergeS

    Converting number to date

    Thanks blom, however I found the following solution: I created an object in my universe stating: convert(datetime, '12/31/' + @Prompt('Enter reference year','A',,MONO,FREE)) (I am using Sybase Adaptive Server) when I need to compare dates I can use the @Select(object) in my condition...
  4. SergeS

    Problem with off line modus

    The user doesn't exist in more than 1 place. I scanned and repaired all domain: there were no corruptions and it didn't solve the problem. It's weird, I can't find an logic behind this issue. Cheers, Serge
  5. SergeS

    Converting number to date

    Hi all, I am prompting a user to enter a year, f.e. 2002 (specified as number I guess). After that I want to select data from the database using something like: is valid on 31/12/entered year in this example 31/12/2002. How can I transform the entered year to the date 31/12/entered year...
  6. SergeS

    Problem with off line modus

    Hi Steve, Your solutions works: I already tried it. However, I don't think it is a structural solution. It would mean that whenever something changes for an existing user the user's .lsi file has to be deleted. Doesn't it? Serge Schokkenbroek Ordina Finance Business Solutions http://www.ordina.nl
  7. SergeS

    Problem with off line modus

    Hi, I am encountering a problem with functionality offered in off line mode. My situation is the following. In supervisor I have created a user with limited functionality in Designer, f.e. it is not allowed to make new connections. In online modus and in off line modus everything works...
  8. SergeS

    Using a stored procedure in universe

    Hi all, I've defined a stored procedure in my database (Sybase Adaptive Server 12). Now, in my universe I want to use that stored procedure. Can someone explain the syntax to me? I am trying: procedurename(argument1, argument2) but I am getting the error that procedurename is not a built-in...
  9. SergeS

    How to print Report properties?

    Blom, Thanks for your reply. I've tried the addin, however, it doesn't do what I need. It only lists the code/definition of the columns in the report. It doesn't tell me anything about the definition of the report structure etc. Too bad. Thanks, Serge
  10. SergeS

    How to print Report properties?

    Hi all, I've got a question which seems rather trivial, however I am not able to do it. How can I print the definition of the Report, like one can do for the universe? I want to use it in my documentation set of my reports. I want to see on paper that my report uses to dataproviders, I want...
  11. SergeS

    Adjusting size of legend box

    Hi everyone, I've inserted a pie chart in my report along with a legend. The max number of items in the legend is f.e. 8. I've based the size of the legend box on the maximum number of items. However, sometime the pie chart has only to different items, so in the legend box only two items are...
  12. SergeS

    Sorting a generic dimension object resulting from 2 dataproviders

    Thanks promero, Life can be so simple :) Serge
  13. SergeS

    Sorting a generic dimension object resulting from 2 dataproviders

    Hello all, I've got a problem with sorting the values of a generic dimension object. The situation is as follows. In BusinessObjects I have produced a report using two dataproviders (two seperate queries running on one and the same universe). From the result set I have constructed 1 report. I...
  14. SergeS

    How to handle an 'exlusive or' situation???

    Promero, thanks for all your support. I think I will opt for the solution with contexts because putting the Aggregate_Aware in a condition object results in some other conflicts in my situation. Thanks, Serge
  15. SergeS

    blank in a prompt...

    ssibo, what do you mean with "matches pattern"? Where can I choose for this? Serge
  16. SergeS

    How to handle an 'exlusive or' situation???

    Promero, I am encountering an error following your advise: Like I said, I have an dimension object Entity. The select clause is @Aggregate_Aware(Entity2.description, Entity.description). I showed you the where-clause and you showed me how the rebuild the where-clause. Now I am getting an error...
  17. SergeS

    How to handle an 'exlusive or' situation???

    Promero, thanks for your explanation. If you don't mind I have two questions about your tip: 1) In my universe I have the dimension object Entity. The select-clause is: Entity.description. I've changed it to @Aggregate_Aware(Entity2.description, Entity.description) The where-clause is...
  18. SergeS

    How to handle an 'exlusive or' situation???

    My mind is tired... Let's say I have 4 database tables: Entity, BusinessGroup Division and Department. Conceptually, there are two possible hierarchies: Entity BusinessGroup Division Department and Entity Division Department so there are divisions which relate directly to an Entity and...
  19. SergeS

    Forcing a specific Context to be used?

    Hi all, I am wondering if it is possible to force a specific Context to be used in a query. I've two Contexts. My reports is generated by using to queries (union). In query 1 either Context should be used and in the second query the ohter Context (not used in query 1) should be used. Is it...
  20. SergeS

    Include used filters in final report !!

    Hello SaraMaia, If you mean with 'filter' an applied condition I don't think it's possible to show the name of the condition. However, if you refer to a filter which you applied using the report structure window you can do the following to insert the value of the filter: Choose from the menu...

Part and Inventory Search

Back
Top