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

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

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

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

I am going crazy. I am helping a co-worker with a crystal report and here's what we're trying to do. Return data where noun_mod_2 <> 'ATTACHMENT 4'. The field noun_mod_2 also contains nulls, so we know we need to evaluate for those because they won't evaluate in the not equal. If I do this...

I have some reports using dynamic parameters. They were working fine and then I went into the Business View manager and updated the password in the data connections. Now when I run the reports, the values for the dynamic parameters are not being populated. Any help would be appreciated...

Hi, I have BOE 3.1. I have found a problem with my security after being in production for a while. I do not want any of the users to be able to modify a webi doc and save the changes back to the public folders. They can save to their favorites all day long, but they should get an error when...

Hi, My report has a parameter with these values and using a like statement in the SQL: 123* = Blue 124* = Green 125* = Yellow 1235* = Pink The problem is that if the user selects 123* for Blue, he is also going to get Pink records back. I can't really think of how to handle this, so I was...

Hello. I have a webi doc and I need to create some date calculations. I'm not sure if I should do this in the webi or in the universe. Here's how the data looks: Customer1 MRP Planning 8/1/2009 Customer1 ME Planning 10/5/2009 Customer1 Capacity Planning...

Hi all. I am writing a ksh script that runs a bunch of SQL. I have a sql command that does something like this: v_seqno=$(sqlplus -S databaseinfo <<EOF select seq_no from table; EOF ) I can echo $v_seqno and I see the result (i.e. 1916). Later on, I want to use that value in another query...

I know this is simple, but I am rusty with my ksh scripting. I have a script that is doing an ftp to a mainframe and deleting a file. I have a grep statement in the script to look at the logfile. If there's an error in the log, I want the script to exit with an error. I can't make this work...

Hi, I want to create a crystal report that kicks off a sql script on my unix server. Can this be done??? Thanks...

Hi there... I am creating a new universe. I have a situation. There are two tables that I am trying to join, but the join is conditional. If status = 'I' then I need to join one way. If status <> 'I' then I need to take a different join path. Any help would be greatly appreciated. Thanks!

Hey, I have a CRXI report that is calling a standalone CR as an on-demand subreport. The subreport executes fine (as a standalone) in BOXI Enterprise. The main report runs in CRXI and when I click the link for the subreport it works fine. When I try and run it from BOXI Enterprise, the...

All of a sudden I can't run any webi docs or create any new webi docs in my BOXI R1 environment. When I click on a report or a new universe, it spins for a while and then it says "could not initialize report engine server". I have restarted all the servers and rebooted the windows server and...