Search results for query: *

Hi, I have a crosstab woth 2 measures. i need total summary for one and a percent for another. i got the total but still need to get the percent of total. Please see the crosstab eg: eg: week1 | week2 total(week) percent(week) |date1 | date2...

Hi, I am doing an analysis to see what reports are built on some old packages, so that if thay are no longer in use we can remove those packages. So instead of opening every report to see what package it is assiciated with, is there any way that i can see all reports that are built on that...

Hi, Thank you for the response. I think i got what you are saying. But i cann't create a table or have access to create it and moreover it's too complex because there are 1mn accts. Can you think of any that can help my situation...with only available data/table? Thank you so much...

Hi All, If you guys are familier with Randomized allocation in SQL, i need the same logic to be implemented in Cognos. For Eg: sample randomized allocation WHEN (acctnmbr like'11%' and DPD=0)THEN 1 WHEN (acctnmbr like'11%' and DPD between 1 and 10)THEN 2 WHEN (acctnmbr like'11%' and DPD...

Thanks drlex. That's exactly what i need and it solved my problem. thanks again.

Hi, If i have something like group by state and have details... State Detail AK 1 2 3 AL 2 5 6 I should get AK 1 AK 2 AK 3 AL 2 AL 5 AL 6 even though it's grouped by state for filtering purpose in Excel. How can i do that in report studio? Not excel. Thank You.

Thanks blom0344. It worked. But i don't know why it did't take the names before? Thank you.

Hi, I want to change data item names that are displayed in the output in reportstudio. So i did change them in properties of each data item. But when i ran the report they are not effected. The names are still the original ones in the congnos viewer. any help? Thank you.

How do i do that? like how the filter be?

Thank You... How many records for example will it give me if i select limited data? i only want 20. So is there a way to specify to give me 20 records?

Hi All, I have a huge selection of records for a report. But i only want a sample of records. Let's say 10 or 20..that shouldn't repeat for next report run.How can i do that in report studio? Thank You for help.