Search results for query: *

Hi All, I have developed a Crystal Report xi rel 2, I have one group in the report. The is based on id. On the details section the is a field payment which summed up per id. Then in group record selection I have restricted all values less than or equal to £249.99. Now I only want to see the...

Hi Iam creating a Crystal Report xi Rel2 which has a parameter where a user can select one of two options for example : greater than 250 or less than 250. I have a column 'Paid', which I have applied a Top N to. But I want to change the Top N to Bottom N depending on what parameter value gets...

Hi All Iam using a CRXI Rel 2, I have a basic report with 2 groups....and sums at group level. The sums at the group level are being returned as a minus, which is correct. However when I select this sum of minuses the pie chart does not return any graphical display..... However when these...

Hi All Iam using CRXI Rel 2...and have developed a report which has 4 groups. You can drilldown on all groups. Is it possible when printing that a user has the option of printing all the data without drilling down to each level? Or is there a way a user can can control what level of printing...

Hi All I am developing a Crystal Report, which has 3 groups. Group 1 - QTR Group 2 - Month and Group 3 - SubDept. I want to represent the subdept data ie. number of ppl per month in a graph. I have gone to graph expert and advance and put 'on change of' - Month and in 'show values' I have...

Hi All Iam trying to create a cascading parameter by using fields from two different tables. The tables belong to the same db and are part of a relational db. I am using CRXI Rel 2.... Is this possible? Many Thanks

Hi All Iam trying to create a cascading parameter by using fields from two different tables. The tables belong to the same db and are part of a relational db. I am using CRXI Rel 2.... Is this possible? Many Thanks

Hi All I have a report which has 3 groups...group 1 drills down into group 2 and 2 into 3. I want to show the page header in group 3, is that possible? If not is there an alternative way? Many Thanks

Hi All Iam using CRXI Rel 2, I have a dt field which is populated according to when activity happened. But what I want to know is how do I get the weekcommencing date from that dt field. For eg. dt from the field is 10/01/08, the week commencing date would be 06/01/08. I hope I make sense...

Hi All I have a report which has 3 groups. Year, Month and week, now each group has incoming and outgoing dates/data. When I reach week no group, the incoming and outgoing numbers change if I click on either incoming or outgoing sums for group 3(week) the base incoming and outgoing brings back...

Hi All I am using CRXI Rel 2...to develop a report...I have a dt field and I want to break this week into weeknumber of the year eg. 1 - 52/53 The report will be restricted (select expert) by the YTD formula. I hope I have not missed any information... Please can you help... tc

Hi All I am using Crystal report xi rel 2, I am developing a report where the data comes from a sql cube 2000. I have insert the OLAP grip showing all the dimension names and values and also inserted a graph. One of my dimensions is called 'measure' now the graph represents 'One change of...

Hi All I am using Crystal report xi rel 2, I am developing a report where the data comes from a sql cube 2000. I have insert the OLAP grip showing all the dimension names and values and also inserted a graph. One of my dimensions is called 'measure' now the graph represents 'One change of...

Hi All I have a Crystal report (xi rel2) which seems to be gathering data for over 2 hours. The report consists of 2 tables. Table 'a' is linked to table 'b' with a Left outer join (LOJ). I have run two sepearte tests on each table with the conditions applied in the main report to the...

Hi All I have a basic Crystal report, which has 2 field placed at report detail level. First field is a month field (number datatype). The second field is a string field. I have made this formula a shared numbervar as this standalone report will get integrated as a subreport into a main...

Hi All I have 2 groups...Manager and Employeeid. A Manager can have many employeeid. If a Manager in his group has Employeeid 65 then I dont want this manager to show and this will also stop his empoyeeid's to appear. I am using CRXI Rel2.....please can you help as I having a blur at the...

Hi All I have the followin sql query in sql 2005 and I want to return where TEST = 'Yes', please can you advise how I would do that? SELECT File.dbo.MI.Premium as a, File.dbo.MI.Num, CASE when Premium = 1 then 'Yes' when Premium = 0 then 'No' else '?' END AS TEST FROM File.dbo.MIRep...

Hi All Iam using BOXI Rel2 and have a OLAP cube created in MSAS 8.0. In Infoview I can successfully create a OLAP connection to the cube and see the connection. But when I go to create a OLAP report in Infoview I cannot see the cube? Please can you help.... Many Thanks

Hi All Iam new to sql coding and working with SQL 2005, I need to know how to structure my query or what I am doing wrong with my query. I have 2 datetime fields, field1 and field2. I need my query to return results where the number of days are within a 14 day period from field1 datetime...

Hi All can anyone tell me how in ms sql 2005 do I put a where clause in which only returns records which <= current date ? Many Thanks