Search results for query: *

Hello again all! I am using cognos 8.4, and have a crosstab report with multiple nested rows, a couple of columns and one measure. I would like to have a header for the rows, much like is automatically generated with a list. I've tried the following to no avail: 1. Add cross tab space and...

Hi all I'm using report studio 8.3, and have in the past selected "no data" in the run options to run a report without data in order to view the output formatting. I have also in the past created jobs in cognos connection that run a list of reports (some with default values, others with...

Hi all Using report studio 8.3 I have a prompt page with many prompts, many of which are controlled using hmtl item. Simply put the html ensures one of 3 prompts must be completed before "finish". Thus after selecting an item in prompt 1, if the user selects an item from prompt 2, then...

Hi all Using 8.3 Cognos report studio. I was someone could tell what is wrong with the follwing case statement, used in a detail filter in a report: "CASE WHEN ?pID? between 73 and 84 THEN ([GMT Product Overview by Asset Class].[Product Overview Facts by Asset Class].[Year] = 2006) WHEN...

Hi all Using Cognos 8.3 report studio. Sorry if this is an obvious one, but I've been racking my brains on it for a while. I have a search and select prompt which is used to select parameter value(s) to be referenced in a query filter. My filter expression is therefore: dataitem in...

Hi all I need an efficient method of obtaining the value of cross section of a table (manual and ad hoc table generated using sql query) in a query. I would like to avoid using "Case When" of "If" constucts as the table is very large. I have investigated using "tuple" but understand this is...

Hello again all...another issue I know! I have a cross tab that contains 5 measures (all calculated), grouped by one member in the column and 4 members in the rows. For each row member there nested total line, which performs a sum of the crosstab fact cells. The trouble is that for one...

Hi all I have a very strange issue with a crosstab report I have created. When I run the report I get the following error message: "QE-DEF-0359 The query contains a reference to at least one object '[Revenues YTD0]' that does not exist." BUT...this reference is not in the report at all!!! I...

I am trying to create artificial groups in a query, based only on one member, in order to be used as a total in a footer. I have tried the following to create the artificial group: case when [costitem] in ('x') then 'group1' when [costitem] in ('x','y') then 'group2' when [costitem] in...

I have created a boolean variable (if prompt = x, for example)...and when true I want to select a member on the report to sort by. I set the format by selecting yes on the value window, then selecting the report member and clicking the sort button, then double clicking the green section to...

Hi all I am using the following case when statement in a calculation for a dynamic average, but am not getting the expected results. I'm convinced there's something wrong with my logic and expression syntax, but for the life of me can't see it!! Any ideas anyone? Case when...

Hi guys I'm fairly new to Report Studio 8.3, so would appreciate any advice offered on the following questions based upon the below report spec...I have looked through previous threads and found nothing of use :( I have created a fairly simple list report, which uses filters based upon 5...

Hi there, I'd be very grateful if anyone can advise on the following issue? I have created a form template in Word XP, which contains a table with simple formulas referencing other cells in the table. I have added fields to control user input, and have protected to document to restrict editing...

I have created a replica of a database, keeping the master in my personal drive and the replica on a shared drive. I have been synchronising periodically without problems, however it has just failed, giving the error message: "File sharing lock count exceeded. Increase MaxLocksPerFile...

I'm hoping someone can offer me some advice on pivot tables... I am trying to create a Excel pivot table from an csv file, which is a report output from an Oracle database. (I originally wanted to link directly with the db, but could not obtain the correct permissions, so am left with no...

Hi there folks I hope you guys can help me with a database I created which now seems to be corrupted. When I try to open the database I get the message "'ID' is not an index in this table", and it wont let me open the database. In the past I have simply compacted the database and everything...

Hi there, I have a question regarding the performance of a database I am designing. It will be roughly 40-80 Mb in size, have approx 40 users at any time over a WAN, stored on shared network drive, mostly running macros and queries (code limited to database navigation.) From previous...

Hi there, I am building a database and have a query about refreshing data in a form. The form is based on a table (say TBLX), and has only one control which is a field from the source table (say DATAX). The data in this field is the same for all records in TBLX, so I decided to base the form...

Hi there, I am building a database and have a query about refreshing data in a form. The form is based on a table (say TBLX), and has only one control which is a field from the source table (say DATAX). The data in this field is the same for all records in TBLX, so I decided to base the form...