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 TouchToneTommy 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: pko123
  • Content: Threads
  • Order by date
  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, 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...
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. 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
  9. 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
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. pko123

    average on manual running total

    Hi, i have a report in which , I have 3 groups Group 1 (Region) Avg 1(Avg 2) Group 2 (City) Avg 2(Avg 3) Group 3 (Name 1) Avg 3 = 8 Name Number detail 1...
  15. pko123

    compare values of group within a group

    Hi, I have one report contains 2 groups Group I contains region Group II contains subregion under Group II there is detail for That group. now for each Region there is Only one DEFAULT Subregion that is defined by Field, IS_DEFAULT = 'TRUE' Now i Wanted to show the count of records for...
  16. pko123

    Merge various formulas in Selection Formula

    Hi, I have one report that includes Manual Cross-tab(summary report) 7 rows and 5 columns,now the reqirement of the new report is when user click the any combination of row and column, the details should be shown in another seperate report corresponding to that number. In order to achieve...

Part and Inventory Search

Back
Top