How to add description to excel export

[mayankraoka]

Hi All,

I am trying to find out a way where we can add description (Text) to the charts excel export.I know how to add current selection.Is there any way we can description of chart reports?Or is there any way to export graph(Images) along with grid report(Tabular) of the chart?

Regards,

Mayank

[mayankraoka]

Any suggestion to this question?

[trdandamudi]

Are you looking to add title to the charts? If so you can add the Title to a text box and copy that text box to a specific cell. If you think I am not clear can you send a small sample please with expected output.

[mayankraoka]

Hi Thirumala,

I have attached the snapshot of the export.In this export On top I have added the report description.Is their any way we can add description of the report along with data .

Regards,

Mayank

[Anil_Babu_Samineni]

Do you know how merge the two reports. If yes, use text object content with the 100% opacity and then take that chart along with this description object from your reports. I really don't know where these reports are producing. If nprinting let me know. Or else use qv sample reports from reports tab..

Good luck

[trdandamudi]

Along with the data it is not possible. If you can use Macro then you can pass the report description and then the data,

If you are exporting the chart manually then do as below:

1) Create a Text box and type the "Report Description":

     Example: Data set with Sales details

2) Create the Chart (Pivot or Straight)

3) Now to export to Excel, Right click on the Text box-->Copy To Clipboard -->Text

4) Go to the cell in Excel and paste it.

5) Right click on the Pivot or Straight Chart-->Copy To Clipboard -->Full Table

6) Go to the cell in Excel and paste it.

Now you will have both Report Description and the chart. If you have to do for few charts then this will work. Hope this helps...

[settu_periasamy]

One more suggestion using macro.

You can add your description in the caption ( include formula)

Try the below link macro

How to export to Excel include Title Caption?

[mayankraoka]

Hi Anil,

I have attached sample qvw having 2 charts.I need the export with title description.I want when user cliks on excel icon get the report export as well as description.I dont want user to do do manual copy paste.We are not using nprinitng.

Is there any best way to do this?

Regards,

Mayank

[mayankraoka]

Hi Settu,

Thank you fro your reply.But before going with Macro option,I have few queries:

1-Will macro work in Ajax client?

2-I have to give export option for all the charts in the dashboard,Is it feasible with macro?

Regards,

Mayank