Recent content by JeannetteC

I should have said - ReportNet V1.1 MR1! Thanks Jeannette

Hi, I would like to create a report that is based in order lines. It will prompt for two products or sets of products and a time period. I want to establish which customers have bought productA and not productB, productC and productD. I have tried using master detail; creating a filtered...

Hmmm, so, further info to this is. I have managed to get a count on the count, so I now have a flag that is either 1 or 0 for each count. Theoretically, I could now just total them up. But that doesn't work. Populating a second list with the count and user from the original query results in a...

Hi, Can anyone tell me if this is possible, and point me in the direction of how? I have a detail report, which counts the number of purchase orders in a month for each product. There are about 8 criteria (filters) to be included in the report and also a summary filter on the count to include...

Hi, Thanks for your responses. I didn't understand why it was not visible, but as soon as I imported the metadata I had the new source available. Thanks Jeannette

Hi Everyone, I have created a data source connection the web portal of ReportNet. How can I view and set up the model in Framework manager? Do I have to add it in there as well?? Thanks Jeannette

Hi, You mention it is excel, have you tried a.n. other format to see if this is excel related? Is it just this one query? Where is the content manager installed and also the content store? It may be that the resources are not available to do the processing - are they all on the same database...

Hi Folks, I have been messing aaround with a report for a while and it has a lot of seperate queries, which are just a summaries based on certain filters. All I need from this is the summarised info - which I get by inseting a list with only one column in. I actually want to supress the header...

Hi Everyone, I wonder if you can shed some light onto what os happening and whether I can do anything to improve this? I have a report, it has several prompt pages. Page 1 - Single prompt - Year Page 2 - Cascading prompt - 4 levels - Product Group. Etc When I run this report directly after...

Hi, Perhaps I didn't explain very well, I will try again. Let's say that we are looking at orders. We have a manager who would like to see the breakdown of orders for the product groups (I will work with the Great Outdoors theme if you are failiar with it as the Cognos sample database). He...

Hi, Well, I have amazed even myself! It's amazing what a bit of peace and quiet can allow you to do! I'm not sure if it is the most elegant way to do it, but I created a union in a tabular set and converted the credit values to negative and eventually got it working. Hoorah! Jeannette

Hi, Yes, you can!

A crosstab that the rows or columns come from different groupings or are filtered differently. So you would (generally) have a common theme in the rows (say product group. And unrelated columns, say Dates (perhaps months or quarters) and type of order. The crosstab does not have a summary...

Hi, I don't know why this stuff keeps happening to me. But if anyone can shed any light on this I would be grateful. One SQL 2000 database, serves both Impromptu and ReportNet. IQDs created in Impromptu serve the Powerplay cubes. Server Admin have asked me to change the password on the SQL...

Hi, Just had an opportunity to look at this, I'm not sure that I can so this in the data base, because date is not the only filter on the two parent queries. They also look at several other tables (products, customers etc). I had a go using a Tabular Set (using the except function - it says...