Search results for query: *

ah yes thanks, got it now. thanks for the help

thanks lbass, that worked. now is there a way to get that to then display in correct date order,as it is sorting in text order currently?

no i dont. the main report contains a whole set o fformula fields which basically calculate totals by week(mon-fri) from one table. i.e. week1 week2 week3 week4 week5 etc tickets opened tickets closed I then am using the subreport to get totals from another table of tickets...

crystal 8.5 has a default week start day of sunday. I have found code to alter this within a reports group structure. However for the report i am writing i cannot group by date. I have a main report which links to a sub-report. i have a crosstab in the sub-report which has a date field in the...

Hi, I have a number of reports that have subreports which form part of tabular information (summary totals) . The subreport data appears fine in the preview. But when exported to excel an indent of two columns is put in on the row containing the subreport. Is there anyway to stop this indent...

thanks option one worked a treat

Is there anyway to concatenate multiple values on a field in the detail section of a report into one field either at the group section level. example need to turn group level 1 fielda fieldb fieldc fielde fieldf fieldg fieldh detail section fieldd1...

Can anyone help me with the code to run an MSAccess report from excel?

I need to run an access report from within an excel workbook. I have set up a button. Done similar things before, just cant remember the coding syntaxfor launching one office application from another.

I am producing a report for a batch of invoices. I need to be able to have a count of pages for each invoice and for the page count to reset at the start of each invoice. I have tried putting the page count expression inside a section insead of in the page footer, but this didnt seem to work...

Has anyone tried this and got it to work consistantly?

No never got an answer. As i remember in the end came down to crystal reports storing data connection info within the report itself refreshing the odbc link worked occasionally. other than that problem sometimes caused by unscheduled server crashes, try rebooting the web server the project is...

I need to run a excel spreadsheet macro from access. I have managed to open the spreadsheet and start the macro. However the macro launchs an input form, which Ineed to send values to and then activate the run button. Any ideas on how to do this? I have coded the opening of the spreadsheet and...

Are there any particular issues tolook out for when tryingto code ASP pages that will display the same in IE and Netscape? Especially when using DIVs, FRAMES and TABLESwithin same form.

some more detail, calling report through asp page with vbscript. code as follows strTargetPath = Application("ReportTargetPath") & Session("strUserId") & "\" Set objFileSystem = CreateObject("Scripting.FileSystemObject") strSourceFile =...

Running CRPEApplicaton from within asp page , getting error as above, error traced to call objReport.Export(false) line in script. Any ideas how to stop this error?