Search results for query: *

I'm actually using OLAP grids in CR 9.0 and am experiencing a problem. Does anyone know of a way to access report information from inside a Calculated Member. What I really would like to do is access report parameter information. Say if someone passed in a value of 35 for one of the parameters I...

Can someone help me with this. I need to find the count of all Time dimension members from the beginning up through the current member. My cube starts from Jan 1996 so if my cuurent member is Nov 2002 I would want to return 83 for a count; if current month was Apr 2000 I would want 52, etc.

I need to search through the a report and find the number of times a keyword is present. I am using VB 6. Does anyone know of a way to do this using the RDC? Thanks in advance. Scott

I'm hoping someone can help me with this. I have a measure called 'Unit count' which I want summed up along my Property dimension (i.e. The unit count for 'Prop A', 'Prop B', etc would get rolled up to the Region level with a 'Sum' function. But how do I exclude the Time dimension since Unit...

I need help with the following scenario: I have a table that contains several columns (say 'fld1', 'fld2', 'fld3', 'fld4', 'fld5'). I also have another table which contains 2 columns (one being 'colname' and the other is 'colorder'). The data contained in this last table is as follows: colname...

OK..I'm sure this is an easy one for an experienced Crystal Reports/VBScript developer. I am not using ASP but I do have a need to call the CRViewer (to view a report) from VBScript. Can anyone tell me how to declare and call the CRViewer and a report from VBScript without using ASP. Thanks. Scott

I am having some difficulty with reports that I converted from an Access database to SQL Server using Crystal Reports 8.5. There are some field names in some of the tables that contain spaces. When I converted the report to SQL Server in the Report Designer it asked me to map these fields with...

I believe you can achieve dynamic pick-lists through Crystal Server Pages (CSP) through Crystal Enterpise. I saw a Knowledge Base article on it but did not try it as it did not suit my needs. Here is the link: http://support.crystaldecisions.com/library/kbase/articles/c2009631.asp

Yes it is possible to do for I have done it. Through VB you can save the report and the new PickList values. Here is a sample code snippet: Do While f.atendofstream <> True ParamLine = f.readline Call ParseDelimitedString(ParamLine, TokenList, vbTab) For j = 1 To...

Does anyone know how to tell if an instance of a report is already currently opened? I am using RDC and Visual Basic to modify a report and save it (via the 'SaveAs' method). If the Report Designer is open with this report loaded a call to this method displays an OK dialog box saying that the...

I don't want to change the name of the parameter field itself. I want to add a description to one of the values in the picklist. As I said I can add, delete, or modify the actual value in the picklist but not its accompanying description.

Does anyone know how to set a Crystal parameter description through VB. I am using the RDC and can easily set a parameter's value (via the &quot;AddDefaultValue&quot; method) but I see nothing about setting a description. I do see a &quot;NthValueDescription&quot; method which accepts an index...

Not yet. I know you can modify the contents of the picklists via API calls (from a VB app for example). But you have to save the report with its modified contents. I have many such reports that I need to use this functionality for. This seems to me a MAJOR limitation of Crystal. Not everyone...

Does anyone know of a way to get dynamic picklists for parameters functioning from a Compiled Report. I am limited to running the report (compiled) from the desktop - not from a Web Server. I would like to run a SQL script (from a file) which would populate the picklists based on some criteria...