Help Needed in Reportnet

[Abhi2379]

HI,

I know that we can create the templates(.imt) file in impromptu, and those can be applied to reports.

on the similar line I want to know if we can do this in Reportnet.if yes how, any docs or information will be helpful.

My requirement is
1) Creating templates and storing them in DB.

2) Depending upon the user loging I need to choose the
template and publish the Invoice report on webserver (in
PDF)
3)I need to automate this procedure (may be using script).
does Reportnet reports supports cognos scrits ?

Please advice,
Thanks in advance

Regds
~jit

 

[Abhi2379]

can macros written for impromptu reports works for Reportnet reports ?

Any idea about applying templates in Reportnet

Thanks In advance
~jit

 

[cindyw]

You can build templates. I didn't write the attached...it is from another person in my local user group. I'll note that I found it easier to modify a blank template, than start with a new report. Also, check the permissions on any new files you create..that can trip you up.

1. Files & file locations that need to be modified:
\\install path\CRN\ webcontent \pat\AppComponents.xml
\\install path\CRN\ webcontent \pat\templates.xml
\\install path\CRN\webcontent\pat\res\reportstudio_en.xml
2. Create a report in ReportStudio. It does not matter what package you use. Be sure to uncheck the Auto Group and Summarize box. This report will be used as a global template.
3. Copy your report to the clipboard. I would recommend saving it as a text file as a backup just in case as well as make a backup of the above .xml files.
4. Open the templates.xml and add a new entry for your template. You can either modify the existing list template or create a new entry. I copied the standard list and renamed it GMAC and deleted everything in between the <template name> tag and </template> end tag. Then paste your report after the <template name> tag. You will also have to delete the model connection information. Here’s an example:

<template name="GMAC">
<report xml:lang="en-us" xmlns="

http://developer.cognos.com/schemas/report/1/"><!--RS:1.1.230.2-->

<modelConnection name=""/>
<querySet xml:lang="en-us">
<BIQuery name="">
<cube/>
<tabularModel name="Tabular Model1" autoSummary="false"/></BIQuery>
</querySet>
<layoutList>

5. If I remember correctly, you have to delete any reference to Query1 in the xml otherwise in ReportStudio it will name each new query ‘Query1Query1’ and keep adding ‘Query1’ with each additional query. Once you have added your template save it and close it.
6. Next, open the AppComponents.xml. This will allow you to add a new icon in ReportStudio when you select a new report. You need to add an entry for your new template if you created a new template. If you used the existing LIST template or another existing template, you do NOT have to proceed any farther.
7. You need to copy an icon to \\install path\CRN\ webcontent \pat\images\ directory. Copy any one of theses entries and make the appropriate change to match your Icon Name and Template Name. I’ve highlighted the entries that you need to change. Once changed save and close.

<!--Copyright (C) 2004 Cognos Incorporated. All Rights Reserved.
Cognos (R) is a trademark of Cognos Incorporated.-->
<Components>
<ListView id="New" view="Icon" clipLabels="false">
<ListItems>
<ListItem idsLabel="IDS_LBL_NEW_BLANK_REPORT" icon="icon_blank.gif" templateName="Blank"/>
<ListItem idsLabel="IDS_LBL_NEW_GMAC_REPORT" icon="icon_gmac_list.gif" templateName="GMAC"/>
<ListItem idsLabel="IDS_LBL_NEW_GMAC_CT_REPORT" icon="icon_gmac_list.gif" templateName="GMAC_CT"/>
<ListItem idsLabel="IDS_LBL_NEW_LIST_REPORT" icon="icon_list.gif" templateName="List"/>
<ListItem idsLabel="IDS_LBL_NEW_CROSSTAB_REPORT" icon="icon_crosstab.gif" templateName="Crosstab"/>
<ListItem idsLabel="IDS_LBL_NEW_CHART_REPORT" icon="icon_chart.gif" templateName="Chart"/>
<ListItem idsLabel="IDS_LBL_NEW_REPEATER_REPORT" icon="icon_repeater.gif" templateName="Repeater"/>
<ListItem idsLabel="IDS_LBL_NEW_BROWSE" icon="browse_32x32.gif" idsTooltip="IDS_TOOLTIP_NEWBROWSE" isBrowse="true"/>
</ListItems>
</ListView>

8. Open the reportstudio_en.xml. Search for “NEW_BLANK_REPORT”. You should see something like this:
<string id="IDS_LBL_NEW_GMAC_REPORT" type="Control Label">GMAC List</string>
<string id="IDS_LBL_NEW_GMAC_CT_REPORT" type="Control Label">GMAC Crosstab</string>
<string id="IDS_LBL_NEW_BLANK_REPORT" type="Control Label">Blank</string>
<string id="IDS_LBL_NEW_LIST_REPORT" type="Control Label">List</string>
<string id="IDS_LBL_NEW_CROSSTAB_REPORT" type="Control Label">Crosstab</string>
<string id="IDS_LBL_NEW_CHART_REPORT" type="Control Label">Chart</string>
<string id="IDS_LBL_NEW_REPEATER_REPORT" type="Control Label">Repeater</string>
Copy the highlighted in yellow <string id and rename it similar to the green highlighting. The name GMAC List is what the user will see when being prompted to select a new report. Save and close.

9. You may need to clear your browser cache before seeing the changes.

 

[Abhi2379]

Thanks a ton cindyw. This is very useful and descriptive information from you.