1. Report
Studio --The prompt to open or save the report does not appear.
The prompt
to open or save the report does not appear due to a setting in Internet
Explorer. You will need to enable
automatic prompting for file downloads.
In order to resolve this issue you
can perform the following steps:
1.
Open Internet Explorer![endif]>![if>
2.
Tools -> Internet Options![endif]>![if>
3.
Click on the Security tab![endif]>![if>
4.
Click on Internet ![endif]>![if>
5.
Click Custom Level![endif]>![if>
6.
Ensure that Automatic prompting for file downloads
and File Download are enabled![endif]>![if>
7.
Click OK![endif]>![if>
8.
Repeat the same steps for Intranet and Trusted Sites![endif]>![if>
2. Report
Studio -- How to prompt a user to perform a page break with a list
report.
You can
add a calculation within the list report that is based on a value prompt.
1)
Within Report Studio, create a list report based on Go Sales and
Retailers cognos sample package. Add the
Sales territory & Country query items (under Countries Query Subject)
and the Quantity query item (under Orders query item).
2) Under the Page Explorer, add a new
prompt page.
3) Add a Value prompt in the prompt
page and define a new parameter called Page Break (Choose the Toolbox tab under Insertable
Objects and drag the value prompt to the prompt page work area)
4) Select the value prompt and under the
Properties pane double click the Static Choices item. Add a new
"Yes" value and a new "No" value.(Choose the use and
display values as "Yes" and for the "Yes" choice and
the use and display values as "No" for the "No"
choice). Also set the Default Selections property to "Yes"
(Double-click the Default Selections and add the "Yes" value)
4) From the Query Explorer, select
Tabular Model. Click on the Toolbox tab under Insertable
objects and drag a new Data Item to the Data Items pane. Rename this Data
Item, c1(select the data item and under the Properties pane, change the
Name property to c1)
5) For the c1 data item add the
following expression:
if (?Page Break? = 'No') then ('No break') else ([Sales
territory])
The above assumes that you have added
the Sales territory data item into your list report and it is a grouped
item. (See the attached report spec)
6) Go to the Page Explorer and select
Page 1. From the Insertable objects pane, under
Query Items, drag the c1 data item into the List report as the first item
(just before the Sales territory item. Select the c1 and Sales territory
items and choose to group the items.
7) Select the c1 item, and under the
Properties ensure the following is set:
a) Query Item = c1
b) Level Span = c1
c) Content = Value
d) Horizontal Alignment = Right
e) Sort = Don't sort
f) Key = Yes
g) Aggregate Function = None
8) Run the report. If you select 'Yes',
the report will page break on the Sales territory item. If you select
'No', no page break will occur. (see the attached report spec which is
based on the Go Sales and Retailers sample report)
3. SDK
-- Cognos SDK Guide by BI Centre
You will
have your own functional Cognos 8 SDK web solution that has been tailored
to be scalable and flexible in order to adapt to your unique business
requirements and solution architecture.
The Cognos SDK Guide by BI Centre
provides you with the complete source code for a C# web solution, C8.1
report based on the GOSR package, and a Word document that will serve as
your core reference to understanding the Cognos 8 SDK. It will cover C8 SDK topics such
as: authentication; querying the
content store, rendering a C8 report in ASP.NET; exception handling; and
much, much more.
You can purchase the Cognos SDK
Guide by BI Centre through PayPal.
Get your Cognos
SDK Guide by BI Centre!
|