Search results for query: *

Does anybody know if you can use the same textbox to jump to multiple reports i.e. It lets you choose which report you wich to go to

I've created a report which has a start end date passed to the SQL script - When I run the repot and I select something like 2 Jul 2006 it gets formatted to mm/dd/yy even so 07/02/2006 gets passed to the SQL which thinks I'm entering a date of 07 Feb 2006 instead of 02 Jul 2006 - Is ther...

hi I have created a crosstab report and wish to trepeat the row labels so there is a value in every filed in every row when I export it to Excel E.g I want C1 C2 Total Row A RowB 1 3 4 RowB 3 4 7 Total 4 7 11 To export...

Hi Is it possible to edit the SQL query in 10 like you can in 8.5. I'm using the database expert to join 2 tables and want to join on 2 fields from the same table i.e. Join tableA to TableB Where TableA.Field1 = TAbleB.Field1 or TableA.Field1 = TAbleB.Field2 In CR 8.5 I can simply...

Hi Is there a way to put the results of a stored procedure into an xls file and mail the file to the appropriate people via e-mail. I've been trying to do this using DTS packages but can't seem to get it to work. I can execute the SP and then send an email notification saying it has completed...

Hi I wish to select the top N percent from a table (into a temp table called #Results) where N is a variable passed to the Stored Proc. Using the code as follows works fine Select Top 5 Percent into #Results from MyTable but if try Declare @N as Int Select @N = 5 Select Top @N Percent...

Hi I need to compare one string with another and if ANY part of the first string is in any part of the other string then I get a match. E.g Comparing "Elephant Ears" to "Grey Elephant" = true match OR Comparing "Grey Elephant" to "Earl Grey Tea" = true match OR Comparing "Earl Grey Tea" to...

Hi I am using CR-8.5 & CR-10 I have a report with numerous subreports. The main and subreports access the same Stored Proc on a MS SQL 2000 DB. The subreports are linked to the main report using the SP parameters. When I run the report it executes the SP for the main report and then for each...

Hi I have version 8.5 and 10 of CR. I was wondering if it's possible to get crystal to leave gaps in a line chart if there is no data for a period. Eg I have data plotted over a 12 month period - if there is no data for, say, March - can I get crystal to leave a gap in the line between Feb...

Hi I'm using Crystal Reports 10 and need to dynamically format the bars in a chart. I have created a 'team' group in the report and have place a chart in the group header. I need to change the colour of the chart depending on team name. So If the first instance of the group is 'Red Team' I...

Hi I'm using Crystal Reports 10 and need to dynamically format the bars in a chart. I have created a 'team' group in the report and have place a chart in the group header. I need to change the colour of the chart depending on team name. So If the first instance of the group is 'Red Team' I wnat...

Hi I need to compare two datetime fields but wish to drop the datetime component of the datatype - is this possible E.g I want 2004-03-24 16:14:23.400 to = 2004-03-24 6:14:23.67

HI I am using the Crystal report Crystl32.ocx and am trying to pass parameters to my report using the StoredProcParam(N) method The problem is my report ignores the parameters I pass to it and instead displays the saved data in the report. Unchecking the 'save data with report' option in the...

I use the following code to open the report testreport.rpt and connect to the DB using the odbc connection CAL042 Clareports THe RetrieveStoredProcParams methid returns a memory overflow error and when I exclude this and run the report using the PrintReport method the report ignores my...

I'm writing a small VB program which will run my reports and export them to a disk destination (without user prompting). The problem is I want to export the reports in pdf format. I've tried using PrintFileType to set the file type to pdf but it's not supported Any Ideas how to get around this...

I'm writing a samll VB program which will run my reports and export them to a disk destination (without user prompting). The problem is I want to export the reports in pdf format. I've tried using PrintFileType to set the file type to pdf but it's not supported Any Ideas how to get around this...

I'm new at Vb coding and want to set up a connection from my VB 6.0 project to a MS SQL Server 2000 Db any ideas

Hi I have created a report which contains a pie chart. When I viewing and print the report thru Crystal developer all is fine but when I export the report to Adobe the chart views and prints out chunky/blocky - THe labels, values are so chunky that the cannot be read and even the pie slice...

I have created a report which calls a Stored Proc from MS SQL Server 7.5 When I save, close, reopen and run the report it gives me a 'invalid descriptor index' error. I verify the report and it says the DB is up to date. When I refresh again it works fine but if I save, close, reopen and run...

Hi I have scheduled reports to run at various times using Crystal Management Console. I need to automatically e-mail these reports in PDF or Excel Format or export to a specific destination after they have completed. Can I do this or do I have to open each instance of the report and manually...