Search results for query: *

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

Hi I am fairly new with crystal and i was wondering if anyone could help me with this problem. I have a main report called "Main Report" and two sub reports called "SubsubConRPT" and "subCon999". I have two running total fields within the subreports #RTotal0 in SubsubConRPT and #RTotal1 in...

I am using a datadrid with a buttonColumn. I know that you can open a new window using javascript and link from within the html code. But can you open a new window by clicking on the buttonColumn from within the datagrid? The datagrid code is: <asp:datagrid id="Master" runat="server"...

Hello, I have a problem and I can't think of the best way round it, I would like a bit off advice. Problem: I have developed a mobile c# app (win forms) that runs off XDA's, this information is then automatically sent to a database back in the office. In the office we have to manually click...

Hi all, I am new to Crystal reports. I am using crystal within Visual Studio.Net, I have created a form which fills a dataSet with information given by the user. I want to be able to produce a report with the same information. How can I pass what they have entered into the textbox's (e.g...

Don't know if this is possible, I have a report which runs a very large query, so when you enter in parameters that you want the report to fufill it then brings back the data that was requested by the query. The problem with this is that it can take 10 - 20 seconds for the report to show...