Subscribe Bookmark RSS Feed

Blank reports?

natalie_

Community Trekker

Joined:

Jan 6, 2016

Hi all,

I don't know if anyone knows the answer to this, but when someone else at work goes to the directory on their computer where reports are saved, the plots all are blank.  Actually it only happens on one person's computer, and I was just wondering why this might be.  Any ideas?  The plots are in the report but without data.

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Try this method to eval the variable before creating the formula:

F = Eval Expr(100 * (Col Rank(:Name("RdsOn Ratio")) / Expr(row)));

dtSummary << New Column("RP RdsOn Ratio", Numeric, Formula(Name Expr(F)));


8 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Natalie,

It appears that individual is not able to get to the data tables that are needed for the reports.  Where are the tables that go with the reports? 

Jim
Craige_Hales

Staff

Joined:

Mar 21, 2013

check the JMP Log for messages.

Are these reports in .JRN or .JRP or some other file type?

Craige
natalie_

Community Trekker

Joined:

Jan 6, 2016

Hi all,

So my colleague let me use their computer.  I see what the problem is, just not why it is happening.

I have three columns with formulas:

dtSummary << New Column("RdsOn HT", Numeric, Formula(1000*0.01/(:Id HT)));

dtSummary << New Column("RdsOn Ratio", Numeric, Formula((:RdsOn HT)/(:RdsOn)));

dtSummary << New Column ("RP RdsOn Ratio", Numeric, Formula(100*(Col Rank(:Name("RdsOn Ratio"))/row)));

When my colleague opens the report, the column RP RdsOn Ratio is blank.  When I open it on my computer, everything is fine.  This is saved as a .jrp file and the data table is embedded.

My guess is that this is happening because I am using row as a variable.  However, on my computer it is fine?

natalie_

Community Trekker

Joined:

Jan 6, 2016

I guess I should explain more about that variable.  It represents the number of rows in the data table which I won't know until after my script is run.  It is incremented in a loop.  If my guess is correct in that the variable is causing the problem, how can I go about fixing it?

Solution

Try this method to eval the variable before creating the formula:

F = Eval Expr(100 * (Col Rank(:Name("RdsOn Ratio")) / Expr(row)));

dtSummary << New Column("RP RdsOn Ratio", Numeric, Formula(Name Expr(F)));


Craige_Hales

Staff

Joined:

Mar 21, 2013

that's a better idea than I was having.

Craige
natalie_

Community Trekker

Joined:

Jan 6, 2016

Thank you, seems to be working so far!

Craige_Hales

Staff

Joined:

Mar 21, 2013

are you using a by variable in the report,  and is the numeric column really blank, and not missing values (period characters)? 

Craige