Search results for query: *

Andy thank you very much! Exactly what i needed.

oops, sorry.. the second date is supposed to be 03/01/2008.

Is there a way to display the number of months between two dates. For example if the first date is 02/01/07 and the second date is 03/01/07 i want to display 13 instead of 1. which is done by the month({date2}) - month({date1}) Thanks in advance. -Paul

Thank you very much! I originally had a while but i came across a solution on msdn that recommended an IF block... i changed it back to while and its working. Thank you both of you!! Really appreciate it.

Hi in my code block if i have only one of the text boxes display data it works fine. It doesnt matter whether it is txtPBatch and txtPDate but not both of them at once. when i set it to display for both of my text boxes i get the following error. System.InvalidCastException: Unable to cast...

thank you very much!!

Hi, i'm trying to display the final value for a running total. I have credit card charges by date and card type that i'm pulling from a database. I'm able to display a running total for each row where it resets if either the day/card type changes. However it is mind numbing to look at. Is...

I'm confused... my first dropdown list pulls data from a data set. and then this is the code for my webservice method for the 2nd dropdown list. public CascadingDropDownNameValue[] getSemesters(string knownCategoryValues, string category) { string[]...

yes but it will only take a parameter from the previous control, not 2 parameters one from each of the previous two controls.

Yes and in C#.

Thanks for the reply and this is with AJAX in 2.0 framework.

I've been able to create two cascading drop down lists that take the parameter from the previous control successfully. However is there any way to make it so that the third drop down list can take a parameter from each of previous controls? Thanks in advance! -Paul

Hi, I'm running CR 11 and building this for an ASP.net application. I have a discrete parameter {?site} which can have multiple values. If there are no values selected from the page, the parameter will have a value of -1 otherwise there will be a number(s) in the parameter in an array...

Thanks!

I want to select 2 different types of records in my report. I have a table with accounts that are the main account and have a specific type of account. In the same table i have accounts that are sub accounts but have different type of account than the previous selection. I want to select both...

What you can do is create a function such as the following then create function [dbo].[CSVtoData](@Str varchar(7000)) returns @t table (numberval int, stringval varchar(100), DateVal datetime) as begin declare @i int; declare @c varchar(100); set @Str = @Str + ',' set @i = 1; set @c = ''...

Oh btw i'm using Crystal Reports that comes bundled with VS2005 Pro.

Hi I'm having a problem with the sum of values for the details section in the group footer section. I have 2 tables one is member information(tblmemberfinance) the other is where registration information is kept (tblartransitem). The tblartransitem table has a Foreign Key for the member info...

Hello, I'm using the CR version that comes with VS2005 and running in to a problem with a report and ASP.net 2.0 I have a report that uses 1 discrete parameter from the webpage and when it displays the report it is not keeping the formatting that I designed on the report. i.e. Left alignment...

I have SQLServer 2003 database that keeps track of transactions in datetime. To make it easier on the frontend user I want to pass date parameters in the format of mm/dd/yy instead of standard datetime format. I'm trying to get a listing of all the transactions that occurred during a specific...