Answer Questions

• Frank Uray (BUG?)Some JPEGs not showing correctly in PDF-Export

  Hi, we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report. But some Pictures don't display correctly: I want to add this image . In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it). If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image.. Does anybody have a similar issue and a solution for this problem It doesn't matter if I retrieve the jpeg from a database or from disk, this problem al ...Show All

• dagjo Buildind a report builder.

  Hi all, Does anyone have information on coming up with the report builder The Microsoft bookonline do not help to much. Thanx in advance. If you want to play around with some samples, you can use the new BOL samples (which are renewed within the new July release of the BOL) or this link here: http://msdn2.microsoft.com/en-us/library/ms345268.aspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• alsc How to integrate reporting services with ASP.Net

  Hi My current situation is how to integrate my application written in asp.net to link to my report server's report  as by default anonymous user can access my report server's report without any authentication. how to configure to make the report server by using form authentication before access the reports  My Application Configuration Web application (Vb.Net) - http://192.168.1.18/mobiFO   Reporting services - http://192.168.1.19/reportserver/reports/mobiforeport DBMS - MS SQL Server 2005 developer edition + Reporting Services 2005 SP1   Thanks for your help. anything can email me at jack0726@yahoo.com   Hi guys, I've been trying to integrate t ...Show All

• Folyjon Passing DateTime Parameter to Subreport (Error)

  Hi guys, I have managed to pass a string parameter form the main report to the subreport with no problems, but when i try and use the same method to pass a datetime type, i am issued with the following error messase: "[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘SubReportName’: The value provided for the report parameter 'MasterDate' is not valid for its type." I cant see why it work for strings, but not for datetime. Any suggestions will be very much appreciated Does anybody know why i am getting this error Just to clarify, i am using the same dateTime type to define both main and sub report parameters ...Show All

• ATT Labs sql problem

  hi, i have this sql statement. set @stmt = 'select distinct * from (' + @stmt + ') as ax, (' + @st + ') as bx where ax.invoiceid = bx.invoiceid and ax.pono=bx.pono' now suppose it returns select a.s , a.t , a.u , b.s, b.t , b.total from a,b where a.s=b.s how can i reduce this to select a.s , a.t , a.u , b.total from a,b where a.s=b.s . i cannot use named fields but i need a way to prevent duplicated fields. Hi, If I get it right, you want to create a join between two tables without knowing the tables in advance To do this you will need to use the sp_sqlexec stored procedure. This stored procedure allows you to execute dynamic sql statements. Here is a possibility to retrieve ...Show All

• AlexB-007 Lookup Transform

  Hi! I am a newbie, grateful for some help. I have a Source Ole DB w sql-command selecting the customer.salary and customer.occupation, which I want to match with demo_id in Ole DB destination. salary, occupation also in dim_demographic. But in Lookup editor I find no column demo_id... how do I do this The OLE DB destination preview shows you what's in the destination table, not what's in the data flow. You have nothing in your table, hence nothing shows up in the preview. How would you do if you had a demo_id in db Destination, which should be matched with the values salary and occupation in Dim_demographic (containing columns id, salary, occupation) or de db Source sql customer.salary, customer.occupation Thank you! ...Show All

• Novelle SQL Server 2005 Everywhere Edition: Replication with MS Access?

  Hello @all, does anyone know whether a SQL Server 2005 Everywhere database can be replicated with a common MS Access database Is there any possibility to synch a database on a mobile device (SQL Everywhere) with a central database on a server computer (like MS Access or SQL Express) without having to use a full version of SQL Server Replication is just needed for merging a small database (4-5 tables) so I think the full version of SQL Server is a little bit oversized for this issue (and too expensive, too). Thank you very much in advance, Tim Hello Manish, thank you very much for all your answer - I appreciate your help! Since I know more details I will wait for the first release of your a ...Show All

• djarctic Cannot view database properties

  Hello all.... I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS. I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS. The user databases have been restored and are accessible by all applications. If I try to view the properties of any database (system or user), I get the following error: ********************************************************************************************************************************* TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL IN ...Show All

• TheViewMaster Zip archive of XML docs loading into SQL Server

  *Newbie Alert - Non-Programmer* I have over 100 thousand XML docs in a zip archive to upload to SQL Server 2005. My question is how to go about this and what is practical I've read a couple of posts using some sort of loop but it seems slow and I don't want to unzip the archive. I would want each doc as an individual record and whole and not shredded. Any info would be greatly appreciated. Thanks SurfingMoose No reply yet Is what I'm asking possible SurfingMoose You will have to unzip it since SQL Server does not understand ZIP files. then you have to write some script (maybe using SSIS or VB ) to loop over the files and load them into the database. You pass the cont ...Show All

• bobo224 Could not start the SQL Server Reporting Services (REPORTS) service on local computer.

  Error 1069. The service did not start due to login failure. I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable. Thank you for any advice you have. Yes. I am seeing a blank ASP.NET service account box. The two services I was referencing were: SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database. ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. ...Show All

• Rajesh batchu Won't select rows with null field values

  I cannot in the life of me understand what goes wrong here... In a webapplication (C#.NET) I traced an inability to retrieve existing records to SQL Server, where I cannot do the same either. The problem is that in the parameterized query, some fields can be null, and thus when the corresponding fields in the database record are null also, they should be selected. But this won't happen for some reason. I wrote a test SQL statement that gives me the same bogus: DECLARE @institution int, @collection int, @serialnr int, @subnr nvarchar(50) SET @institution = 1 SET @collection = 1 SET @serialnr = 240 SET @subnr = NULL SELECT ID, Institution, Collection, SerialNumber, SubNumber, AccessionYear, Sagsnummer, DanekraeNr, TaxonIdentified, ...Show All

• Batikit Visual C++ 2005 (C++/CLI) - Newbie with ADO

  Hi, I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database. For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine... When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratc ...Show All

• Jon Braganza Read SQL Profiler Trace output

  Hi Folks, I want to Read the SQL Profiler Trace Output using VB or VB.NET I read some forums. They advice to import SMO in VB.NET.. But how can i Import this.... This is very Urgent for me.... Please Reply me immediately... First thing you need to do is set up your trace to go into a file. (Sending the trace data directly into SQL Server is very bad for performance.) Once you've got the trace file you can do something like this (which is right out of Books Online - see that document for more details.) USE AdventureWorks; GO SELECT * INTO temp_trc FROM fn_trace_gettable('c:\temp\my_trace.trc', default); GO Thanks for help me... Thanks for Reply... Please can u give me a sample code for this.... Please this is very ...Show All

• ash141vsp2003 Microsoft ReportViewer and AJAX .Net2

  Hello, I'm currently having some problems with the reportviewer embedded in AJAX Panel. I've got 6 ReportViewerControl in a page, each embedded in AJAX Panel. When I refresh the first time one of these ReportViewer, it works fine. The second time it gaves me the Exception : ArgumentOutOfRangeException. When i just have one ReportViewer control on my page, all work. Can someone help me please Sincerely yours, Alexandre Equoy ...Show All

• GR101 analysis services service doesn't start

  Hi, well, you all know that story... "Suddenly, without changing anything, ...". Now it happened to me... Suddenly, without changing anything, my Analysis Services service doesn't start anymore. I the event log I see that it starts and it ends. When I try to start it from SQL Server Management studio it says that it started and stopped again. It's configured to use the local system account. I tried to run the service from a command line but it just quits without any message. Any idea what I can do Thanks, …fixed… There was a change… I started with Microsoft e-Learning trainings and got some XML problems with the viewer they use… They gave me some instructions to fix that (which didn’t help) but that seams to ...Show All