Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Doogal

Avatar / Picture

Guru
Registered:
Posts: 1,564
Reply with quote  #1 

Don't think this can be classified as a bug, since we were using undocumented functionality but the behaviour has certainly changed. In version 6, you could use something like this 

 

Quote:

eworkGetCell(sGridName, c, -1)

 

to get the column headings from a grid. This no longer works. You can now get to the column headings with something like

 

Quote:

var LGrid = eworkData.FieldByName(sGridName);
var LRow = LGrid.HTMLfield.rows(0);

var LCell = LRow.cells(c);

var heading = LCell.children[0].innerText;

0
MFDA62006

Member
Registered:
Posts: 46
Reply with quote  #2 
Anyone know how to do this in 9.

eworkData.FieldByName(gridName).HTMLfield.rows(0).cells(h).innerText

doesn't work for me anymore to get the grid column header.

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #3 
Get it from the Business Object is my advice. We have this in our BO Reporting Library:

http://processmapping.com.au/freestuff/freemetastormbpm9solutions/BusinessObjectReporting.html

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
MFDA62006

Member
Registered:
Posts: 46
Reply with quote  #4 
Thanks Jerome.

I will definietly take a look at this. Basically, I'm trying to add a button to a form that will export the contents of a grid on the form to excel. I had this working fine in my v7 "procedures" but in v9 things have changed. When I tried my v7 code it brings through the data but not the column headings. Is there an example of an export to excel in a particular v9 form in the Development Solution?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #5 
I do not do an export to excel, as this is now included in the Report functionality. Would that not work for you?

All I have now is to export to HTML, but the code in there would show you how you might export to excel. It is all server side now, though, so the excel side would have to be in a client script.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
MFDA62006

Member
Registered:
Posts: 46
Reply with quote  #6 

We use SQL Server Reporting Services for all our reporting. So I just have to figure how to call ToHtml.Plain("TitleOfReport", NameOfBO, "") client side.

 

 

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #7 
All we do is create a memo field on the form with the calculated value being the return from that function. We then use the following function from our library to open the HTML page:

OpenWindowWithHtmlFromField( <name of memo field> );

the function does this:

function OpenWindowWithHtmlFromField( sFieldName )
{
    window.open("about:blank").document.write( GetField(sFieldName) );
}

I keep it in the library because I can never remember the syntax, and because sometimes IE versions need it to work slightly differently.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!