Recent content by mart10

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%})