Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Shin25
  • Order by date
  1. Shin25

    Top 10 on summed field

    When I select top 10 from group sort it brings back nothing and when I select bottom 10 it brings back the correct results. Iam basing my top 10 and bottom 10 on the sum of payment per group id. I dont quite understand. Many Thanks
  2. Shin25

    Top 10 on summed field

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

    top N

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

    Pie Charts and Minus Figures

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

    Cascading Parameters

    Ok I have managed to set up the cascading parameter but I am getting the following error message when trying to run: --------------------------- Crystal Reports --------------------------- Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of...
  6. Shin25

    Cascading Parameters

    Hi I have tried cascading parameters with tables that are not linked...no success... Any one had any success or got any ideas?
  7. Shin25

    Printing without Drilling Down

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

    Graph Problems....

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

    Cascading Parameters

    Cheers Ibass.....when you mean linked do you mean they should be directly linked or can I get away with them being part of a relational db?
  10. Shin25

    Cascading Parameters

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

    Cascading Parameters

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

    Page Header

    Or alternatively I can click from report options 'show all headers with drill down', the only problem is in report header a and report header b I have placed graphs and they are feeding through when drilling.... Going mad...please help....
  13. Shin25

    Page Header

    Hi lbass I tried that and it did not work.....my initial page has 3 groups and when I click on group two it drills down to group 3 and I want the page header to appear here. Any ideas? Many Thanks
  14. Shin25

    Page Header

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

    Week Commencing

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

    Drill down

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

    Week No - Formula

    been long time since I used Crystal....to this degree...I figured it out... Cheers
  18. Shin25

    Week No - Formula

    thanks for that ibass, I have a group by month which I want the user to click and then the week number to show....how would I do that? Many Thanks

Part and Inventory Search

Back
Top