0

Sheets-generating report : possible to rename Excel tabs?

Jet Reports Historic Posts

June 29, 2011 11:00

None

Follow

Hi there,

I proudly designed a sheet-generating report to create one tab per HR reprensentative (talking Employee lists, here), but the Excel tab names are not very slick-looking : "MyDataSource";"table xy";"whatever number";

Would it be possible to have the Jet Report automatically rename the Excel sheet tab using the table he creates the sheets from ? In my case, the HR Representative names ?

Thanks a ton for your help !

• Facebook
• Twitter
• LinkedIn

6 comments

• 
  Jet Reports Historic Posts June 29, 2011 14:50 Official comment

  Hi,
  
  I think your problem is that you didn't actually specify a field in your NL(Sheets) function. You probably have a function that looks something like this:
  
  =NL("Sheets","Employee",,…)
  
  This will generate record keys (the string with data source, table, etc.). Record keys are designed for you to use with the NF function to get fields from the table, but they aren't very human readable. What you need is something like this:
  
  =NL("Sheets","Employee","No.",…)
  
  This will generate a sheet for each employee with their number as the sheet name. Does that make sense?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 01, 2011 13:15

  Hi,
  
  I think your problem is that you didn't actually specify a field in your NL(Sheets) function. You probably have a function that looks something like this:
  
  =NL("Sheets","Employee",,…)
  
  This will generate record keys (the string with data source, table, etc.). Record keys are designed for you to use with the NF function to get fields from the table, but they aren't very human readable. What you need is something like this:
  
  =NL("Sheets","Employee","No.",…)
  
  This will generate a sheet for each employee with their number as the sheet name. Does that make sense?
  
  Regards,
  Hughes

  Little side-note: the sheet name will be the field value, so the value of the field specified in the third argument of the function.
  
  If you use something like a person:
  =NL("Sheets","Employee","No.",…)
  The sheet name will be the employee no.
  
  If you do
  =NL("Sheets","Employee","Initials",…)
  The sheet name will be the initials.
  You'd have to look out, as the field should be unique so No. would be the best choice.
• 0
  
  Jet Reports Historic Posts July 04, 2011 10:05

  Hi,
  
  Yes, you nailed it, I used a undefined-field database address to have all freedom using NF functions based on it.
  Any other reason I'd better give up this report structure ? I guess it is lighter and quicker when designed like this than with multiple NLs, right ?
  
  Thanks,

• 0
  
  Jet Reports Historic Posts July 04, 2011 10:20

  Nope, you just have to "give it up" for the sheet generator.

• 0
  
  Jet Reports Historic Posts July 04, 2011 11:56

  OK - thanks. I will investigate and see how it works.
  
  Your feedback is very useful - thanks a ton !

• 0
  
  Jet Reports Historic Posts July 04, 2011 16:27

  Hi there,
  
  I updated my report according to your recommendations and it works just plain great : thanks a lot !