Search results for query: *

Thanks Geoff I suppose that's what I was hinting at and thought, but hoped maybe there was some way of doing it. Thanks again Alan

(SSRS 2005/2008) Hi All I'm trying to get my head around a report that I need to produce which has a page (or two) of client details, but it's complicated by the fact that the details fields are grouped into data sets. The report will look like: Adresses Postal 123 Main St... Registered...

Hi All - I have updated a form that was created in Outlook 2003 and has been used for the past few years by many users. It's published to the Organizational Forms Library. I have amended it in Outlook 2010 but the users are still on 2003 and when I send a form to a 2003 user they receive a blank...

Cheers for that. Sorry I meant to say I was use MS SQL 2000 with a stored procedure as my datasource. I think the sp rules out using a SQL Expression, but doing it from vb.net sounds like the best plan for me. Thanks again, Alan.

Hi All, Is it possible to display the database name in the report? I have a report that shows employee entitlement and the data could come from one or more databases - the user selects the db in vb.net. I can't see a way of getting at this. Any help appreciated. TIA, Alan.

Is it not the case that CR only reads the first SELECT statement in a SP and ignores the rest?! Alan.

In case anyone is interested, I got round this by creating another Cross-Tab and aligning it next to the original one. The only problem this gives me is a gap between the 2 tables if the first one doesn't have data in each column. Cheers, Alan.

Hi All, I have a cross tab report that has rows showing Work Tasks and columns showing the Grade of Employee involved. It shows the Hours and Values in the body of the report. What I need to do is add an extra total column that will show the average hourly rate for each Work Task, but I can't...

That's sickeningly easy!! :) Thank you very much. Alan.

Hi All, I have a pivot table that displays hours and values summarised on Classification rows and Grade columns. The data I am using looks like this:- Employee Class Grade Hours Value A Smith Admin Assistant 1.2 24.00 G Wilson Planning Senior 2.0 90.00 G Wilson...

Anyone know how I can get an upgrade to v6.0.1.151? I have a registered copy of 6.0.1.135 and have come up against a problem that I believe would be fixed in .151 I realise that it's old old gear, but can anyone give me a pointer? Thanks in advance, Alan Doanldson.

SQL 6.5 I have a problem with a large database (9Gb). When I run dbcc newalloc it returns the error message 2558: 'Extent not within segment: Object ########, indid includes...etc.' I know why I have the problem - I moved the db to a new server, but didn't use a script based on the original to...

Cheers for that it works OK. I guess I'm still confused as to why I should now have to do this. Is it a Win2k problem/issue? Thanks again, Alan.

Hi All, My software: SCR Prof. v6.0 Windows 2000 I have 'developed' a strange problem when I try to create a distribution for 4 reports that I have written. I open up my first report and run the distribution expert. So far so good, but when I try to select the next (compiled) report, it gives...

The reports are just run from distributed Crystal Reports i.e. from the .exe Could you please humour me and explain how I use SetLogonInfo or LogonServer. Thanks in advance, Alan.

Thanks for the reply. It still prompts for the password the next time you try to connect. Any other ideas? Anyone, please?

Hi All, I am new here so sorry if this is a bit basic. I have several reports written in SCRProf v6 and they all access the same sql db, which we have just upgraded from v6.5 to 2k. The problem I have stems from the fact that we originally used the 'sa' user with no password to connect to the...