Search results for query: *

We have a requirement to output an XML document according to a predefined stylesheet (xslt). Basically we will have a hyperlink in a Report Studio report column that we want to be able to click on, the link would point to an xml document and related xslt stored on the file system and output...

Hi all, Got a little issue with a calcuated measure I'm doing in Transformer. This calculation is only applicable at the year level as one of the measures used in it is rolled up (averaged) to the year level. I go down to the month level in my cube. I obviously then only want this measure to...

Good afternoon, Any 'upgrading' required to go from version 10 crystal reports to version 11?? Is it just a simple save in the new version ?? thx, Steve

Hey Folks, Need a bit of help - Crystal 10, Peregrine DB Trying to create a 'top 10' report. I've got report groupings, summarized with a running total and I now need to sort the report based off these totals (descending order). I've suppressed details, just showing footers with the running...

Anyone ever done any OLAP (ie. data modeling) for SC applications?? We're considering using some of our Cognos tools to do some multidimensional anaylsis with on SC data. In very early stages and just brainstorming how best to dimensionalize the data. If anyone's ever done this type of thing...

Hi all ... Just curious if there is a Crystal runtime viewer that I can deploy to clients who dont want the full Crystal application? They just need to run, input parameters, etc. thx, Steve

Just want to pick the collective brain here :) Within our org here, we're running Service Center and reporting against it using Crystal. Been hitting the wall recently (I'm the reporting guy) as reporting reqs are getting far more complex, P4 being non-relational and subreports only getting me...

Hi.. I'm very NEW to SAP. Just curious whehter its possible to have a header in a SAP query output, show the date parameter value. IE. user selects date prompt, runs query, and the date prompt value then shows up in the header of the query's output. Would this need to be programmed (ABAP)...

Can this be done, or are you restricted to the same sort across all report groupings?? ie. Goup1 - sort Last name, Group2 - sort First Name, etc. thx a lot! Steve (using Crystal 10)

Hi all ... looking for a lil advice. Have a bunch of Crystal reports I need to run every Monday and save out as pdf's to a folder on our network. Would like to automate this via a batch file, or VB, or something .... I was hoping to do this via a batch file, but i'm not sure how to gain...

Hi, I've developed several reports for a group of about 50 clients. We are using a Peregrine product, ServiceCenter, and I'm hitting its proprietary db with Crystal reports. I now need to figure out how to deploy these reports, via the web preferably. I'm hoping to avoid throwing together a VB...

Hi all, Does anyone know whether Crystal has anything like a "Content Overview" feature, that would provide a quick way to see all the fields, groupings, sorts, etc. in a report you can save out. I've been asked by management to prepare a document outlining everything contained in several...

Any ideas on how I can get groups within my report exported out to PDF individually. Client is keen on, when printing report, have each group saved out to its own individual pdf file so that each file can then be sent to its respective department (the grouping in the report corresponds to...

Hi, I have set a lable in my title = to a parameter as selected by user. I need this label (txt box) to size horizontally depending on the length of the parameter selected by user. I can do this using the "tight horizontal" property of a txt box, however the following txt box remains in its...

Hey folks, Any ideas on how I might get started on passing files via my FTP editor (WS-FTP Pro) from CognosScipt. I have a few weekly files I need to send to a client that are generated through CognosScipt - it would be nice to fire them out to their server without my having to launch my FTP...

Hi, I'm stumped. We have a report that has been running fine for a couple of years and seems to have suddenly gone off the deep end. It no longer returns any data - though the hotfiles its using as a source have lots. Nothing has changed with this report, nor any of the underlying hotfiles it...

Hi, Any ideas on how i can launch my vba macro from cognosscript?? It needs to be seamless. Basically the user selects options via a cognos macro, cognos macro runs and exports report contents to excel. I have a vba macro that does some additional formatting work that i need to have kick off...

Hi, I'm new to this - can someone quickly show me how i might create a column via code that will add/subtract/multiply/divide other columns on the worksheet. Eg. Column K = ColA + ColB + ColC. I only want the results of the calculation to show in Column K if there is data in the rows of ABC...

Hi, I have a report with a bunch of time categories as layers (eg. March 2003, April 2003). Within each layer their is an Opening Balance, Sales, Debits, and Closing Balances. I'd like to be able to take a subset of these layers (a fiscal quarter for eg.) and create a summmary layer for these...

Hi, Curious as to how i might take a range of periods (eg. April 2003 to June 2003) as input by the user, and, using Cognosscript, add up each column in each period to produce an output summary report. The periods exist as dimensions. Can i temporarily store each period, as a separate report in...