Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created 2 qvw files f1.qvw (saved in normal mode) and f1_run.qvw(saved in web-view mode),
f1.qvw has a chart containing the name of recipients, their email, filter condition, and group. Example shown below
Chart 1
EmpName Email Filter Group
a1 a1@gmail.com EmpName={a1}<verify> EmpGroup
a2 a2@gmail.com EmpName={a2}<verify> EmpGroup
...........
and another chart containing
Chart 2
EmpName Customer Detail Year Amount
a1 xxx oiuwoier yyyy 99.99
a1 yyy oiwueroi yyyy 908.99
a2 ..............
I build a xx.nsq file with this f1.qvw as the connection. The nsq has a recipient import task (RecipientImport) which imports the recipients from the first chart. Report in the .nsq file is build on second chart and cycles on the EmpName (i.e. separate report for each Emp). I also put condition chart 2 has Values. There are no filter in the report. Another task to run the report (RunReport) which will generate report for the recipients and deliver report to them containing data pertaining to them. No filters on the Task. Only recipient have filters.
When I do the test run of the report it imports the recipients and delivers the report correctly to the recipients.
Now I want to run the report On-Demand with user selection. So, I created f1_run.qvw which has a list box to select the EmpName, Year and Customer. I added Task Extension Object to import the recipients with current selection and connected it to recipient import task(RecipientImport). Another Task Extension Object to run the report with current selection and connected it to Report run task (RunReport) of the nsq.
Question :
1. When I run the recipient import task from f1_run.qvw, each time I run all the recipients are imported and not those who are selected and in the .nsq file a Recipient import task shows another entry of task RecipientImport.( i.e. now in .nsq I see 2 RecipientImport.Task with same name). Is it Ok that each time I run the report I have another RecipientImport Task in my .nsq file.
2. Is it possible to import only those recipients whos names are selected in the list box containing EmpName on the f1_run.qvw.
3. Is it possible to do test run of On-Demand Report, since I do not want to send emails to the actual recipients while testing.
4. As I have understood that .nsq file cannot interact with qvw saved in webview mode, so it needs for connection qvw saved without webview mode (so I created f1.qvw). Extension Objects can be seen in qvw saved in Webview mode (so I created f1_run.qvw). I am not clear now how selections on f1_run.qvw filter data in .nsq file since it is having connection with f1.qvw only.
Please if someone could clarify each of my questions.
Hi Daniel,
I am facing issue with verify option in filters. It throws a warning in case of empty result.
Please give details of what you are trying to do
Hi Ankur,
That is expected behavior when using the Preview option. If you Run the report in a Report Task there will be no popup message - only an entry in the log file.
HTH - Daniel
P.S.: For unrelated queries please start a new discussion and give it an appropriate title. This will make it easier for others looking for solutions to find them.
Hi Tripti,
Daniel is right I was doing a preview then ,later I tried running task and it worked without any popoups.
Hi Daniel,
Thanks for the reply and ran task yesterday morning and it ran successfully wasn't sure then why it didn't throw warning. Next time I will create a new thread for it.
Does this apply to writing to a drive ? I have a task I am running through onDemand and the report queue indicates that it completed successfully but the file is not in the specified path after it completes. Do I need to take the path out of the NSQ file and put it in the extension Task object?
I am running a task because I need it in word format and the report object does not allow DOC files . I set up a task to write the report as RTF to a shared drive for the users to access after task completes. It works when I run it from the nPrinting client. The server does have write access to the shared path.