Search results for query: *

Hello, It appears that Cognos ReportNet is very weak on page break options. I did a search and came up with the following two threads, and neither has been answered: thread401-1200849 thread401-1251311 I have a report in ReportNet that combines 3 queries. Query 1 is the master, with...

Hello, I am having a problem with displaying column headers where there is no detail information. My report requires two queries and a Master/Detail relationship between them. Here is my example: Query1 Query2 Grant Fund G1 F1 Person AFund Salary G1...

I have never had a problem having my reports write a pdf with multiple pages. However, I see nothing in Report Studio that could change that option. Have you tried seeing if this is a set-up issue either within Framework Manager, or at initial installation time?

Now I know that this is because the parameter functions output the values as strings when I am actually comparing the value to a numnber." Did you try creating a string variable instead of Boolean? JKas

What about a third query? Can you create one and link to both queries?

Anyone know how I can get the results of two queries into one Repeater? Thanks

Hello, I have a report that is comprised of two queries with multiple tables within a repeater cell. The problem I am having is that Query 2 is a calculation. I want to be able to suppress the entire record from printer when the calculation returns 0. I tried putting the entire cell within a...

Okay, I figured out my problem. I lose the repeating ability when I add a list that is the result of the second query in the report. For example, Query1 is my master query, with Query2 as the detail. They are linked by pledge number. I only need one field from Query2 in the report...

Hello, I created a repeater report with one column and three rows down. Each row represents information for one person. The information is stored is various tables within the repeater. Here is my problem, the repeater was originally working, printing all three people on one page. However...

Hello, I created a Tabular SQL query and then created a 2nd Tabular Model query. Both have one field in common. I want to join the queries. I unlocked, used the data>master/detail relationship. However, when I went to add the 2nd query as detail, it does not appear. Should I be able to...

Draoued, Thanks but this won't work either. I think you think that the program and expiration date are in T1. They would be in T2. That is why I need the inner join. Thanks Jeff

ok, After learning more about ReportNet and SQl, here is my Tabular SQL for the above problem: select distinct ADVANCEMENT_PERSON_ORG_ID.ID as ID, ADVANCEMENT_PERSON_ORG_ID.LAST_NAME as LAST_NAME, ADVANCEMENT_PERSON_ORG_ID.FIRST_NAME as FIRST_NAME...

I actually think I can help. In order to create a date range prompt, you should do the following: 1)Go to the Page Explorer bar and click on Prompt Page. 2)Scroll down on the Insertable Objects Pane until you see "Date Prompt". Double-click, or click and drag over into the prompt page...

Hello, I have a problem trying to create a membership report. Here is an example of my data: ID Program Status Expiration_Date 1 W1 A 5/31/06 1 W1 E 5/31/05 2 W1 E 5/04/05 3 W2 E 5/01/05 4 W2 A...

Hello, Using ReportNet 1.1, I am trying to create a report that sums the people within an age group. I want to count each person only once, but sum all people into one row by age. Here is what I did: 1) I used the "count(distinct)" function on each person's ID. 2) I used the "years between"...

Hello, I tried using the _age function in ReportNet 1.1 as follows (where Birth Date=1/26/84): _age([Birth_Date]) The returned value was 210,225. I even tried formatting the column differently. I then used the _years_between function and it returned the correct value of 21. The years...

I think I may have found a solution: I created a query with all my need fields (including date parameters). I then added a child Model (Expired) and set the filter to where member status=E. I then added a second child model (Active) to the query and set the filter to where member status =A...

Hello, I am using Cognos ReportNet 1.1 and need some help. I am trying to create a report using the following requirements: -A list of people that are in a membership association. -The data includes membership status (a=active, e=expired) -The data include membership expiration date. - I want...

Flex13, Thanks. However, the filter does not exist in the Tabular model either. The only place it seems to exist now is within the sql. I now realize that the packages were updated since the report was created. I thought I read somewhere that this could be the problem (stored mulitple model...

Hello, I created a report in ReportNet (v1.1). I added some filters for my testing. I later deleted the filters. However, they still exist in the SQL. Has anyone else had this problem? Thanks p.s. This is a problem because when I tried to delete them directly from the SQL, the report...