topic Re: Blank reports? in Discussions

Blank reports?

natalie_ — Thu, 31 Mar 2016 13:22:14 GMT

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.

Re: Blank reports?

txnelson — Thu, 31 Mar 2016 13:33:18 GMT

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?

Re: Blank reports?

Craige_Hales — Thu, 31 Mar 2016 13:34:28 GMT

check the JMP Log for messages.

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

Re: Blank reports?

natalie_ — Thu, 31 Mar 2016 18:33:32 GMT

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?

Re: Blank reports?

natalie_ — Thu, 31 Mar 2016 18:36:36 GMT

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?

Re: Blank reports?

ms — Thu, 31 Mar 2016 19:29:24 GMT

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)));

Re: Blank reports?

Craige_Hales — Thu, 31 Mar 2016 19:38:03 GMT

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

Re: Blank reports?

Craige_Hales — Thu, 31 Mar 2016 19:40:14 GMT

that's a better idea than I was having.

Re: Blank reports?

natalie_ — Thu, 31 Mar 2016 21:18:32 GMT

Thank you, seems to be working so far!