Search results for query: *

its string parameter and yes as per your example, I drop the ?Parameter into the header and want to show as you suggest. At moment it just seems to show one value

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

the data lies in one tab of an Excel workbook I cant write code, I will send the code tomorrow Skip

Yes i know how filters work, what I want is for each selection filter in turn (via a macro) to output and a save a CSV file of that filtered data only and give the CSV file the filter name eg In my workbook in tab in question called X A B C (where C is the filter colum) 1 2...

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

thanks, actually I sorted it with same simple idea

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

great that works fine thanks

this worked to large extent but didn't handle negative numbers. I would expect (want) something like this as the number sort order -6 -3 -2 1 2 3 4 5 but I got 1 -2 2 -3 3 4 5 -6

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

Thanks but its a vendor SQL application so I cant add tables. You would think from the splash screen login where you select which db to login you could pick that up but the vendor is not being helpful at all

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

The trouble is if I do that it falls over when trying to display by currency rather than % movement. I have a parameter called sort order you see When I put tonumber before FXRATES_1st.ccy it doesn't like it If {?SortOrder}= "Currency" then tonumber({FXRATES_1st.ccy}) else ({@Movement%})

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

Hi LB, you seem to know what to do but was bit confused on what you want me to do and where. Sorry to be a pain but could you elaborate Thanks PS - SVought - er Excel is NOT an option or auditable! :)

sorry but that didnt work either in fact it was worse!