If you are unable to create a new account, please email support@bspsoftware.com

 

Display returned number of records before proceed to report page

Started by clingst, 23 Mar 2015 12:00:52 AM

Previous topic - Next topic

clingst

Good day Peeps,

I am working on a report with massive report returned.
Sometime, filtering is not sufficient enough to reduce the volume of data returned.
Extensive filtering is required in order to reduce the load of report.

I intend to show the number of records after submit the prompt from prompt page.
User only proceed to report page after the count is displayed.
They can the extend the filtering option if the count is too huge.

There are two options for count display before proceed to report page.
1) Display the count on the prompt page.
2) Put the count on Pop Out box.

I tried the PopOut Box https://www.ironsidegroup.com/2011/07/25/ibm-cognos-and-javascript-%E2%80%93-part-i/
I followed the setting https://fam.nwcg.gov/crn/famweb/cognos_ie_settings.pdf
however, the pop up box is not showing..

Hereby hope to have your advice how can I work this out..

Thank uu

bdbits

Let's simplify. First let's deal with the popup. Try this:
* Create a new report - package does not matter.
* Drop an HTML Item from the toolbox on to your report.
* Double-click the HTML Item and paste this into it:

<input type=button value="Click Me" onClick="alert('Can I help you?');" />

Then click OK and run the report. Click the button. Do you get a popup?
* If not, then it may be a browser setting.
* If you get the popup, then there is something wrong in your report.

clingst

thanks for reply :)
yes.. i got a popup with the alert box.

but now i am cracking head how to  to STOP the report page from loading and stay at the prompt page after the pop up box.

According to the API list.. none of the API allow me to NOT navigate to the report page.
http://www.brightstarpartners.com/techcorner/Techniques/nov2012technique1.php

I am thinking of using RENDER variable (String Var) at page level
But this seem like not working (I am debugging not sure if there is any mistake when i m setting the boolean) T_T

clingst

i think can make the prompt page stay just with the REPROMPT API.
the selection is remained..
seems doable.
thanks!

clingst

now i have problem how to get the dataItem value in JS.
I need to show the number of record in the popup box
i tried https://www.ibm.com/developerworks/community/forums/html/topic?id=e0700430-df8c-46e7-bc4e-8042070a7ce0

alert('''+[qryTest].[ValueName]+''');
but i m not getting the value.. but the text itself..

please advice further..

erikb10

try building a pair of drill through reports.

the first (top level) report will have all you filter choices as optional filters and the report itself will just be your record count.  If they don't like the count, there are several ways to have the user re-run the prompts and add more filter values.

Once they like the count, it is the drill trough link.  It drills through to the full result set report with the same filters, all optional, and you just pass the prompt values from the top report. 

I don't know a way to do what you want with one report, but with a drill through report you can get what you want.