Search results for query: *

Hi, New to Cognos, we are using ver 7.3. I keep getting TR0787 The locking of cube failed, It is probably in use by another application. I searched for .lck and .pyi files but didn't find any. I cleared the temp files and rebooted my server. Any other ideas would be greatly appreciated. Thanks...

Hi SQL Server ver 8.0 I am upgrading our front end and the upgrade requires us to delete the views from the backned DB. I have my DB and a copy of my DB. Is there a way to copy the views from the copy DB back to the original after the upgrade? Thanks in adavnce

Hi, Cr 8.5 ODBC to AS400. My report lists Po#, quantity, $$ total and cancel date. I am grouping by cancel date and have summaries for $$ and quantities based on cancel date. The format of the cancel date is YYYYMMDD which sorts correctly. I changed the group header to show this date as...

I installed Win 2000 and Office 2000 to PC. Copied over my access DB. Everything works except Date. It is blank on forms and in tables. This only occurs on a new install. If I copy to another PC it displays current date and all is fine. What am I missing? Thanks in advance

Hi, CR 8.5 Pro, reporting off a SQL Server. My selection formula : If {?Infants} = "Yes" then {Classifiers.Name} = {?Division}and Isnull({StyleSummaryStoreSpecial.StoreSpecial}) or {Classifiers.Name} = {?Division} and ({StyleSummaryStoreSpecial.StoreSpecial} <>"Retail"). StyleSummaryStoreSpecial...

Hi, CR 8.5, CE 8.0, IE 6.0, Active X viewer. I have a web page with links to reports. User clicks on a report, selects parameters and report is viewed w/ Active X. Thru Active X (not CR though) my reports have some fields that overlay other fields on my report. Has anyone else experienced...

Hi, I am sorting my query based on field Week. Week: Format$([Query2.Photo ETA1],"ww",0,0) where Query 2.Photo ETA1 is a date. I need to add a zero before the weeks 2 thru 9, so it sorts correctly. Currently it is sorting week 1, then week 10 thru week 53, then week 2 thru 9. It must be...

Hi CR 8.5 ODBC to AS400 I have a Trial Balance Report which calculates debits and credits for each GLminor, GLmajor, GL account. I calc debits with {@ytd} If {?Period} = 1 and {MSTGL.GYEAR} = {?year} then Abs ({MSTGL.GD01}) - Abs ({MSTGL.GC01}) else If {?Period} = 2 and {MSTGL.GYEAR} =...

Hello, I have a query pulling in fields from As400 database thru ODBC which is correct. I link an access table to above query and dates are also correct. I add a field: PhotoETA1:IIf((IsNull([WHP0110 Summary]![Max Of KRHDPS])),[TGT ETA (S/S)],[WHP0110 Summary]![Max Of KRHDPS]) and my field...

Hi, I inherited Access this week. I have a report with subtotals after each group. How can I combine 3 groups into one. My query has: Item field, Afield, BField, CField, DField. Item is in AGroup if Afield=yes, Item is in BGroup if Bfield=yes. On my report I have Grouping levels A,B, C,D... I...

Hi, I am automating our full backup. I have come up with a few ideas such as calling a CL (which would ENDSBS and then submit backup jobs then PWRDWNSYS) on the command line then leaving for the day. Another idea was to add a backupjob to the QStartup then scheduling an IPL. Any ideas out...

Hi, Using CR8.5, reporting off SQL 7.0. I have a field ISActive which is boolean (-1 or 0). I want to create a parameter in which the user will be able to select Active, Not Active or Both and then select records based on their selection. Thanks in advance!!!

Hi, I have reports created in CR 8.5 Pro connecting thru ODBC to AS400 which use a file DSN. In order to view thru Enterprise, these reports need to be using the System DSN. Does anyone know how to change reports so they use the System DSN? Thanks in advance

I have CR 8.5 Pro and distribute thru CE 8.0 standard which came free. Has anyone upgraded to CR 9.0 and still used CE 8.0 for distribution. We are a small company so the 5 seat restriction won't bother us.

Hi, We are installing CE 8.0 (that came free with CR 8.5Pro)on our Webserver on the network. Question 1. Do I just install CE 8.0 or do I also need to install CR 8.5 Pro on webserver? Question 2. Can I put an icon on our webserver for CE 8.0 for users to access ePortfolio, or do I need to...

Is it possible to launch a CR 8.5 report(SQL 7.0,via ODBC) using VB, so a user without CR can run it?

Hi, CR 8.5, SQL 7.0 I need to parse a string of fields seperated by commas example (Hong Kong,Russia,USA...) the fields would be Country1=Hong Kong Country2=Russia Country3=USA Etc… Thanks in advance

Hi, I was interested in CrystalDesk to schedule and export my CR ver 8.5 standard reports. I use XP and when I export to Outlook, I get the message &quot;A program is trying to access email addresses...etc which I have to click OK. Then another message &quot;A program is emailing on your...

Hi, I am using CR 8.5 Pro, ODBC to an As400 database. Field {Amount} is in the Detail section suppressed. Each order has more than 1 item. I have two groupings one by item and then one by division. The report lists total amount of all item#'s and groups them by division. All number formats are...

Hi I added a text object on the Report Footer to each field which contains a percentage. How do I suppress the % sign when the field is empty? The % is not part of the formula. Thanks for your help!!