Search results for query: *

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...

I like it! I find it is a lot more complicated that Impromptu, but it can do more of the thingd that I want it to do. Shortcomings, for me, lie in the lack of documentation and support available. Someone writes those errors, so they must know what they mean...but there is very little help on the...

Hi, I have a scheduled job that runs 20 report views, which are saved in the same folder. One of the report views, no different to the others, has started failing since Monday with the following error "CCL-BIT-0016 The request document contains an XML syntax error at line 1, column 464. Code...

Thanks DoubleD, I think that I have a version that doesn't clean up properly! I have removed a lot of those files now and will keep an eye on them.

OK - I found the cleanup wasn't scheduled - I thought it was, but that ought to do the trick.

Hi, I've just been mooching around the server trying to create some disk space and wondering where my 70 GB of hard drive has gone. It never occurred to me to check the output folder from the IWR server report set location. But that's where it all is! Why does it save all of this stuff -...