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: *

  1. pko123

    dynamically change width of report

    Hi, We are looking for method to change width of report dynamically. That means. We have a report with a parameter and based on parameter number of output columns will change along with Column heading. THere might be 50 columns for one parameter and maybe 5 coulmns for other parameter...
  2. pko123

    Achieve Mulitlevel Drill down in Crystal Reports

    Hi, We have a requirement where we need to create mulitlevel drill down report along with summary numbers For example first level we want to show report for ITEMS lets say item A item B item C if user click on itemA, that should expand [ul square] item A [ul circle]...
  3. pko123

    Updating Fields from multiple tables to SIngle Table

    Hi, One more thing, how can I find out which field is which on design tab, I mean if report is directly being used in the report (not in formula), is there any search that i can do to find out that field in all sections.
  4. pko123

    Updating Fields from multiple tables to SIngle Table

    Hi, Thanks Bill But is there any other way of replacing fields, because in my report, over 100 fields are being used and its all over place, in formulas, charts, crosstabs, running total etc. So just wondering if anybody else has any other solution besides to above solution. Thanks
  5. pko123

    Updating Fields from multiple tables to SIngle Table

    Hi, I have a crystal report that is created against 5 different Tables, I am pulling fields from all these table, Now we have a Database View that has all the fields that i need to use in this report. Is there anyway to update fields from different tables to single table. I tried to update...
  6. pko123

    Dynamic Parameters in Command Promt

    Hi, Is there anyway that i can use cascading dynamic prompts in the SQL Command. Means , I have a SQL that takes to parameters and i want to values for those two parameters from a dynamic cascade parmeters. Is it possible, I am using BO XI R2 version with SQL server 2000. Thanks
  7. pko123

    Stor Proc with 2 set of parameters

    Hi, I have report that displays result from SQL stored proc. When i run stored proc with first set of parameteres, it results four columns Market , Number1, Number2, Number3 as titles and report runs fine. But when i enter second set of parameters,stor proc suppose to return following four...
  8. pko123

    Stor Proc with 2 set of parameters

    Hi, I have report that displays result from SQL stored proc. When i run stored proc with first set of parameteres, it results four columns Market , Number1, Number2, Number3 as titles and report runs fine. But when i enter second set of parameters,stor proc suppose to return following four...
  9. pko123

    crosstab difference of Avg

    moreover, i need a average for distinctcount of sites in States. Is this is possible with cross tab...I am using BOXI R2 version of crystal
  10. pko123

    crosstab difference of Avg

    Hi, I have a report where i need to show crosstab report, summary average of sales for each quarter for each state, but along with that i also want to include another column or another crosstab that shows the difference of average of last 2 quarters. is this possible or i have to do manual...
  11. pko123

    Suppress Data label in Graph

    Hi, I have a Multiple Pie chart graph, Where i want to show Summary, And i want to show only those lables that has Summary value greater than zero (> 0). Is there any way to suppress label that has summary = 0. I am using CR XI r2. Thanks
  12. pko123

    Same Parameter for Stored Proc & Command

    Hi, I have a report that is running against Stored Proc, and it has 2 parameters , Now i need to add a Command object and i want to use the same parameters that report created for stored proc. Is there any way i can choose those parametrs for command object. Thanks
  13. pko123

    Cross tabs % summary

    Thanks, it worked perfectly!
  14. pko123

    Cross tabs % summary

    Hi, I have a report in which i need to insert a crosstab. Region I Region II Milestone Target Actual % | Target Actual % I 30 15 50 | 40 20 50 II 30 9 30 | 40 24 60 III...
  15. pko123

    Blank Subreport

    Hi LB, Thanks for your reply, i didn't get the first approach but i used second approach and its working perfectly. Thanks
  16. pko123

    Blank Subreport

    I have one main report which has one Group on field A, and there is one linked subreport that inculde detailed information and these two reports are linked with Field A, Now I want to show , if there is no data for particular group in the subreport I want to show 'No Records Found', I tried so...
  17. pko123

    Customized Dynamic Cascade prompting

    Hi, I have report in which there are 4 fields. 1) Event 2) alarms 3) start date 4) end date now each event has one start date and one end date and each alarm has one date. for example Event start date enddate 1 7/2/07 7/22/07 2...
  18. pko123

    Single click Excel report

    Hi, Thanks for reply. I read opendocument paper and it worked fine. One more question how can i implement logon credential along with opendocument. like we use in viewdocument for example this is the string i use to viewdocument...
  19. pko123

    Single click Excel report

    Hi, I have a one ON Demand Sub report created in crystal reports XI that is accessible from infoview. Right Now, the way it works is, this report contains a detail records when somebody click that links it opens a new report and then people has to export that to excel using excel output...

Part and Inventory Search

Back
Top