Search results for query: *

Hello, I'm struggling to find or write a SQL or .net function or SSRS expression to calculate working days between a CreatedDate and ClosedDate, the function must include bank holiday dates. I'm working from a database where creating SQL functions are not permitted, however I can embed the SQL...

Hello, I have searched the forum and the internet but have not found a simple solution to splitting a column with data type TEXT where there is a carriage return. I'd like to use charindex, substring, len but don't know how to combine them to look for data in between the carriage returns (CR)...

Hello, I have a dataset which I plan to use in a matrix, but only want to be able to show two values in the parameter from a field that has lots more values, but still return all rows associated with the unique ticket number. Has anyone any ideas how this can be achieved? Thanks, Javedi

Hello I've searched the web but found no joy. I have a chart and would like to add an additional data label to show percentage. I can only switch between a count and a percentage on the same data label, so does any one know of a way i can add another data label, or have both a count and...

Hello In SSRS 2008, I have two different tables and would like a parameter to switch between them. Does anyone know how to do this? Thanks, Javedi

Hello I have the sample data below that I am trying to flatten from a view on SQL Server 2008. I was hoping there is an easy way to do this but I can't find any after Googling. The problem is with rows 4,5 and 6 which need to be in one column under Non-Reusable Item Details. Any idea's on how...

Hello I have four datasets (in a matrix grid) in a report and becuase they all return different data based on the parameter values broken down by month (columns), they are not aligned properly and do not look nice. I was wondering if there is a way i can keep the columns consitent, to show the...

Hello I have used the expression below to calculate a percentage but when there is nothing to calculate a NaN is returned. Is there a way I can get over this? =1-(Sum(Fields!MoreThan1Day.Value))/Count(Fields!TN.Value) Thanks, Javedi

Hi Can someone help me with a report i'm working on to return the most recent record in a group based on a resolved date. I have tried the maximun(date) but it throws errors. Any help would be appreciated. Ta, Javedi

Hello Does anybody know of a way I can display the SQL in the dataset used for the report as tooltip from a textbox? I can manually enter this but would have to do this everytime i make a change. Any idea's welcomed. Thanks Javedi

Hello I'm new to SSRS and SQL and am having trouble in a report to show the groups with null values when date parameters are introduced. The report shows the null values as 0.00 as required without the date parameters. Below is the dataset used. DataSet1 SELECT WDF_MATERIAL, COALESCE...

Hi I'm attempting to create a line graph for total number of calls as Y axis and months as X axis, the lines should represent the years. So each (Year) line should show the number of calls received each month. I've been able to show months but it also shows for all years and is also on the...

Hi I have one table with three fields required from it. agent (number) - Identifier of the agent whose state has changed. eventdatetime (datetime) - Date and time that the agent state changed. eventtype (number) - Eventtype shows events that triggered the agent state change: 1—Log In 2—Not...

Hello Can someone help me re-write the sql statement into an ssrs expression. I'm converting this from 2005 to 2008 where someone has used sql to display fiscal quater period. The new field name is DecisionDate and expression will be called Quarter. (Case DATEPART(QUARTER, T6."DTH...

Hi I'm trying to change the formula below to display the format of the date depending on option returned by the paramater, which is used in a crosstab. The formula breaks the period down to day, week or month. Any idea's on how to change this? select {?Interval} case "Day" ...

Hello I've been rattling my brains over this and now am out of ideas. When adding one (the same) table from an Informix database Crystal returns an error showing. "Failed to retrieve data from the database. Details: 42000:[Informix][Informix ODBC Driver][Informix]A syntax error has occured...

Hi I have created a parameter with "Yes" and "No" values and have placed a crosstab in the report header. I would like the report to display or not the crosstab, depending on users selection. Any advise how I can complete this? I'm using Crystal Reports 2008. Thanks, Javed

Hello I have created a cross tab report that shows dates in the rows. Although I am able to group on day, week, month etc. within the cross tab expert, I would like to create a paramater to allow the user to choose how they want the data to be grouped. Does anyone have any idea's how this can...

Hello I'm in the process of creating a report to search by postcode. For this i can create a parameter, but how can i change it to free text to allow the user to type for example, AB1 and the report to show all entries with AB1 in the table. Any idea's and help would be welcomed. Thanks, Javedi

Hello I've been attempting to but with no success write a formula to show the records where a record had been paid with 28 days after a letter had been sent out. The following formula shows notices paid after a letter had been sent but not within 28 days. @paidletter if not...