Search results for query: *

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

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

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

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

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

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

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

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

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

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?

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

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.

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

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

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

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

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

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

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

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