[CLOSED]Pre defined values XLS

Silver Member

posted

Hi Darin,

Thanks.

1.I want to make the autofilter in XLS through report code.

Thanks in advance.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

GamP

Virtuoso

posted

I don't think you can do this directly from the webfocus code. You might (but no garantees here) get things like this done by using excel templates.... It's worth investigating.

GamP

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

Posts: 1961 | Location: Netherlands | Registered: September 25, 2007

Ignored post by GamP posted

Silver Member

posted

Hi Gamp,

I want to make one column in XLS as dropdown.

Thanks in advance.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

Virtuoso

posted

A drop-down is a control used to populate a variable or perform some function. There is not a way for WebFOCUS to populate a control in an Excel spreadsheet. It just creates a report by populating the cells in a spreasheet with data.

Are you trying to create some sort of a launch page for an Excel quick-query type application?

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Silver Member

posted

Hi Darin,

I want to Create a drop-down list from a range of cells in Excel using webfocus.

Thanks in advance.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

Silver Member

posted

Hi All,
Greetings.

I want to know how to populate a particular cell in EXCEL using CAR file.

Thanks in advance.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

Virtuoso

posted

WebFOCUS isn't the tool you need. It doesn't operate in the Excel environment like you're looking for. It can read an Excel file as data (if you're really desperate) and output an Excel file but it doesn't create a drop-down control in Excel from Excel data. Sounds like you need an Excel macro or something of the like.

I'm still completely confused as to why you want a drop-down control in an Excel spreadsheet. You just keep saying "I want....." without explaining what you are really trying to accomplish. In any case I really doubt you're going to get what you're looking for from WebFOCUS.

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Silver Member

posted

Hi,

For example,

Table file car
print car
country
on table pchold format exl2k
end

in Excel, the cell name country, there should be a dropdown to select the value from that dropdown and save.

Tahnsk in advance.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

GinnyJakes

Expert

posted

Why don't you make the output format EXL2K PIVOT? Won't that give you what you need?

SET EMPTYREPORT = OFF
TABLE FILE CAR
PRINT
     SALES
BY
     CAR
HEADING
"CAR File PivotTable"
"Sum of Sales by Car"
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K PIVOT
PAGEFIELDS COUNTRY
CACHEFIELDS MODEL
END

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Silver Member

posted

Hi,

Thanks for the info.

But i need the dropdown in excel for a particualr cell.This is our requirement.
Is there any way to populate a dropdown in excel for a particular cell instead of using pivot

Thanks in advance.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

Tom Flynn

Expert

posted

Then, you'll have to learn EXCEL and VB.

Putting a DropDown ListBox in a Cell

Many others on the web...

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Francis Mariani

Expert

posted

The drop down you're talking about sounds like an Excel AutoFilter.

You can create an Excel template where one tab is the data as retrieved via WebFOCUS and the other tab is how you want the use to see the data (with the AutoFilter). This is quite easy to do. There are very clear instructions here:

Creating Reports With WebFOCUS Language > Choosing a Display Format > Using Excel Display Formats: Excel 2000, Excel 97, Excel > Creating Excel Templates

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Silver Member

posted

Hi,

Thanks for your help.

Could you please provide me some example,

Any help would be appreciated.

Thanks and Regards
Shakila

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

Virtuoso

posted

I'm not trying to criticize, but in the few minutes since the previous post you could not possibly have checked out all the information in the references given to you by Tom and Francis, which I'm sure have the examples you are looking for. Try doing some of the work yourself before asking others to do it for you.

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Francis Mariani

Expert

posted

shakila25, there is enough information in the documentation for you to create an Excel template and write a WebFOCUS report to use one.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

SureshKumar

Silver Member

posted

Sample using CAR file:

  
TABLE FILE CAR
HEADING
"CAR REPORT"
PRINT 
SALES
BY COUNTRY 
BY CAR 
ON TABLE SET STYLE *
TYPE=HEADING,COLOR=BLUE,STYLE=BOLD, SIZE=14, $
ENDSTYLE 
ON TABLE PCHOLD FORMAT EXL2K PIVOT
CACHEFIELDS MODEL TYPE 
END

Webfocus 8002M, 8009
OS: Windows7

Posts: 33 | Registered: July 31, 2008

Ignored post by SureshKumar posted

<JG>

posted

SureshKumar That's not an example of what shakila25 is looking for.

quote:
Is there any way to populate a dropdown in excel for a particular cell instead of using pivot

Silver Member

posted

Hi,

I tried so many ways to populate a dropdown in excel for a particular cell instead of PIVOT.

Example:
FILEDEF TEST2 DISK test.mht
-RUN
TABLE FILE CAR
PRINT DCOST
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'test' SHEETNUMBER 1
END
-RUN

1. Creating a mht file with the dropdown.
2. I tried calling the .mht file through webfocus.
3. It is replacing the values and dropdown is not populating.

Please anyone know the solution of this it will be great helpful and thanks to everyone.

WebFOCUS 7.6.x
Windows
Output: Excel,PDF, HTML

Posts: 42 | Registered: September 28, 2007

Ignored post by shakila25 posted

Virtuoso

posted

Again, I don't like to be critical, but if someone's trying to do something way past their capabilities, I'm likely to say so. Your best solution is probably to pay someone who has the expertise to do what you want or get IBI tech support to walk you through the processes (which they might not do either because this involves more Excel knowledge than WF knowledge.)

Several individuals have given you more than enough information to get the job done, but you're not paying close enough attention to the details of how to accomplish individual tasks. Instead of trying to swim across the Atlantic, try a few laps in the pool first. (In other words, stick with the simpler stuff until you get the experience you need.)

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Francis Mariani

Expert

posted

shakila25, heed what Darin mentions in his last posting.

Also, "It is replacing the values and dropdown is not populating" - if you have the template successfully being populated, then you're almost there!

"SHEETNUMBER 1" of Excel template (mht) "test" is what WebFOCUS populates. Any other sheet in the Excel template can refer to the cells in sheet 1. Sheet 1 is the WebFOCUS working sheet, and another sheet is the one the user should be working with. This is the one where you can set up the AutoFilters.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Maran

Gold member

posted

Hi..
Below link will help you to create dropdown in excel.

http://forums.informationbuild...367012926#2367012926

Thanks

WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs

Posts: 86 | Location: India | Registered: November 03, 2015

Ignored post by Maran posted