Recent content by MitraMIS

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