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...
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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.