Search results for query: *

I thought this would be obvious but in Web 801, is there a way to tell MSTR to open up a new window to execute the report when you click on a report link? Right now when you click on the report it executes and returns data on the same page. I know there is an option to export reports into excel...

Hello All, I have been part of this group for almost an year now. I have found it very useful, invaluable and informative. I have recommended this forum to so many co-workers. A couple of quick suggestions: 1) When someone helps you out please do give them STAR. Not only is this a great...

I have a 25 MB excel sheet that has an access macro on it and does it's own set of calculations behind and I want to use it as an Imported excel sheet in Narrowcast and store it in a location where users can access it. When I run the service it comes back with a box that says FAILED TO LOAD...

I am trying to find the report in Enterprise Manager that gives me the reports that have not been used recently. Can anyone tell me the name of the report or whether I should create it and if so how to go about it? Any help I would greatly appreciate I am on MSTR 8.0.0 Thanks!!

I was trying to create a 'blank attribute' to put on my report. This column would have no data what so ever on it so that when users export it to excel they will have blank a blank column where they can write their own comments. I dont want to create a blank column in my database and don't...

Anyone have any idea about the various enhancements in MSTR 8.0 I heard it allows us to hardcode SQL. That is exciting!!! Also another thing is that it keeps track of the number of licenses bought by the organization and at a given time will not allow any more to login. Does anyone else know...

I do a coalesce(date,' ') as date Here if date is NULL it is replaced with a blank string But my report shows up as 1/1/1900 if the date is NULL in the database. I tried lots of things but could not avoid it. I want it to display a blank string if there is a NULL. Database: SQL Server 2000...

I came across this situation. At first it sounded simple but I have no answers for it. Lets take Deal attribute for example. It has a DealID and DealDesc. Now when I put it on the report and display both the ID and Desc, they both come up with one common heading called 'Deal' which is the...

Hi, I need to develop a report with a parent attribute (region eg NE, South etc) as a page-by on a template containing its children (states eg NY, TX etc) and some metrics. Now, I am able to run reports with the parent attributes and then drill to get the children. But, if I use the parent...

Hi everyone, I used this command to browse.. <input type=file name=uploadfile size="33"> I now want to display the contents of this file in a text Area in my html form. Can any of u give me the method to read and display the file's contents into a text Area? Thanks so much in advance.

I'm using Oracle9i and I have created some stored procedures in them. Can any of u tell me how to view the stored procedure? Thanks in advance..

I want to view the names of all the tables and procedures i have created so far in my Oracle 9i Database... Should I use the dual table for this? How do I do it? Thanks for ur help in advance...

I guess I ve just overlooked these things till now but here they are: 1) We use keys as IDs in attribute definition but sometimes we use dates or text too as IDs. They are obviously not unique. So why is that? I realize though that for example Hiredate (datetime) or Contactdesc (text) while...

I have a HTML form, and I call an applet within it using the code, <applet code=mycross.class width=520 height=500> </applet>. I want to know how I can extract values from this applet and display it on my HTML form. (The value I need to extract is a 2D String array.) I need to do this because I...

I have a SQL server 2000 database where there is a column called IsLead that is of type 'Bit' and has values 0 & 1. There are NULLs too but I don't know if that is the problem. When I try to view those values in MSTR while making it a filter the data does not display properly. Also on the...

Hello guys, I am trying to generate a report with 3 columns to give out results which have NULLs on certain cells. I realized that the rows with NULLs were not being displayed. I am trying to play with the VLDB to perform a LEFT OUTER JOIN. But the SQL only has JOIN between each table. How do I...

I came across an interesting situation. I have the following data: Date Type 3/9/2004 12:00:00 am Acquisition 3/10/2004 12:00:00 am Acquisition 3/12/2004 12:00:00 am Acquisition 3/8/2004 12:00:00 am Expansion 3/9/2004 12:00:00 am Expansion 3/10/2004...

I tried to copy an attribute called DEAL into the same folder. Basically with the <CTRL> key down I dragged teh object into the same folder so that it created 'COPY OF DEAL'. I then renamed 'DEAL' to Deal_Test and 'COPY OF DEAL' to 'Deal'. Now when I try to delete Deal_Test which was the OLD...

Hello everyone, Can SQL be hard coded and used to generate reports? To put it in better words..can I write the SQL statement with corresponding attributes and metrics in some place in MSTR which would generate a report? Thanks in advance for the help