Search results for query: *

Hello all my report contains a sub report that uses a stored procedure. For the stored procedure to run it requires two parameters. How can I set it up so that my main report is passing values to these parameters automatically and the subreport isn't promting for values of these parameters on...

ello how can I pass a date time into a report prompt? I've already tried: prompt0=01/01/2004 00:00:00 and prompt0=DATETIME(2004,01,01,00,00,00) with no success. Any help would be greatly appreciated

Hi all how can I get the value of a variable in a subreport from my main report? Hopefully this'll be an easy question to answer! If it isn't possible is there any other way I can pass a value back to my main report from a subreport? Thanks peeps!

Hi all is there a way I can return two sets of data from the same view within one report? I need to pass in a sf where clause to a report and make a calculation based on one set of data only filtering on the date range passed in by the sf whilst displaying data filtered on the entire sf where...

ello is there a way I can find the number of records returned in a report for use in a formula? I tried using the special field Record Number but I don't seem to be able to use the value of this field in a formula, all I can find is RecordNumber which returns the number of the current record...

hiya if I run my report without any form of select it returns 2,565 records. if I take the same report and use the select expert to return records where op_id = "PPM" it returns 30 records. if I then take the same report again, but change the select so that the report returns...

ello all is there an equivilent to fieldname in (1, 2, 3) (i.e. shorthand version of fieldname=1 or fieldname=2 or fieldname=3) that can be used in an sf querystring I'm passing to a report? And is there any resource that tells me what can and can't be accepted in a passed sf? I've already...

hiya all if I set up a report to use a database other than our usual one (CorpDB) when I try to view the report through a browser it asks me for a username and password to log onto the database. I've checked the data connections on my computer and both CorpDB and the other DB are set up...

ello all is it possible for a report to access a view on a different server? if so, how is it done? Thanks

ello all whenever one of our clients trys to print a report viewed in a browser the printer defaults to a printer other than the default one that every other application on her computer defaults to. Can anyone think why this might be? Thanks

ello all the page server service on our NT server has a tendancy to crash causing an error on viewing a report: There are no Page Servers connected to the Cache Server or all the connected Page Servers are disabled I'm using Crystal 8.5, does anyone know why this happens, and if it can be...

Ello all I'm having trouble selecting distinct records. The problem is that two records that are distinct by some fields are not actually distinct by the fields I'm displaying in my details section. Here's a better explanaition: say my database had fields 'Name' and 'Number' and had two...

ello all thanks for reading my thread. Can anyone tell me what format DateTime fields can be passed into a report in the where clause? I've got a few reports that pass in dates like this: {SDK_VW_WorkOrdersReporting.DateTimeCreated} >= Date(2003,02,13) but none that handle DateTimes Thanks

This one has completely stumped me: I need to have two details sections in my report. The report sections need to be layed out like this: Report Header group 1 header (grouped by field x) details a group 1 footer group 2 header (grouped by field y) details b group 2 footer that is I...

ello all when I print a certain report I get a message saying: 'The report you are about to print is a pre-formatted image of the actual report data. Changing orientation or paper size may result in loss of objects on each printed page. Do you wish to continue?'. If I choose to print its prints...

ello all I can't seem to find any option in Crystal (8.5) to remove the labels from my pie chart. Not the legend, but the actual segment labels. The problem is there are loads of segments and the labels are just a blur as they appear on top of each other. Anyone got any idea how I can get rid...

ello all, thanks for reading my thread You know when you are setting up a group in a report and you specify what order the records should be displayed (original, ascending, descending or specified)? Well I need to display my records in their original order, but reversed. How might I do this...

Hi all bear with me here because I'm not completely sure of the correct termanology... I need to create a report that can take data from a dynamic view. Effectivly I need to be able to pass my report a SQL statement that creates the view on the fly. Is there any way I can do this with Crystal...

Hi I'm concatenating two fields with a line break in a short formula field. Both fields are strings, and my formula field looks like this: {INV_PrintInvoice.Description} + chr(10) + {INV_PrintInvoice.DetailTitlw}; The problem is that when i put my formula field on the report it displays...

I've got some duplicate records in my db and need to filter them out of my report. I've tried putting SELECT DISTINCT into my SELECT statement but crystal doesn't seem to like this because it always reverts back to SELECT. How can I filter out duplicate records?? Thanks in advance