Is any way to Modified The Query String Programmatically for a Report ? I want to be able to Change the WHERE Clause without using Parameter.. e.i WHERE DeliveryDate = '2005-04-04' but the next time I run the report I want something like WHERE DeliveryDate < '2005-04-04'. Thank. Any Idea I woul...more >>

Our reports work fine from our intranet, but I can't it to work accross the VPN. I can get to the main page and can select reports, but when I try to run them I get the messsage 'this page cannot be displayed'. However, I can view and change properties on the reports thru the VPN. I have ...more >>

Hi, I had an external assembly for which i had added the reference in the report.When i view the report in PREVIEW section the report is displyed properly with the data but when i review in browser the report is shown with error as "Security Error" where i am referencing the external DLL. Can...more >>

Hi guys.... I would like to do the following with my chart: 1. Have the label always appear vertically, and; 2. Limit the number of labels to 20 or less. Any suggestions? Thanks, Forch...more >>

We recently changed over to SQL 2000 RS. Many of our customers are not able to make sense of a report exported in Office 2000 version of Excel. It is completely unreadable. Many are not in the position to be able to Upgrade to Office XP or 2003. Any ideas on how to help customers with th...more >>

Hi, I am using the follwoing query and but am getting lesser total orders than are there in the database.. I am struggling with this since a long time.... QUERY:: SELECT Customer_Info.KPChoice AS BusinessUnit, COUNT(*) AS Total_Orders, Region.Region, LEFT(DATENAME(MONTH, INVOICES.Creat...more >>

Hi All, I have a Custom .net dll, refered in the RDL, the dll has a function which gets the encrypted CreditCard# and returns the Decrypted value to the Report. I have attached the code @ the end. I have given created the permission set and code group and copied the dll in the following lo...more >>

We're a small ISV looking to move away from Crystal Reports. For some months, we've been waiting with bated breath for the release of an embeddable, Windows Forms control that is able to render RDL. VS.net Beta 2 was supposed to provide this. The control (ReportViewer) seems to be included, ...more >>

I get the following message at least a dozen times a day: --------------------------- Microsoft Development Environment --------------------------- Could not generate a list of fields for the query. Check the query syntax or click Refresh Fields on the query toolbar. ExecuteReader requir...more >>

Has anyone successfully passed a bookmark id in the URL string to jump to a specific location within the rendered report?...more >>

Hello Does any one have an explaination or work around for the missing first row of data in csv export? Please help! Thanks Jessica ...more >>

After installing the server components on our win2000k sp4 server (running sql2000 sp3) and deploying a test report, browsing to the report server simply shows a directory listing of the report folder. I can run the report by and it runs fine, but there's no management interface - just a fi...more >>

I need to format an item. font, color, background etc. based on a value in a dataset. The dataset has the format; item1 value1 item2 value2 item3 value3 ..... How can I pick, for example, the value associated with item3 and apply it to the report item. To further complicate things...more >>

We'd like to deploy our report servers behind our web tier in the app tier in order to prevent our clients from being able to use url access directly. My main concern has to do with a chance that a client may attempt to alter the content of report parameters or otherwise probe around. Our ...more >>

Hello, I want to impliment forms basedf auth but before I go to the work, does anyone know if you can find the logged on user for use in a report? ie. I have some reports that customers need to be able to run. Using Windows auth, you could call the User!UserID parameter and then use it i...more >>

Ok, This is what I don't understand. Hidden rows with downline dealers only has '5678'. But the visible row that needs a drill down might have in the dealerlineageid field (which is a field not to be displayed) '5678' and '2754' and 10 other dealer numbers (multiple dealer numbers). How wou...more >>

Hello, We have a situation where we have a main reporting server on our main network and a separate isolated network with it's own reporting server. There is no external connectivity to the second network. We need to be able to periodically synchronise the two servers (copy all new/updat...more >>

Hi I need information regarding sending an email from reporting services. Any ebooks/url/info regarding this required. 1.Configuration settings required to send an email ? 2.Other things which needs to be done to send an email from reporting services. Thanks & Regards, Rajesh Yennam ...more >>

In a column of my table i will concat two selected values (Strings). I do this with the &-Sign. The Problem: Is it possible to make a carriage-return and line-feed in a column ? -- Message posted via http://www.sqlmonster.com...more >>

Hi, can anyone explain what this means and how to resolve it - if it is in fact an issue. Would this result in some subscription recipients getting the report and not others? Note, it's just a standard subscription emailed to an email group. thanks Matt ...more >>