Recent content by Saint1234

I have created a report with 2 parameters. I need to pass these parameters to crystal before the report will execute. I am using asp with crystal. I have down this before with windows forms using cr.SetParameterValue(0,first); With asp I do not get the SetParameterValue. Is there another...

Hi all, I am using crystals parameters. I was wondering I have it setup to select data within a date range. How can I show this range on the report? Thanks in advance. G

Hi All, I have a report and in the details section I am displaying e.g. Engineer Name (Group), Start time, finish time and a few more. In the group footer I am displaying a summary of average start time, no. of jobs etc. From this I need to display a complete summary in the report footer as...

Hi All, I have two groups 1st is Engineer name and the second is date. I am trying to work out the average number of jobs per day worked by engineer. So I have counted the number of days by using count groupnumber. And counted the number of jobs worked and obviously I have divided these. I...

Hi All, I have a problem, i have a report with a sub report. From within the sub report I have several records. In the footer of the sub report I am counting how many records there are by doing a count on a field within a running total. I am then passing this value into the Main report. This...

Yes it is an embedded sub-report. Thanks G

Hi All, I am using crystal with visual studio 2003. The problem I am having is : I have a datagrid in c#, I am passing this to crystal, no problems worked fine. I then added a subreport which used a SQL Command, as soon as this went in crystal started prompting for server name, database...

LOL, thought so, Thanks anyway G

Hi I was wondering if there is a way to automatically close a sub report when it has lost focus. The problem I am having is when people are looking at a on demand sub report they then just click back into the main report and open a sub report for a different row, this is then leaving the client...

I am looking for advice on the best way to do the following. I have a form with a datagrid, when you right click you get the option to view a work report (pdf format) which works fine. I also have a windows service which emails someone to tell them that a new row in the datagrid has been...

Thanks for your reply but the result comes up as 0.00

Hi all, sorry for so many posts but honestly this will be the last (I hope). Two dateTime fields and i have to work out the difference, the two fields are @timeoncall and @timeoncall3. I have tried a few methods and keep getting 0:00 as the result, the two fields show: @timeoncall - 13:03:13...

Thanks dgillz That worked a treat, sorry to be a pain but another question how do I highlight it? So if that date is greater than 17:00:00 how can i change the font colour and make it bold? Thanks G

Hi All, I am sure this is very simple but my head has gone blank. I have DateTime fields, what I need to do is count and highlight the fields where the time is greater than 17:00 the format of the datetime fields is DD/MM/yyyy HH:mm:SS Thanks in advance G

Hi all, I have a report which has a series of records taken over a date range. Each record contains an address, dateTime and status. The date range is select through a parameter that i have created. What i need to know is, is there a way that I can add the number of records per day? The...