Search results for query: *

Hi, Thanks for your response. Yes, we use McAfee, I think I will exclude .mdl, .pyi and qyi from the list. I deleted the .mdc and rebuilt the cube and it was fine. Thnaks again,

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

In case someone else need the info. Report->Change Group Expert->Options-> Customize Group Name Field->Use formula as group name

Sorry to be more clear. I need to format the date in the group tree.

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

PHV, Thanks for the reply. In references, MISSING:Microsoft Rich Textbox Control 6.0 and MISSING: Microsoft Common Dialog Control 6.0. I don't have the option to add components in Access as I do in VB. Could I copy these .ocx files from another system to this one?

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

I installed VB.Net ($99) version about 6months ago and don't see crystal at all. I use VB.NET along with the free SQL reporting Services to create reports.- FYI

In case anyone else has this issue, I changed my link to include cmd=export&export_fmt=u2fpdf:0. This exports it to a PDF and all fields are fine. This is workable until I find a solution.

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

I am researching SSRS (We currently use CR and CE) A couple of questions: 1. Can I use VB.NET to create and distribute reports or do I need VS.NET? Obviously VB.Net is cheaper. 2. Can we use the ODBC to connect to another data souce such as an AS400? Thanks for any replys C

Yes, I use CR8.5 Pro. I had some errors installing it, which I ignored. I haven't had any problems viewing, scheduling or printing. However, I only have 4 reports that I export to PDF and email everyday. When I tried to schedule 30 reports to report off an Access db, to run every 3 minutes...

Yes, I have been using Crystal Passage on a Windows XP machine. I connect to an As400 db thru ODBC and email reports as PDF daily.

Thank You, Both posts were very helpful!!

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

Hi, CR 8.5 ODBC connection to AS400 I created a Trial Balance report Debits and Credits as columns. Debit is a calculation for each GLminor, GLmajor ,GLaccount : If {?Period} = 1 and {MSTGL.GYEAR} = {?year} then Abs ({MSTGL.GD01}) - Abs ({MSTGL.GC01}) else If {?Period} = 2 and...

dhookom, I pulled the info into an Access table and used the same SQL, all the fields are correct. Thank You. I am not sure how to update this table to get current info from the AS400. Any ideas? Thanks, again