Search results for query: *

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

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

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

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

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

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.

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

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

I'm scheduling through InfoView. BOE 3.1.

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

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

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

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

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

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

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

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

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

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.

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