Search results for query: *

I have a report that summarizes a count by a region over a period of time. within the report i want to summarize the counts by week for the duration over time with a line chart. I want the label to read "Wk ending MM/DD" and the formula is written thus "Wk Ending...

Hi, CR 2008 and Universe data source I have a similar issue to this thread i found http://www.tek-tips.com/viewthread.cfm?qid=687354 but it does not solve my issue. I have a report that groups by Region. within the Region GHa I have a XTab that shows the Countries as Rows, the Months as...

Hi, I have CR2008. I currently have one report that based on a parameter selection will produce five different result sets. The report will run on a schedule for each parameter to produce 5 separate instances exported as txt files. Is there a way to have all five combined into 1 txt file for...

CR 2008 I have a report with Fiscaldate/Year, Account Name and Measure. the report will contain multiple fiscalmonths at a time. I need to sort the report first by fiscal month -ascending them by measure decending only for the first or earliest fiscal date. for all dates afterwards, i need...

Hi, Oracle, CR2008 I would like to set up a parameter "Week/Month" where it would prompt the user to select the value of either "Week" or "Month" and based on his selection, the report will return data from either the Week Fact Table or the Month Fact Table. There are no other tables involved...

I just learned that the database used for many Crystal report (XI R2) will be changing from SQL Server to Oracle. What is the impact of the crystal reports? do they merely need to be repointed to the new database and remapped? or will they need to be rebuilt? Any advice is appreciated. thanks!

http://www.ragan.com/Main/Articles/42944.aspx i really liked this article

Hi, BW Query and CR 2008 I have a cross tab. Summarized by type, region, sub region, country and then detail. columns are time periods. How can i return only the top 5 results?

Hi and thanks in advance for wisdom. Using CR XI and SQL Database I have a report that snapshots some projects & their resources. Group 1 {project.currentphase) Group 2 {project.class} Group 3 (project.name} Group 1 and 2 are suppresed an in group 3 I have a summary of the group...

HI, CR XI and SQL database. I have two tables Projects and Tasks joined by projectid. Each project can have multiple tasks. I have a group by Project and tasks in the details. Each task has a task type, start date, end date, status. The task type may be one of these valuese: Plan, Design...

Is there a way to do this without doing a subreport? I have two tables Orders & Order_Details Some orders don't have details. Some do. Some of the order details I want to see in my report some i do not. I want a group by Order then in the detail show the order details. I've joined by...

cr xi. sql database I'm sure this is a Doh question but I can't seem to find a way to do it in the section expert. I have a report with Page header Group 1 (order) Group 2 (order) the report will run on various parameters and allow for multiple orders to appear on the report. When the user...

CR XI and SQL database... i have built a report using font Arial 8 pt type. from the crystal viewer on the remote server I have built it, the report will display properly. If i view in HTML mode from the same server, it will display properly. When i load it into it's web based application and...

Hi all... CR XI and SQL Server Database. I have a report with 3 subreports. When a subreport has value(s) it makes the background color of my group name field appear with orange background in HTML - how my users will access. Is there a way to NOT do that? I just just crWhite for background...

I found this thread767-1579509 which is similar to what i need to do but I am working in Crystal XI and dont' see the add command option there. I have a parameter but I only want to return the values of [table].[name] where [table].[type] = "this type" and [table].[country]="CAN" is there a...

thread253-1558934 I found the thread above. Does anyone know if there has been any progress on the functionality?

Hi i am hoping someone can help... I have a system generated spread sheet that is supposed to be a report but it needs some help. there are many columns... of them and of imporantance are A: Article B: Reviewer C: Reviewer Accept D: Reviewer Approve so my data will look something like...

Hi, I am trying to convert several Visio diagrams to be 508 compliant. (They must be easily read by someone who may be visually impaired) One of the criteria is that they must be in correct logical tab order for the components of a diagram. Should a user navigate the process flow by using the...

thread961-1316226 I am having a similiar issue as what was posted on the thread noted. Same error message. Also using SQL 2000... trying to get Excel file not CSV file though My DTS, however, IS creating a new stub file at the start of the package. This step will execute fine. However, it is...

Hi I am hoping to get some help figuring out an error. I have an Excel 2003 file and have a DTS built to load it into a SQL 2000 table. Each time it attempts to load, I will get the error msg: DTS Transformation_83’ Error Conversion invalid for datatypes in columns xx to yy. To enable the...