Search results for query: *

I am using cr 2016 I have a parameter and I can select one or more items I also have the parameter in the header so you can display the selection. This works fine for selecting one item BUT not if I select more than one (data itself is fine its just the display in the header) Ideally I would...

I am using CR2016 I have a parameter where it appears automatically to put in sentance when selecting a date from calander box on a parameter as follows ---> Please enter Date in format "MM/DD/YYYY". I dont want this to display at all because it may confuse the user because normally...

I am having to use Excel (2016) in order to resolve the following . Acces would be so much easier but the office will not use access :( I have a tab of data where I need to 1, filter one column of data and then select each unique item in turn revealing the dataset and then save that dataset...

I am using CR2016 How can I consistently strip out the first leading 5 characters (including a space) of a variable length field as below: Original Required BNPP DVPGBR GBP COL --> DVPGBR GBP COL BNP DVPGBR GBP --> DVPGBR GBP

I am using CR 16 I want to sort order of report based on a parameter. I include the parameter in a formula and then put this formula in sort order If {?SortOrder}= "Counterparty" then {qrcr_cpartyderivativeslimits.CounterpartyGroupName} else...

I am using CR 16 I sometimes have data with text at the end saying "- Group" eg "abcdefghijk - Group" or 12345 - Group" how do I remove the - Group and leave abcderghijk or 12345

I want to show on a report which database i am logged in ON rather than the database my crsytal was designed and connected TO I did do a formula in SQL but that just picks up the design connection of the crsystal rather than showing which of 4 potential databases i maybe looged into (which all...

I am using CR16 I have a parameter which allows user to say if they want to sort by currency or %movement. This parameter is applied to a group level which is hidden It works fine except the sort order for %movemnt doesnt always show in order I would expect eg it can show 1.01...

I am using CR 2013 I have some exchange rates and I need to compare the output between 2 dates on the SAME row. I run the rport between 2 dates, so this is what I need date 1 date 2 diff USD 1.3 1.35 0.05 xxxx yyyy etc If you do this in normal way then the data...

I am using CR2013 SP7 For some reason my field and report explorer buttons are not opening their respective windows. Can anyone advise as its not obvious whats wrong and I've never had this in 15yrs of using Crystal

I am using CR 2016 How can I make a field at record level change font colour if its value has changed from previous row value( in detail level) I should also say its ONLY the change in a detail row with any groupings I have eg y 1 1 1 1 2 - to show red fornt 2 x...

I am using cr 2016 I need to bring into report header the server name and database name. I thought it maybe a Special Field but it isn't So how do I capture this . I login via OLE DB (ADO) Sql server connection route btw

I am using CR 2016 I have 3 levels in a cross tab. The user may want to suppress the data and the headings for the lowest level. How can I do this via a parameter when I run the report - something Ive never done on cross tabs before!

I am using cr2016 I have a parameterer on detailed report which filters data, how can I pass that selection to summary crosstab selection of data?

I am using cr 2106 how can I do select criteria on a group that is in a crosstab report my cross tab is in footer and all works well except i want to suoress certain groups (rows)

I am using Excel 2016 I want to run a mcro that pastes data of certain no of columns intoa nother sheet at diferent location (for further imprt into a db) and thats no problem. The issue is the no of rows where data is presnt in the original dataset varies every time. I could go crazy and...

I am using CR 2016 I have this in my detail section exper colour tab : if {View_AccountStatementWithInterestSQL_Union_AccountInterestSchedule.ASType} = 10 then (if {#Counter} mod 2 <> 0 then Gray else White ) This works fine but it shows the standard dark gray...

I am using CR 2016 I am pulling in bank balances every day and need to chart the trends and do have a working report/hart The issue I have is that the data is only captured on business days not weekends or bank holidays so my chart looks like a sine wave! I cant modify the database so I need...

I am using cr 2016 I have a report which show groups and detail very well an on each new page correct field headings in a page heading section At end of report (on freash page obviousely) I have a number of crosstabs in a report footer section. So on this "page" (section) I dont want to show...

i m using cr 2016 How can i make my rows in a cross tab have narrower spacing between each row, I want to squeeze up the data