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

    VBA and Broadcast Agent

    If you have prompts in your document and when you schedule the document to BCA you will be asked for the Prompt Values during the Schedule process... Sri
  2. Sridharan

    Shutting off BO Message Prompt.

    One option to shun the messages shown by BO is to use SDK... Set Application.Interactive = False The above statement when executed will stop the User Interaction with BO... You could call that statement at appropriate place... So any message boxes, prompts etc will not be shown... Now after...
  3. Sridharan

    Field is generating multiple records

    Laina, You need to define the Measure Object for the column retrieving the Fruit values and not on Customer... When you do so you will still get that many number of rows but when presented in the report you will get one row for each Customer... Again as I told earlier I dunno which version are...
  4. Sridharan

    Field is generating multiple records

    A Star for Blom... Sri
  5. Sridharan

    Field is generating multiple records

    That was a cool one blom... There was one more approach given by another user on BOB where you basically use the Sectioning trick to get the stuff in a single row... Really don't have the thread link in hand... Will post once I get hold of it... In essence we need to set the column containing...
  6. Sridharan

    How to return min and max only records for multiple rows

    Well may be I was not clear blom... When I said Min and Max its bit misleading... What he needs to do is take the Minimum of Period for each (Part, MonthEnd) and take the Start Value in One DP... In the second one he needs to take the Max Period for each (Part, MonthEnd) and take the...
  7. Sridharan

    Field is generating multiple records

    I dunno which version are you on... Anyway check this thread and see if it works for you... http://www.forumtopics.com/busobj/viewtopic.php?t=29236 Sri
  8. Sridharan

    Prompt modification...

    To your first question if its possible without creating a object at Universe Level Yes its possible... I've done something similar in the past... Lemme dig that up... Sri
  9. Sridharan

    How to return min and max only records for multiple rows

    Going with your already done stuff... You can have two DP's one fetching MIN value and other MAX value and then you can show these in the report along with Part and MonthEnd... Now if you don't like two DP approach drop a note I will provide an alternative solution... Sri
  10. Sridharan

    Prompt modification...

    Also remember if some user drags a new object or removes already existing object your modified SQL doesn't hold good and BO will generate the SQL automatically... Sri
  11. Sridharan

    User response prompt date not date data type in formula

    No No No... YOu don't need access to Universe... You can accomplish at the report level itself... Need to have a look at the report... Sri
  12. Sridharan

    Header not repeating across the page

    I mean Are we talking in the same wavelength and not different stuffs??? Sri
  13. Sridharan

    Header not repeating across the page

    Steve, Oh Ok... Now I got the point... Thanks... Kannan, You got that to working or you are looking out similar to what Steve mentioned like repeating the Section Value to repeat on Across the page with the crosstab... Say you have a section on Dim1 and you have a Cross Tab which spans across...
  14. Sridharan

    Menu Bar Missing

    Glad to be of assistance [thumbsup2].. Sri
  15. Sridharan

    User response prompt date not date data type in formula

    Time part can be there... But you need to accomodate that when you do a conversion... UserResponse will be a Detail but not a Dimension and you can actually take the Date Input and store in a Detail Variable... As said looking at the report might give some clues.. Sri
  16. Sridharan

    Union

    Blom is right Ver 7.x has Union Transformation... Now in your case what you need to do is Override the SQL of the Source Qualifier with a Union statement to get the functionality you are looking out for... Sri
  17. Sridharan

    Lookup from Flat File?

    Which version are you on???? Ver 7.x has what you are looking out for???? Sri
  18. Sridharan

    Header not repeating across the page

    Looks like I didn't understand the exact stuff you are looking at... When you say Header Across Page what exactly are you looking out for??? I get the Header Repeated both Down and Across... Can you put your request in alternate way so that I can check what you are looking at??? Sri
  19. Sridharan

    Header not repeating across the page

    Did you check Repeat Header Across Page in the Page Break Across Section Right Click - > Format Crosstab - > Page Layout Tab and see if both Down and Across Repeat Header is checked... Also you need to switch to Page Layout to see the Header Repeating... Sri
  20. Sridharan

    Menu Bar Missing

    Couple of ways to do this... Either change the registry settings... Which I wudn't suggest... Instead use SDK to get back the menubar... Open a report or create a simple report maybe with eFashion... Then press Alt + F11 or open the VBA Editor... Press Ctrl + G and it should open the Immediate...

Part and Inventory Search

Back
Top