0

Superscript

Jet Reports Historic Posts

August 22, 2012 13:36

None

Follow

Hi There

I was wondering if someone would be able to help me understand how superscript works with Jet. I use Jet to prepare financial statements, the data is pulled from Navision. I'd like to include superscript in a non formula based cell to indicate a note reference. The problem I'm having is that whenever I switch between design/report modes I lose my superscript, Jet is switching the font back to regular size. Is there anyway to protect my superscript or will I need to reformat everytime I switch to and from design mode?

Thanks

A

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts August 22, 2012 15:09

  Hi A,
  
  I'm trying to reproduce your problem and so far I can't reproduce it. I created a report with Auto+Hide+Values in cell A1 and an NL(Rows) formula with a header above the formula and also a cell on the same line as the formula that is in superscript. I can then run the report and go back and forth between Design and Report modes and the superscript doesn't disappear. Either you must have a much earlier version of Jet or else you are using the superscript in a different way. What version of Jet are you using and can you describe how you are using the superscript and what the structure of the report looks like?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 22, 2012 17:22

  Hi Hughes
  
  Thanks for replying so quickly I'll try to give more details here.
  
  I am using Version 9.2.10131.0 of Jet Reports.
  
  I am very new to Jet Reports so I'm afraid my structure may be a little inefficient but this is what I have: In cell A1 I have Auto+Hide+Values, Column B contains the account numbers I am querying, Column C is empty, Column D is where I have hard keyed the actual account name (and at the end of the account name is the superscript number 1, number 2 etc), Column E =gl("Balance",$B12,TEXT(LastYearFrom,"m/d/yyyy"),TEXT(LastActual,"m/d/yyyy"))*-1, Column F =gl("Balance",$B12,TEXT(YearFrom,"m/d/yyyy"),TEXT(PeriodTo,"m/d/yyyy"))*-1, etc…..
  
  I'm wondering if now if the problem is that in a single cell there is both regular text and superscript? For example my report has this item in column D "Administration fees1" now that I've switched to design mode, but what I would prefer is this "Administration fees[size=50]1[/size]"
  
  Does that help to explain a bit better?
  
  By the way rather than hard key those account names in column D does Jet GL module have the ability to pull the name from the database directly?
  
  
  
  Thanks again
  
  Adam

• 0
  
  Jet Reports Historic Posts August 22, 2012 19:52

  Hi Adam,
  
  Aaah I see, it appears to happen when the text is only partially a superscript. If all the text in the cell is a superscript then it sticks around, but not when it's only partially a superscript. It doesn't seem like it's version specific after all. Due to the way Jet copies formulas to and from sheets, I kind of doubt that is possible to fix. The easiest way to work around the problem would be to just have an extra cell with the superscript next to the regular cell. Then you can make that column with the superscript very narrow. Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 23, 2012 12:11

  Hi Hughes
  
  I was working up to that but actually hoping there was a way I could do this without inserting another column. Anyway if inserting a column will allows me to retain the superscript it'll be worth the effort to move a few things around on my statements, I go in and out of design mode quite frequently since the statements are still in a state of transition. I appreciate your help Hughes you're the best. :)
  
  Thanks
  
  Adam