Search results for query: *

Using CR 10. I need to alternate the colouring in a group footer that has multiple sections. Certain sections may be hidden at runtime by a user choice, so I need to set colouring dynamically. I have followed the usual habit of using a counter. In the report header I set up: //@Counter...

Using Crystal V.10 connecting to SQL Server 2000 via an ODBC DSN. I am building a manual crosstab and need to populate column headings based on the group names for group one. Group one is from a formula, as the user can select how to group the report at runtime via a parameter. There could be...

I have built a manual cross-tab and have a problem with certain summary values. The logic is: Formula 1: If Day = 1 Then [Value] Else 0 (this gives me the total value for day one) Formula 2: If Day = 1 Then 1 Else 0 (sum this to get the count of values for day one) To get a mean, I can...

I have a report displayed in a ASP.Net web page using the CrystalReportViewer. The report content depends on a set of parameters being passed in. The parameters are set using the ParameterValues and ParameterFieldsInfo, and I read in the contents of each parameter from a shared variable. The...

I'm almost embarrassed to post this one, I really should know the answer. I have a crosstab which includes two summarized fields. These just print one underneath each other in each column of each row. Is there any way of labelling the crosstab so users can tell what each figure is? Using CR...

Think I'm having a "can't see the wood for the trees" moment here. I'm grouping on a field which indicates what year my data relates to, then summing the numerical data that's in it. I'd like to take the total from the first group and last group and compare them in the report footer (subtract...

Can anyone answer the following issue raised by a project manager: They would like a link from a web page to a certain directory of the ePortfolio, but the link needs to pass the userid and password to the CE server - so the user is not asked to log on. All users have the same userid/password...

Couldn't even think of a better subject for this one! I have a table named {events}, which contains a memo field {events.providers}. The field is populated with a comma seperated list of numbers, each of which relate to an individual record in {providers}. The list may contain any number of...

Does anyone have a way of reporting the attributes of the underlying database file? I have a report based on a set of xBase tables and I'd like to include the datetime the tables themselves were last modified, rather than the date they were queried (i.e not using the DataDate function). Many...

I am trying to use Word to create a repeating block of text, which recurs three times on each page - they're actually tickets to a concert. However, I want to number each ticket individually. I've thought of using the Envelopes and Labels wizard to create the repeated text, but I can't find a...

I *know* this can be done with a subreport somehow, but I just can't get it to work. I have a field in the format yyyy/xxxx/yyyyy where xxxx is a four digit number. I'm extracting this to a formula named {@CostCentre}. How can I link {@CostCentre} to an entry another table where it exists on...