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. allyson1

    Display string formula does not export to excel as displayed in Preview

    I am using crystal reports 2008 and have a crosstab in the report. There are a number of summary fields where the value is replaced by having a formula in the display string for that field. If I export the report to word or pdf, the exported value shows the same as the preview. If I export to...
  2. allyson1

    Pass credentials in URL for Infoview 2008

    Hi hilfy, Thanks for your post. Our environment is such that we have a portal where our customers log on. The username and password they use to logon to the portal is then updated into the URL, which is a 'tab' shown on the portal, and that is what connects then to Infoview. The URL is not...
  3. allyson1

    Pass credentials in URL for Infoview 2008

    I have resolved this issue by using the following URL: http://serverip:8080/PlatformServices/service/app/logon.object?cms=servername:6400&username=BCS&password=abcd&qryStr=&cmsVisible=false&authenticationVisible=false&authType=secEnterprise&isFromLogonPage=true&appName=SAP BusinessObjects...
  4. allyson1

    Pass credentials in URL for Infoview 2008

    I would like to pass username and password credentials in the url when starting Crystal Reports Server 2008 Infoview. The URL to start Infoview is: http://servername:8080/InfoViewApp/logon.jsp The working URL to start Infoview for Crystal Enterprise Version XI was...
  5. allyson1

    Variance in column width of crosstab after export

    I have a crosstab built on specifications that say the value must be 20 characters wide. The summary values are alpha numeric. The crosstab has to be exported to text format to be then used by another process. The export is working very well with the exception of 'occasionally' the column...
  6. allyson1

    Globally replace one field for another

    I have a report that has two parameter fields, project number and template name. This report then has 30 subreports, and one of the linking fields is the {?template name}. Then within the subreports, this {?template name} is used for conditional suppression, conditional text displays, formulas...
  7. allyson1

    Globally replace one field for another

    I have a parameter field that is used MANY times in my report and now I would like to replace that field with a database field. Is there any way to replace all instances of the existing field with the new field, other than manually of course. The report is written in version 10, but I also...
  8. allyson1

    Evaluate all records to create a value for each record

    yes, that would be great, but I dont know how to.
  9. allyson1

    Evaluate all records to create a value for each record

    Thanksi MichaelRed for your reply. You're correct with your 'grouping' thoughts. Maybe I'll give you a more overall picture. I have a recordset created from a number of tables, then narrowed based on a parameter (project) selection. This record set is then reported on using Crystal Reports...
  10. allyson1

    Evaluate all records to create a value for each record

    Hi RyanEK, I'm not sure where to test out your code? I have a view that contains my recordset, do I just try your code from the select statement?
  11. allyson1

    Evaluate all records to create a value for each record

    Sorry, I don't really understand your question. The new GROUP field is based on the combination of the two fields TYPE and NUMBER. It has to be that way, because the NUMBER value could be repeated but to a different TYPE. So I need to create this new GROUP field based on the two fields...
  12. allyson1

    Evaluate all records to create a value for each record

    I'm sorry, I'm not sure if I may have led you astray a little. My example is just that, an example. My actual recordset is about 200 records, and the records will change depending on a parameter value.
  13. allyson1

    Evaluate all records to create a value for each record

    The GROUP is based on TYPE and NUMBER combination. The first combination is B100 so it becomes 1.1, so all B's will start with 1. The second combination is B106 so it gets 1.2 because the NUMBER is unique. The next combination is R102. The TYPE is new so it gets a new first number, so now all...
  14. allyson1

    Evaluate all records to create a value for each record

    The new column will be used in a crosstab in Crystal Reports. The data needs to be grouped by the combination of the two fields (Type and Number), but displayed as Group field (my new column). In Crystal Reports, I can actually generate this value by using Variables in the display, but I need...
  15. allyson1

    Evaluate all records to create a value for each record

    Hi, I am fairly new to creating sql commands. I am a user of Crystal Reports and have hit a 'brick-wall' with a value I am trying to generate and export, and have found that CR is not able to do what I need. I was wondering if a SQL statement could be created for what I need, then added to my...
  16. allyson1

    Group numbering shown in original order

    I am on the verge of trying to generate what I need either via Crystal SQL command or trying to create a view.
  17. allyson1

    Group numbering shown in original order

    Hi, Here is the formula from the @concat field: totext({SAMPLE.ORIGINAL_SAMPLE},"000000")+" "+{SAMPLE.SAMPLE_NAME} This field is used as the 'row' in my crosstab. The row field is then formated, with the following formula on the 'display string': whileprintingrecords; stringvar array x...
  18. allyson1

    Group numbering shown in original order

    I must use a crosstab for this report, so cannot have the @concat field show in the details section. I tried creating your two formulas over a very simple excel spreadsheet with just a few entries. There is so ordering, no grouping, the @concat field is used as the row line in the crosstab with...
  19. allyson1

    Group numbering shown in original order

    Crosstab is in report header, tried moving it to report footer, same result :-( Also, have removed all fields from details section. This is how the crosstab looks in text form: Std 3.8 , Std 3.7 , , Std 3.6 , Std 3.5 , , Std 3.4 , Std 3.3 , Std 3.2 , Std 3.1 , Std 2.5 ,0.0149 , , , , ...
  20. allyson1

    Group numbering shown in original order

    Hi, Answer is yes, using the concatenation formula for the row field and yes, using the longer formula in the display string for the rows. Also, no sort order defined. If I use the string display on the @concat field and show it in the Details section, it works! If I leave it there, and...

Part and Inventory Search

Back
Top