Recent content by mrees

Morning all, Here's the setup: Actuate 10 SQL datasource, using stored procs Reports have cascading parameters and "stand alone" parameters We have noticed that when you first open the report, the parameter procs are called once but when you open up the parameters window after a report has...

Thanks for your response. Under IIS->Websites->Default Website I have both a Reports and ReportServer directory. I assume this is what you meant? I think I have configured the report manager in reporting services configuration. But this seems a bit tempramental and prone to hanging. Thanks...

Sorry should say its RS2005

Hi, Hope someone can help me out here. I have been tasked with distributing some reports using reporting services. I have never used RS before. This was installed before my time so I cannot comment on many aspects of that. When I try to access http://localhost/reports, IE just sits there, no...

Hello Using SQL Server 2K. I have a DTS package that uses a SQL task to build a result set in a global variable. This rowset is then output into a text file using an ActiveX task. while not objResults.EOF strRecord = ObjResults.GetString(2, -1, "~", "", "") objStream.WriteLine(strRecord)...

Hi, Thanks for you reply. I hadn't considered exporting and it would appear to be the easy option BUT on checking it seems that using a TEXT format you don't get any toolbars, not even the export one. Could this be because the TEXT format does not need the ActiveX viewer to display the report...

Okkkayyyy It seems that if I open the report through ePortfolio, I don't get the toolbars - but I do get them when I view it from the CMC. Tell me what I'm missing! mrees

Morning all, CE9 + CR9 (Still [sad]) We have a report that is in a character separated value format which a client (outside of our organisation so scheduling to an unmanaged disk is not possible) want to be able to save locally somewhere after viewing. When the report is viewed the internet...

Hi, This is probably more of a Windows question, but I think I would get a better answer here. We have 10 reports running from our test environment (SQL Server 2k) that should be triggered by an event file that the SQL sever creates, this is how it works on our live system (where there are...

An audit trail is just really a list of information that you think is necessary to be recorded. In your case you wanted to know when your report was printed. The suggestion I gave was to record each time the report was run, by adding a new record to your list (The audit trail) It may be...

Hi, Although you wouldn't know if a user has printed the report, you could see when it has been run. If you base the report on a stored procedure, you could write a record to an audit trail each time it is run to produce the report. Something like. CREATE PROC sMyReport AS --Add record to...

Bugger, meant second question - and my tags were wrong! soz mrees

Hi, In response to your first question, I would decide how many columns you can get away with in total to start, (and I would suggest a using a crosstab) and then use the select expert to restrict your data for that x number of coumns. You don't say what your data source is, but sometimes is...

Ignore all of that - its rubbish Sorry! But I would try to remove the correlated subqueries. I may have another go if I get time! mrees

This is a stab in the dark - but what about.. Update ALLPOL set POLH_AGENTTOTAL_PRIOR_Q = select sum(CSFD_QUARTER_DATA) from ALLCSFD join ALLPOL as P ON ALLCSFD.CSFDPOL = P.POLH_POLICY_SEQUENCE AND P.POLH_AGENT_ID=ALLPOL.POLH_AGENT_ID AND...