Developer Barn

Issues in GetItemDataSources web service call in 2008 Report Server R2

singhalkul — Mon, 06 Sep 2010 09:43:50 GMT

Hi,

I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data source names returned are different from the names of the actual data sources on the report server.

The report has the following data sources:

1. 0
2. 1
3. _0
4. _A
5. Data Source

And the names returned by the GetItemDataSources for 2008 report server R2 is:

1. AutoGen_0
2. AutoGen_1
3. AutoGen__0
4. AutoGen__A
5. Data_Source

When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition.

To summarize, only numeric data source names are changed to "Autogen_"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_"(eg. AutoGen__A) and spaces are replaced by an "_".

What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names?

Thanks,
Kulbhushan Singhal.

Windows Forms - C# using c#.net forms to replace microsoft access forms

arloguth — Sun, 05 Sep 2010 12:53:29 GMT

Hello,
am looking for advice first - before I ask specific questions
I have attached a simple example time worked database I have.
What is mainly different than most time forms - is that I have two tables in microsoft access database. the form lets user enter data during the week and as long as user does not click submit button- the data is still there. the form is bound to table1.

But when user clicks submit button- all data is transferred to table2-( and data is then cleared out of table1).
my report for each user is based on their table2.
I am learning slowly C#.net. ( at work some computers not on network and only have .net 2.0 version)- i want to know if a C# form could replicate what the microsoft access form is doing here.
one reason am doing it- may be just a lesson for myself in C#- but I wonder first can C# form do it and In my actual database- I have a separate forms for each user- Can C# have multiple forms for a function like this.
thank you

Attached Files

exampleDatabase1.zip (24.8 KB)

how to enter serial number and lookup serial number at same time

arloguth — Fri, 03 Sep 2010 21:49:46 GMT

I have a form to enter serial number and service tag number. user uses scanner to enter data into form. I also have a form with a lookup box to search if serial number is in a table for trashed parts. so i have two tbl1 and tbl2.
now i am being asked to speed up operation-
is there a way to enter serial number one time and do both functions.

if serial number is in tbl2 then print report and still enter number in tbl1
if serial number is not in tbl2 - show message box "part not found" and just enter number in tbl1 ( no report)

or is there another way
thank you

What's Wrong with ASP.NET Web Forms?

jmurrayhead — Fri, 03 Sep 2010 13:49:01 GMT

You can view the page at http://www.developerbarn.com/content....NET-Web-Forms

Auto tab movement

micky — Fri, 03 Sep 2010 08:03:53 GMT

Hey guys
Sorry for the awkward title.

I have a .aspx page on which i have 3 text boxes for phone number
1st and 2nd text boxes have length 3 and the third one has length 4.

Now my client wants that when he enters 3 numbers in 1st text box, he dont need to press "tab" and the cursor automatically goes to the 2nd text box and then to the 3rd textbox.

Is that possible?

Thanx

Our New Site

jmurrayhead — Fri, 03 Sep 2010 01:44:46 GMT

You can view the page at http://www.developerbarn.com/content...2-Our-New-Site

Populate specific data field in a row in Access table based on Primary Key

chrisjack001 — Thu, 02 Sep 2010 21:59:51 GMT

I have this Form Called "Invoices" that I will input a "InvoiceID" number from a drop down combo and enter. This will populate the form. I will then click a print button that will trigger this code. What it does is it will update the Duedate field in the Invoices table if the field is blank with (Current date + 30) before opening the "Invoices" report in printview to print that specific report. What Im having problem with is the code goes through the whole "Invoices" table and updates any DueDate field that is blank which it should not be doing. It should just update that specific row with that InvoiceID that you input in the beginning which is the primary key. The code I have now is this and everything works except it updates all Duedate fields that are blank.
Private Sub PrintInvoice_Click()
DoCmd.OpenQuery "SubtotalUpdate"
DoCmd.OpenQuery "InvoiceTotalAppend"
DoCmd.RunSQL "update Invoices set DueDate=date()+30 where duedate is null"
DoCmd.OpenReport "Invoices", acViewPreview, , "[Invoices.InvoiceID] = [Forms]![Invoices]![InvoiceID]", acWindowNormal
End Sub

Please help and thanks

Populate Date field (CurrentDate + 30) in table if blank

chrisjack001 — Thu, 02 Sep 2010 16:26:39 GMT

I have a "Print" button on a Form called "Invoices" that that has embedded macros on the click event I want to replace with VB code due to the limitation in Macro. Currently this Macro does the following

1. Opens and runs a query called "SubtotalUpdate"
2. Opens and runs a query called "InvoiceTotalAppend"
3. Opens and populates a Report called "Invoices" with the DueDate from "Invoices" table before printing.
This is what I want to add to the existing macro all converted to VB code
4. If the DueDate field is blank in the "Invoices" table I want the date saved in that blank field in the table as (Current date + 30 days) before executing option 3. The format of the date should be mm/dd/yyyy. Can I replace this macro with a VB code. Can you please help with the code on Click event. Thanks

Visual Studio 2010

jmurrayhead — Thu, 02 Sep 2010 12:10:47 GMT

