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

    Help with variables (newbie)

    I have a javascript variable defined as: var name; In my HTML, I am calling a javascript function that sets the name variable. Once I return from the function call, the value of name isn't set. What am I doing wrong? How can I access the value of the name variable from the html after the...
  2. jaburke

    Help with parsing a line

    I tried it and I get a "bad substitution" error.
  3. jaburke

    Help with parsing a line

    Hi, I am having to rewrite a script from dtksh to ksh. I had something in the dtksh that looks like this: if [[ $countit = 3 ]] then var1=${line:0:10} var2=${line:11:29} var3=${line:42:1} fi This syntax for the line parsing doesn't translate to ksh...
  4. jaburke

    String to number (with decimal)

    No, I'm building a webi report off a universe and that's where I've created my object. I finally got this to work with a small tweak to my formula above. I changed it to this: DECODE( TRANSLATE(@Select(Class\Field),'_.0123456789',' '), NULL, 'number','char') I added a decimal after the...
  5. jaburke

    String to number (with decimal)

    Hi, In a universe object, I am trying to convert a string to a number if it's all numeric. This is working fine - almost all of the time - using this formula: DECODE( TRANSLATE(@Select(Class\Field),'_0123456789',' '), NULL, 'number','char') So I am converting to 'number' or 'char'. If it...
  6. jaburke

    Suppress duplicated values

    Hi, Is there a way, in webi, to suppress values when they are duplicated on multiple rows? For example, if I have a report that shows store and I have three rows that say "ABC Store", can I somehow suppress the value on rows 2 and 3? Thanks.
  7. jaburke

    Parameter value not setting on schedule

    I have tried 1 and 2, but I will give 3 a shot. Thanks!!
  8. jaburke

    Parameter value not setting on schedule

    This is the only parameterized report I'm having a problem with. I have hundreds that are working correctly.
  9. jaburke

    Parameter value not setting on schedule

    I'm scheduling through InfoView. BOE 3.1.
  10. jaburke

    Parameter value not setting on schedule

    I have a crystal report that runs fine when it's run on demand, i.e. viewed. When it is scheduled - something is going wrong. I click the parameters and enter them. I click 'OK' and the parameter value still says "". I have tried deleting the parameter, re-adding it, etc. Nothing is fixing...
  11. jaburke

    Webi throwing error but view is valid

    Hi, I created a view to utilize in a universe. When I do a select * from the view in sqlplus, it returns fine. No errors. When I add this view to a universe and then query off it, I am getting the ORA-01722 Invalid number error. Why is BOE throwing an error when the view is fine in sqlplus...
  12. jaburke

    Windows 7 and Webi

    Hi, We have a user who has Windows 7 who can't edit existing webi docs or create new ones. The webi tab gets closed and then Windows recovers the tab - back to InfoView. I had him change his webi preferences to use "interactive" for creation/editing, so it must be java related. I had him...
  13. jaburke

    query results in another webi?

    Is there a way you can take the results of a webi query and use those results in another tab in a webi report? Any feedback would be appreciated!!
  14. jaburke

    Join columns in my select

    I didn't enforce the joins, but I just went and tried it, and it is giving me the same results. It is driving me crazy. My datasource is an Oracle 10g database. Nothing out of the ordinary. Okay I just realized that I have a statement in the select expert that says where item_num < 900...
  15. jaburke

    Join columns in my select

    I created the links through the database expert, not the selection formula.
  16. jaburke

    Join columns in my select

    Yes..it only behaves correctly when I remove those columns from the select statement (via sql).
  17. jaburke

    Join columns in my select

    I don't want them in the select because I am getting 70 records - the same one duplicated 70 times because one of the join columns contains 70 different values. I really only want one record without showing that column. Example: Query from CR shows the same record with 70 different item_nums...
  18. jaburke

    Join columns in my select

    The join info is in the where....for example My query: select p.part_number, o.order_type from parts_tb p , orders_tb o where o.item_num = p.item_num Query generated by CR: select o.item_num, p.item_num, p.part_number, o.order_type from parts_tb p , orders_tb o where o.item_num = p.item_num...
  19. jaburke

    Join columns in my select

    The joins are in the where condition. When I write the query using SQL, I don't have to specify the join columns in the select.
  20. jaburke

    Join columns in my select

    Hi, I'm creating a Crystal report and the join columns are showing up in my select. I don't want them there. I am not pulling them into my details, or anywhere else on the report. How can I get them out of my select without using a command for the SQL? I don't remember old versions of CR...

Part and Inventory Search

Back
Top