Search results for query: *

Hi Geoff Am new to Reporting Service so not exactly sure how to do as you said - could you expand a bit further cheers

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 tried that but the problem is calander control inverts the date before it passes it to the SQL code so converting it to a varchar doessn't make any difference - I've found another link which explains the problem more clearly...

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...

thanks IBass works a treat

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...

Simple but effective - Works a treat Vongrunt I agree with John - a star you are thanks a million

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...

Thanks K Unfortunatly cross-tab is not an option - and the sp does access a single table with the required data - I was just trying to make the report more efficent by getting it to run the sp once only thanks all for your input

Hi again The report design I use is necessary as I have to group and summarise and present the same data in many different ways to the main report. This report is a 1 page executive summary which requires information presented may different ways.The SP returns all the data required by the main...

Is your sub-report positioned before the detail lines you wish to suppress?

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...

I am having the same problem aswell - nay more infor would be great - Basically the report seems to ignore parameters passed to it from the VB code

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 MDXer That works perfectly - Thanks for your help