So I got my hands on Visual Studio 2010 Premium...this is probably the most impressive version of Visual Studio I have seen. All sorts of features and the best part is...its speed. When I open it, it's instantaneous, unlike previous versions. When I click on a menu item, it opens right away. I'll post more about it when I actually get deeply into using it...but so far, I'm really loving it. :thumbs:

TCP/IP listener in ASP .NET

jcexited — Thu, 02 Sep 2010 09:09:48 GMT

I'm trying to develop a web application for a system consisting of several hardware devices, which will connect to a specific IP and port of a server to send some measuring data (plain text). This data will be stored in a SQL Server database in the server. Then, the users will connect to this server using a browser to view the stored data.

I will use ASP .NET (C#) for developing the web application for the users to access the stored data in the database (it's a standard web application with database access to retrieve and show information).

I don't know what is the best way to develop the application that will act as a TCP/IP listener to receive the hardware devices data, since it must run on the same server that stores the SQL Server database.

Could someone give me some advice or suggestion about how to develop the server listener application? I think a web service is not a good solution, because the client (hardware device) won't be able to use this technology (it will send a fixed data buffer after its connection request has been accepted).

Thanks in advance.

Crystel reports to ssrs reports

Naveenkumaryalavarthi — Wed, 01 Sep 2010 18:36:30 GMT

Hi,

I need a documentation which helps me to convert crystel reports to ssrs.

if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project.
naveenjustlikethat@gmail.com

Aggregates

Flam — Tue, 31 Aug 2010 19:42:03 GMT

Ok, I know I'm going to feel really silly when someone answers this because it should be very basic, but I'm at a loss at this point on how to select a record based on a min/max value. I realize I can use a Having clause, but it doesn't produce what I want.

Take the following data:

Create Table Customer (CustomerId int primary key, DateofBirth int);
Insert Into Customer (CustomerId, DateOfBirth)
Values (1, 19010801);
Insert Into Customer (CustomerId, DateOfBirth)
Values (2, 19100101);
Insert Into Customer (CustomerId, DateOfBirth)
Values (3, 19201201);

Select * from Customer

Results:
CustomerId DateOfBirth
1 19010801
2 19100101
3 19201201

Ok, so if I want to know the customerid of the person with the min or max date of birth, how would I go about it?

I can write:

Select customerid, Min(dateofbirth), Max(dateofbirth)
From Customer
Group by customerid

but it just yields all records grouped by customerid. What if I wanted to see just the customerid and the dateofbirth of the min or max?

Thanks!

Where are the 2005 SSIS packages?

grnzbra — Tue, 31 Aug 2010 16:31:37 GMT

I have been told "Here is a 2005 database and SSIS package XYZ has two errors in it. Fix them." I can't find them. I've gone to the Integration Services Engine, but the folders there are all empty (except for other empty folders)

I also ran a search on XYZ.dtsx and found it (along with all the other .dtsx files) in someone's folder inside of a zipped folder. BMS can't brows beyond the zipped folder, so I coppied all the .dtsx files to my folder and then told BMS to open that file. It seems to have various errors, so I assume that I am not doing this correctly (I have no trouble creating my own packages). Also, since this is supposed to be a duplicate of a database with packages being run every night, it seems that there should be working SSIS packages SOMEWHERE. Where do these thing normally hide? (All of the tutorials I've gone through had me set up a special folder for packages I created)

Report Design & Data

PhloooooIsFlo — Tue, 31 Aug 2010 10:26:33 GMT

Hi all, I think it will be sound so dumb, but I don't have any idea what should I do to show some data from SSRS.

Well, let's say I wanted to build a report like this :

PAGE 1

Name : Dumbo
Address : Bali
NPWP Code : 123456

NO|ITEM|QTY
1__ABC__5
2__CDE__10

Total 15

PAGE 2

Name : Sillio
Address : Jakarta
NPWP Code : 654321

NO|ITEM|QTY
1__CCC__10
2__DDD__50

Total 60

PS :
I'm using 1 Store Procedure.
The parameter is using DocNoFrom Between DocNoTo (2param)

The problem is :
The report I already designed is using textbox to show each data. But everytime I want to show next record, they won't show up.
Then I re-build the report using table (only 1 table with 1 SP) but the result is still a mess.

So, any idea how to make this report nicely done?
Do I have to put that name into a header? coz everytime I put textbox into a header, the next record also not showing up.

Thank you in advance

Username Question

Flam — Sun, 29 Aug 2010 21:25:30 GMT

I've been slightly perplexed at the results of the following query depending on where I'm running it from:

SELECT spid, nt_username
FROM sys.sysprocesses
where spid=@@spid

(I realize I can run SUSER_Name() as well as a variety of other username functions, this is just an example)

Anyway, I have 2 different modules for an application. Both of them run on the same database, just out of different ports on the server. They run from SQL Server 2005. Both modules have their own built-in query executors (limited functionality; select statements only).

The thing that confuses me is that if I run the aforementioned query, one module always returns the nt_username value=the local machine username
while the other module returns tthe nt_username=the admin security group in SQL Server.

So for example, the results from module 1 of the above query might be:

SPID nt_username
55 FLAM

while the results of module 2 might be:

SPID nt_username
62 T_Admin

I'm not sure if this is something on the application or something I can change in SQL Server.

Anyone have any ideas?

Thanks much!