Search results for query: *

I'm producing a Statement of Account for a number of clients using SSRS. My main report gathers the identifiers for each client I need to produce a report for. Within this report I have a table that consists of 2 sub reports . The first subreport displays the address for the client and takes...

Thanks - That would work but I don't think I explained the whole problem. Basically it's a financial statement run for a list of clients. For some clients their statement fits on one page so that's fine. But for others they can run to 2 or 3 pages. The Statements for all clients run in the...

Hi all, I have a table on a SSRS page that displays about 5 pages of information. I'd like to be able to put the word 'Continued' on each page except the last. Does anyone know how this could be done? Some of the rows are longer than others so there is never a set number of rows on each page...

Hi - Thanks very much for your reply. That seems a bit repetitive to me (if I'm thinking of it correctly) Each of the 5 sub reports outputs a number of fields and a total using a dataset created for it. So you're saying I should recreate the 5 dataset on the main report which calculate only...

Hi All, I have a report that contains 5 subreports. Each subreport calculates a value. I need to be able to total the values in each subreport and display this on the body of the main report. In Crystal Reports I could create shared variables in each subreport to pass to the main report, and...

Hey all - had a brainwave and tried a big nested IIF statement and it seems to have worked. There are 6 different values the action code can be so the statement looks like below.... =iif (Fields!ACTION_CODE.Value="DRFT80",(((Fields!BASE_AMT.Value)/80)*20),iif...

Hi All - this is doing my head in so I'd be grateful for any help. This is an expression I've put on a field in my reporting services report. =iif (Fields!ACTION_CODE.Value="DRFT80",(((Fields!BASE_AMT.Value)/80)*20),0) OR iif...

Try this... On your Citrix Box/Farm, load the Access Suite Console. Then Click on "Manage Secure Client Access" and then "Edit Secure Gateway Settings" On the screen that loads, make sure you have "Enable Session Reliability" ticked. Once I did this, I was no longer disconnecting after 10...

Neil again... In addition to this make sure there is no time out set on the IIS server that your Citrix Pressie server is going through.... this caught me out as well.... Thanks, Neil.

Thanks guys - I'll have a hunt for the 3rd party tools - otherwise I'll be stuck in a room somewhere for 2 years converting....

Hi synapsevampire, thanks for your reply... I have previously looked at the document you suggest but the steps seem to be... · Create a new Report Project in SQL Server Business Intelligence Studio · Data Tab - Create a new DataSet and configure the Data Source connection information · Data...

HI All, We're using Crystal Reports version XI and are moving to SQL Reporting services 2000 or 2005. I have a load of existing reports that I need to migrate across in some way. I was told that I could possibly export the files in RDL format and import them into SSRS but I can't find an easy...

Hi All, Many thanks to all who replied to this thread. I have tried a number of suggestions but none seem to have worked. However, on investigation I think I've solved the problem. On your Citrix Box/Farm, load the Access Suite Console. Then Click on "Manage Secure Client Access" and then...

Hi, We've just started using Citrix Presentation server to publish applications and allow our employees access to company systems from home / abroad etc. We have a problem were a user can sign in and have access (using their normal network username and password + a Citrix Safeword) but the...

ISA Destination sets allow us to open certain internet sites to users while not allowing open access. However, I've added quite a few internet addresses into the Standard Destinations in ISA server but a few of them ISA ignores and still does not allow users to access them - the addresses do...

Hi, Thanks for the response. Basically we have a Borderware Steelgate firewall and we are using the SurfControl plugin (not the full package). The only way it seems to restrict internet access is by IP address - so I need a range of IP addresses that will be assigned to machines that have full...

Hi - We have a small network with 1 subnet. I need to be able to dynamically assign certain machines ip addresses from a specific range. I basically need 3 groups - one group of machines will be assigned ip addresses from range 1, another from range 2, and so on. I'm looking into using DHCP...

Hello All, I have Backup Exec v8.6 backing up a number of NT servers and 1 Novell server. All data is backed up and verified successfully though the job always comes back as failed. The reason for this is because Backup Exec is trying to copy the Novell Licence files to tape, which it never...

Hi, My differential backup has started to fail with the message..... The media provided to continue the backup already contains data from one or more sets created during this operation. The operation can not be continued ^ ^ ^ ^ ^ even when I have the 'Append to Media, overwrite if no...