is it possible to store Different comments in a single variable based on Different Month selection...?

[dhasharadh]

Hi All,

We have 3 reports and one main page / sheet where we show all the 3 reports summary and comments given by the user.

using input box and variables we are showing the comments in the main page that are given by user in the different report pages.

Requirement :

1. Now  the comments are not based on month Filter , we want them to be respective to month.

2. suppose the user navigated to report page with 2015 Jan selection and Gave some comment to Deploy report as  " Accepted"

  and again he changed the selection to 2015 Feb and Commented as " Reviewed "   and so on.

and finally he returned to Main page and he selected 2015 Jan then I have to show comment as " Accepted" like that their respective Comments by year and Month wise should have to display here.

Please find the attached sample Qvw.

Please give some suggestions to achieve this kind of feature.

Thanks in advance.

Best Regards,

Dhasharadh.

[#2]

I would do this:

1. Created a new button object. Then for the button properties did this:

2. Under tab-actions chose the "Run Macro" as action and "StoreCH1TableToQVD" as macro name.

3. Under edit module entered the ffg code:

sub SaveTableToFile

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "e:\CH1inputs.qvd", 4

end sub

Check VBscript and allow system access under both security options.

Everything else left as default.

This would write out a qvd with the inputted comments.

[dhasharadh]

Hi Pravesh ,

thanks for the Quick response , but here am not getting one thing.

as per your answer its clear that we are storing that chart1 which is having summary values in the main page and again we are storing them in the Qvd format and using them.

here my requirement is I want the comments given in the reports page should display in the main page. with out reloading the application.

if i use the above method is it possible to reflect the comments in the main Page without reloading the App.

please share the Qvw if possible it will be more helpful to us.

Thanks again.

Best Regards,

dhasharadh.

[boorgura]

You can achieve this using "InputField" - which is similar to the regular fields in the app, except that - the values can be altered on the fly. (Values can only be changed, new values cannot be added - So you will have to create dummy entries for each month, in your case)

***The catch with this approach is - it is user specific, meaning it is not persistent.