Search results for query: *

Morning all, Here's the setup: Actuate 10 SQL datasource, using stored procs Reports have cascading parameters and "stand alone" parameters We have noticed that when you first open the report, the parameter procs are called once but when you open up the parameters window after a report has...

Hi, Hope someone can help me out here. I have been tasked with distributing some reports using reporting services. I have never used RS before. This was installed before my time so I cannot comment on many aspects of that. When I try to access http://localhost/reports, IE just sits there, no...

Hello Using SQL Server 2K. I have a DTS package that uses a SQL task to build a result set in a global variable. This rowset is then output into a text file using an ActiveX task. while not objResults.EOF strRecord = ObjResults.GetString(2, -1, "~", "", "") objStream.WriteLine(strRecord)...

Morning all, CE9 + CR9 (Still [sad]) We have a report that is in a character separated value format which a client (outside of our organisation so scheduling to an unmanaged disk is not possible) want to be able to save locally somewhere after viewing. When the report is viewed the internet...

Hi, This is probably more of a Windows question, but I think I would get a better answer here. We have 10 reports running from our test environment (SQL Server 2k) that should be triggered by an event file that the SQL sever creates, this is how it works on our live system (where there are...

Dear Tipsters, I am using Access2k as a front-end to a SQL2k database that is used by 25+ users. The way it was originally designed was that each users PC held a local copy of an mde file. When they log onto their machine, part of the login script would check the modify date of the mde file...

Dear all, MS Access 2k, SQL2k I have an access database that needs to pass values from an access table into a SQL2k table. The data is inserted into the SQL table using an ADO connection that fires a SQL SP with the data items passed as parameters. My last couple of fields are set as...

Hello all, i'm new to this forum so be gentle! I have recently inherited an old PC (PIII 500MHz with an MSI 6166 motherboard) that came without a hard drive. I am trying to add a brand new 40gb drive to it so that I can install an OS and use this has some kind of file server for music/pictures...

CR+CE9, SQLS2k. Dear Tipsters, I have come across something which I didn't think should happen. I have a report that is to display call centre statistics, it contains 2 groups, Supervisor & Agent. The idea is that the user opens up the report and is presented with a list of Supervisors...

I saw this in a pub in Bristol some years ago - the barman offered us a free round of drinks if we could get it before he pulled 3 pints of Guinness. We didn't...so start pouring and have a go! What is the last line? 1 11 21 ? Thanks mrees

Using SQL2K,CE&CA9.. I have created a OLAP cube using SQL Analysis Service, and then created a cube in Crystal Analysis. I can view the cube fine in CE (I am an administrator), but when a member of Joe Public tries, they get a message stating that the Cube no longer exists and gives them the...

Using CE9 and CR9. Hello all, I have a problem in that recently, report developers are having problems running some reports, in fact, so am I and I have Full Control in CE. Report Developers exist in an NT Authenticated group that gives them the right to Schedule Documents To Run, each folder...

Microsoft Access 2k and SQL2k. Dear all, I have to make some amendments to an Access front-end, created by a now departed colleague. Basically it is a series of forms that allows users within my company to enter information into a "temporary" holding table in Access. This information is then...

Dear all Using CE9.. Can anyone tell me the best way to reinstall the NT Authentication plugin, i'm told to install it I just double click the secWindowsNT.msi file found in \Crystal Decisions\Enterprise 9\Packages\win32_x86 . Is their anything I need to do beforehand? I assume that I need...

Hello all (again) CE9 & CR9 Following on from my CE troubles...we tried re-importing all the NT Group that manages authorization in order to try and solve our problem of users losing access (it didn't work) I have since discovered that one of our report developers was keeping reports in...

Dear Tipsters, We are using CE9. For our internal use we use WindowsNT Authentication with users in a specific NT Group to be given access. Until recently this works a treat. I have found that 3 (so far) users out of around 50 regular users cannot gain access, when they try they get the...

Hello all, CR+CE9,SQL2K I have a cross tab that is to display number and percentage of loan applications over a 16 week period, the columns are bands which represent the number of days between date of application and date of loan approval. The rows are the weeks in which the loans were applied...

Hello all Crystal Reports/Enterprise 9 SQL 2k. I have a Crystal report that runs each day, reporting the previous days posistion (subject matter is not important). We keep the last 40 historical instances for the users to view at will. What I want to do is add several on demand subreports...

Hello, I have just taken over the reins of our CE9 admin role (The previous administrator left without leaving complete instructions), and whilst I am ok with managing accounts and rights etc..I have no idea about the install. We have a new machine in our department, and on that I want the...

Hello all, We are using CR & CE 9.0. We have some reports that are created as Excel files and emailed to the client when an event file is created. Is there anyway that we can also password protect these Excel books, as currently we have to manually add this and send if the client requests it...