Search results for query: *

Hello everyone; I've made a report in Impromptu and published it to upfront. When I run the report using web no data gets displayed even though the report runs fine in Impromptu. How should I debug this? What can be a problem?... I have other reports that I have published and it...

Hello All; I'm trying to make a prompt with the option of single char wild card. The wild card char is underscore. If I enter 12_123 in my prompt I would get below parts; 12 1 123 12 2 123 12 3 123 what I need to do is to do two single char wildcard like...

Hello All; I need to show a field in my report that has 200 chracters and I just have 30 char space in my report. How can I wrap the data to be able to show the whole 200 chracters? Thanks; Mitra

Hello All; I need to make a report in Impromptu that looks like this; First Name , Last Name, ... A B Comment : Show the comment C D Comment : show the comment . . . I need to show the comment between each record. The comment field is long and...

Thanks Draoued for your response. I couldn't find the equivalent of NVL in SQL, but if then else function worked. Thanks again; Mitra

Hello group; I've made a very simple calculation field in my Impromptu report that adds two integer fields. calculation field = New Qty+Book Qty Value in New Qty is 1 and value in Book Qty is null. Being math major, I expect to get 1 for my calculation field, but I get zero. What...

Hello all; In my cross tab report, I have two prompts for entering starting and ending period, and period, which is a calculated filed shows as my column. Report is sorted by period as well. This is an example; Starting Period : 2006-01 Ending Period: 2006-02 2006-01...

Hellp group; I need to make a crosstab report that for each row,has 2 different cells. Example Period1 Period2 Item1 qty qty value value Item2 qty qty value value When I create the second...

Yes, I did check the General tab and the location is the same. Thanks for your reply. Mitra

Hello group; I'm trying to publish a report using existing report set, named "test_pub" and I'm getting below error in test_pub.log: "Invalid report set. Cannot find Catalog." In "test_pub" folder I have my catalog and another .imr report which I had previously published and it works...

Thanks drlex. It worked.

Hi group; I have made an expression in my report(named BACKLOG) that it's values are "Yes" and "No". I have made a prompt for my backlog field using File picklist type with values "Yes", "No" and "All". When user chooses "All" at the prompt, I need to show records containing Yes and No for...

Hello group; I'm trying to install IWR and have no clue where to start. How do I install IWR? TIA and excuse me if my question is very basic; Mitra

It's working now. I had to give "Creator" access to "Direct Entry SQL" in Governor tab. I didn't know that not having that wouldn't allow you to go to Folders and Tables under Catalog menu. Mitra

Hello group; I have logged in as "Creator" in one of my catalogs, and I can't access "Folder","Properties","User Profiles"... under catalog menu. User class "Creator" has below rights: Governor Information Create New Reports : Yes Modify Folders : Yes Create New User Classes : Yes...

Hello group; I'm getting error SQLSTATE = 42000, ERROR = 4060 (Error Nbr: 258) when I run Test, in Database Definiton dialog box using OLE DB provider driver. Provider is "SQLOLEDB" and Provider String is: "initial catalog = Avante;Integrated Security =SSPI". Avante is our system DSN...

Thanks DoubleD. I will try to get the $invoiced from sls rep file. Dollar in invoice file is based on comm rate and also what percent of sales order they get commission from. So I thougt there might be a way that I'm not aware of to do it instead of making calculation field to come up with...

In my cross report, row is "Customer name" and "Sales Rep", column is "Yr" and cell is "total $ invoiced". If a cusotmer has two sales rep then invoice dollar is showing twice. Customer Name Sls Rep 2005 Optimum... 2175 $4000 2210 $4000...

Hi group; How can I group a multi value field in crosstab report. This works in "Simple list report" but not in "Crosstab". I'm showing total sales amount and sales rep in my report. If there are more than one sales rep, then it shows the sales dollar twice. In simple list report I do...

Thanks DoubleD. Yes, it' working. In my colum, I'm using Data Definition with some if statements to relabel my coulmns and was making it complicated. That's why I couldn't see it. Mitra