bugs in subreport

I have a table contain a sub report . when I run on preview (visual studio), no problem . but when I run from my application , the report viewer just show "Report been generated" , never show the report .

after try and error I discover that when the query from main report return no records , plus the table contain a sub report , the problem occur only if you run it from your application using report viewer . not from visual studio . is this a bugs? anyway to resolve this or work around?

thks

a couple of things..

on your main report, you should probobaly set up a static dataset that always returns data... some like select from table where 1=1 or something like that. You can hide that information.

Secondly, besure to set up a description in the no rows property of the main and sub reports.

Bug?

I have a .rdl file which I opened in visual studio 2005. I answered Yes to the prompt Microsoft Report Designer. . . Do you want to convert this file? [Yes] Then I saved the file.

The issue is when I am in Visual Studio and click on the Preview tab, I get the following error:

[rsErrorLoadingCodeModule] Error while loading code module: ‘x.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'AdvancedMD.Report.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

There was a <CodeModule> which existed prior to the conversion and the preview worked fine.

I tried to re-add the reference by clicking on the Layout tab then go to the report properties tab. Then, under references I clicked on the collection and browsed to the file which I wanted to reference and clicked ok, but I still get the error above when I click on the Preview tab. I tried to remove the reference save then come back in and add it again, but it still gives the error above.

The file I am trying to add to <CodeModule> (x.ReportDefinitionsHelper) references the following:

System

System.Data

System.Xml

Any help would be greatly appreciated.

Thanks

(I can load the .rdl to reporting services 2005 and go into Reporting Services Manager and view the report without any issues.)

I just had to move the file I was referenceing to the following location:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

|||This solved the problem for me too. I have part of the VS2005 installed on my D: drive instead of the C: drive. But regardless of this I think it is strange that we have to put our own dll's in the MS directories. I would like to have them in my own project files. I think it is a bug since the VS2005 has a project structure, and it seems this does not fit in.|||

I had the same problem and however I have installed VS2005 in C: so that isn't the problem... the solution for me, as for TMK and Jelle, has been to put my dll in:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

What i would like to know is the reason because of we have to put our dlls in that directory if in our references we specified another directory...

Can anyone explain it to us?

Bug?

I have a .rdl file which I opened in visual studio 2005. I answered Yes to the prompt Microsoft Report Designer. . . Do you want to convert this file? [Yes] Then I saved the file.

The issue is when I am in Visual Studio and click on the Preview tab, I get the following error:

[rsErrorLoadingCodeModule] Error while loading code module: ‘x.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'AdvancedMD.Report.ReportDefinitionsHelper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

There was a <CodeModule> which existed prior to the conversion and the preview worked fine.

I tried to re-add the reference by clicking on the Layout tab then go to the report properties tab. Then, under references I clicked on the collection and browsed to the file which I wanted to reference and clicked ok, but I still get the error above when I click on the Preview tab. I tried to remove the reference save then come back in and add it again, but it still gives the error above.

The file I am trying to add to <CodeModule> (x.ReportDefinitionsHelper) references the following:

System

System.Data

System.Xml

Any help would be greatly appreciated.

Thanks

(I can load the .rdl to reporting services 2005 and go into Reporting Services Manager and view the report without any issues.)

I just had to move the file I was referenceing to the following location:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

|||This solved the problem for me too. I have part of the VS2005 installed on my D: drive instead of the C: drive. But regardless of this I think it is strange that we have to put our own dll's in the MS directories. I would like to have them in my own project files. I think it is a bug since the VS2005 has a project structure, and it seems this does not fit in.|||

I had the same problem and however I have installed VS2005 in C: so that isn't the problem... the solution for me, as for TMK and Jelle, has been to put my dll in:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

What i would like to know is the reason because of we have to put our dlls in that directory if in our references we specified another directory...

Can anyone explain it to us?

Bug or Feature?

When upgrading a database from MSDE to Visual Studio 2005 Express, I've noticed that the system tables in the MSDB database don't get upgraded. For example, the SYSSCHEDULES table doesn't get added. Is this by design or a bug?

-Doug

Belatedly moving this thread to the Express forum for an answer.|||

Given that there is no SQL Agent support in Express this may well be by design

|||

Hi Doug,

This has been addressed in SP1, which you can get from http://msdn.microsoft.com/vstudio/express/sql/download.

Regards,

Mike Wachal
SQL Express team

Mark the best posts as Answers!

|||I did find a fix to this problem. If I run the INSTMSDB.SQL script from the install directory on the updgraded database, it will install all of the new MSDB system tables.

BUG in Microsoft Learning Resources VB Express Lesson 9 (Database Fails to Update).

I recently downloaded Visual Studio 2005 Express along with the Learning Resources for Visual Basic Express video. First let me say that the Learning Resources is an excellent resource for beginners to become familiar with Visual Studio, Database and programming concepts. Although the series is probably too basic for experienced developers you may find it reveals a number of tricks in the Visual Studio 2005 interface.

http://msdn.microsoft.com/vstudio/express/vb/default.aspx

Problem

I downloaded the VB Lesson 9 Visual Basic Project from Microsoft Learning Resources. With out making any changes to the project I compiled and ran it, making changes to the data and saving the changes. Every thing look great until you run it a second time and see that the changes to the data are all lost.

Observations:

1. Changes made to the data from within Visual Studio (Show Table Data) do take effect.

2. The in-memory data (DataSet) is changed as you move from row to row.

3. The TableAdapter.Update call returns 1, ostensibly indicating the number of rows updated.

4. The data in the database is not changed by the TableAdapter.Update call.

Operating System: Windows XP Pro Service Pack 2

Other Software installed on this system

20SQL Server 2005 Express

Visual Web Developer 2005 Express

Visual Studio 6.0 Enterprise

Visual Studio .net Enterprise

Microsoft .NET Framework SDK

Microsoft Office 2003

If anyone can help me understand the cause of this problem I would greatly appreciate it.

Thanks

Bob

Allow Nulls is a problem for Edit - Update

I have found the if you leave the Allow Nulls for any fields the Update will not work.

If any knows of a way to leave the Allow Nulls on some fields and have the Update work please let me know.

Thanks

Bob

browsing cube

Hi

I have created a cube. I want to show it to the clients that do not have the Business Intellegence development studio or visual studio installed. Is there any other method of browsing a deployed cube?

Thanks in advance.

-padu

Probably the most widely available client is Excel.

Mosha has one of the best lists of SSAS clients on his wesite http://www.mosha.com/msolap/util.htm

|||Excel is a good choice. Also, you can generate a local cube file based on your data and let Excel connect directly to it. This way you can show the cube and data to the clients on a machine that doesn't run (and has no network connection to) the AS server.|||

Thanks guys,

This was really helpful.

-padu.

British date conversation

I am new to VB and have a problem with returning a recordset from a sql string.

I am using visual studio 2005 and SQL server 2005.

I am attempting to return a recordset with the from a table using two date parameters which are held in another table both tables are on the same server. Both tables store their date values in the British “dd/mm/yyy/ HH:MMS AMPM” format when I attempt to create a ADODB dataset using the following code errors occur. I have attempted various different approaches to resolve this but without success. Can you point me in the right direction?

Regards

Joe

@.@.@.@. CODE @.@.@.@.

‘Sub1

Dim Sdate as string, Edate as string

‘ Both parameters are passed to sub2 from sub1

rstmons.movefirst

Sdate = rstMon.Fields("DateAndTimeofFix").Value

rstmon.movelast

Edate = rstMon.Fields("DateAndTimeofFix").Value

‘Sub2

Dim myCONN As String, MonSql As String

myCONN = ("Driver={SQL Server};Provider=SQLOLEDB;Server=midlaptop2;Database=customerlink;Trusted_Connection=Yes;")

MonSql = "SELECT *" & _

" from tblVsol" & _

"WHERE DateAndTimeofFix Between CONVERT(DATETIME,'" & Sdate & _

"') AND CONVERT(DATETIME,'" & Edate & _

"') and vehicleunit = " & iveh & ";"

use convert with style #103

Select Convert(datetime,'31/1/2007 10:10:00', 103) --Correct

Select Convert(datetime,'31/1/2007 10:10:00') -- Error

MonSql = "SELECT *" & _
" from tblVsol" & _
"WHERE DateAndTimeofFix Between CONVERT(DATETIME,'" & Sdate & _
"',103) AND CONVERT(DATETIME,'" & Edate & _
"',103) and vehicleunit = " & iveh & ";"

|||

Hi

Thanks for your prompt reply.

Thats exactly what I needed.

Many Thanks

Joe

|||

Hi JoeBo,

> Both tables store their date values in the British “dd/mm/yyy/ HH:MMS AMPM” format

Unless you are using a character data type (char / nchar / varchar / nvarchar) to store that data, SQL Server does not store datetime data type using any format. The representation for datatime is a two four bytes, 4 bytes for the date and four bytes for the time. SQL Server interprets datetime constant strings based on the settings of SET LANGUAGE / SET DATEFORMAT, but id you want that SQL Server interpret them correctly no matter of those settings, then use styles 112 or 126 (See function CONVERT in BOL). Also, you should parameterize the "select" statement to re-use cached plans, instead concatenating the values and sending the final statement to SQL Server.

Convert Dynamic SQL to Use SQLCommand Parameters Automatically

http://www.knowdotnet.com/articles/dynamicsqlparameters.html

SqlCommand.Parameters Property

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx

Simple Parameterization

http://msdn2.microsoft.com/en-us/library/ms186219.aspx

The ultimate guide to the datetime datatypes

http://www.karaszi.com/SQLServer/info_datetime.asp

AMB

British date conversation

I am new to VB and have a problem with returning a recordset from a sql string.

I am using visual studio 2005 and SQL server 2005.

I am attempting to return a recordset with the from a table using two date parameters which are held in another table both tables are on the same server. Both tables store their date values in the British “dd/mm/yyy/ HH:MMS AMPM” format when I attempt to create a ADODB dataset using the following code errors occur. I have attempted various different approaches to resolve this but without success. Can you point me in the right direction?

Regards

Joe

@.@.@.@. CODE @.@.@.@.

‘Sub1

Dim Sdate as string, Edate as string

‘ Both parameters are passed to sub2 from sub1

rstmons.movefirst

Sdate = rstMon.Fields("DateAndTimeofFix").Value

rstmon.movelast

Edate = rstMon.Fields("DateAndTimeofFix").Value

‘Sub2

Dim myCONN As String, MonSql As String

myCONN = ("Driver={SQL Server};Provider=SQLOLEDB;Server=midlaptop2;Database=customerlink;Trusted_Connection=Yes;")

MonSql = "SELECT *" & _

" from tblVsol" & _

"WHERE DateAndTimeofFix Between CONVERT(DATETIME,'" & Sdate & _

"') AND CONVERT(DATETIME,'" & Edate & _

"') and vehicleunit = " & iveh & ";"

use convert with style #103

Select Convert(datetime,'31/1/2007 10:10:00', 103) --Correct

Select Convert(datetime,'31/1/2007 10:10:00') -- Error

MonSql = "SELECT *" & _
" from tblVsol" & _
"WHERE DateAndTimeofFix Between CONVERT(DATETIME,'" & Sdate & _
"',103) AND CONVERT(DATETIME,'" & Edate & _
"',103) and vehicleunit = " & iveh & ";"

|||

Hi

Thanks for your prompt reply.

Thats exactly what I needed.

Many Thanks

Joe

|||

Hi JoeBo,

> Both tables store their date values in the British “dd/mm/yyy/ HH:MMS AMPM” format

Unless you are using a character data type (char / nchar / varchar / nvarchar) to store that data, SQL Server does not store datetime data type using any format. The representation for datatime is a two four bytes, 4 bytes for the date and four bytes for the time. SQL Server interprets datetime constant strings based on the settings of SET LANGUAGE / SET DATEFORMAT, but id you want that SQL Server interpret them correctly no matter of those settings, then use styles 112 or 126 (See function CONVERT in BOL). Also, you should parameterize the "select" statement to re-use cached plans, instead concatenating the values and sending the final statement to SQL Server.

Convert Dynamic SQL to Use SQLCommand Parameters Automatically

http://www.knowdotnet.com/articles/dynamicsqlparameters.html

SqlCommand.Parameters Property

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx

Simple Parameterization

http://msdn2.microsoft.com/en-us/library/ms186219.aspx

The ultimate guide to the datetime datatypes

http://www.karaszi.com/SQLServer/info_datetime.asp

AMB

British date conversation

I am new to VB and have a problem with returning a recordset from a sql string.

I am using visual studio 2005 and SQL server 2005.

I am attempting to return a recordset with the from a table using two date parameters which are held in another table both tables are on the same server. Both tables store their date values in the British “dd/mm/yyy/ HH:MMS AMPM” format when I attempt to create a ADODB dataset using the following code errors occur. I have attempted various different approaches to resolve this but without success. Can you point me in the right direction?

Regards

Joe

@.@.@.@. CODE @.@.@.@.

‘Sub1

Dim Sdate as string, Edate as string

‘ Both parameters are passed to sub2 from sub1

rstmons.movefirst

Sdate = rstMon.Fields("DateAndTimeofFix").Value

rstmon.movelast

Edate = rstMon.Fields("DateAndTimeofFix").Value

‘Sub2

Dim myCONN As String, MonSql As String

myCONN = ("Driver={SQL Server};Provider=SQLOLEDB;Server=midlaptop2;Database=customerlink;Trusted_Connection=Yes;")

MonSql = "SELECT *" & _

" from tblVsol" & _

"WHERE DateAndTimeofFix Between CONVERT(DATETIME,'" & Sdate & _

"') AND CONVERT(DATETIME,'" & Edate & _

"') and vehicleunit = " & iveh & ";"

use convert with style #103

Select Convert(datetime,'31/1/2007 10:10:00', 103) --Correct

Select Convert(datetime,'31/1/2007 10:10:00') -- Error

MonSql = "SELECT *" & _
" from tblVsol" & _
"WHERE DateAndTimeofFix Between CONVERT(DATETIME,'" & Sdate & _
"',103) AND CONVERT(DATETIME,'" & Edate & _
"',103) and vehicleunit = " & iveh & ";"

|||

Hi

Thanks for your prompt reply.

Thats exactly what I needed.

Many Thanks

Joe

|||

Hi JoeBo,

> Both tables store their date values in the British “dd/mm/yyy/ HH:MMS AMPM” format

Unless you are using a character data type (char / nchar / varchar / nvarchar) to store that data, SQL Server does not store datetime data type using any format. The representation for datatime is a two four bytes, 4 bytes for the date and four bytes for the time. SQL Server interprets datetime constant strings based on the settings of SET LANGUAGE / SET DATEFORMAT, but id you want that SQL Server interpret them correctly no matter of those settings, then use styles 112 or 126 (See function CONVERT in BOL). Also, you should parameterize the "select" statement to re-use cached plans, instead concatenating the values and sending the final statement to SQL Server.

Convert Dynamic SQL to Use SQLCommand Parameters Automatically

http://www.knowdotnet.com/articles/dynamicsqlparameters.html

SqlCommand.Parameters Property

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx

Simple Parameterization

http://msdn2.microsoft.com/en-us/library/ms186219.aspx

The ultimate guide to the datetime datatypes

http://www.karaszi.com/SQLServer/info_datetime.asp

AMB

Bound control timing issues in Visual Basic

It is just me or...
I have two appications in very different environments that have
suddenly shown very similar behavior, after a fashion.
One application is simple desktop. I've been working on the development
off and on for a number of months. It uses controls bound to an Access
database. As a for instance, I have two list boxes where items are
copied from left to right and deleted from the left, a fairly standard
practice. After the delete from the left, the repaint should eliminate
the deleted item, which worked fine until just recently.
The client became very upset when the the control repainted with the
deleted item still displayed. And this was also happening with two grid
controls. It was making me quite nuts. I dug around until I found a
reference to 'sleep' and implemented it. The problem was resolved.
Therefore, the cursor in memory was not being overwritten in time to
keep up with the repaint.
I also have an application in a Citirx/Softricity environment that is
working just fine on several servers (it produces reports using the VB6
data report designer) but is failing on one. I have not yet seen the
results, but I've added the same 'Sleep' methodology to this
application. My current working assumption is that the application
(data report dll) does not have enough time to locate the remote
network printer in time to produce a display when requested by the
application. It's just a working assumption.
What I'm wondering is whether or not anyone else out there in VB land
particularly VB6 land has recently encountered any timing related
errors. I want to document this, if I'm not the only one encountering
the issues.
I'm bringing this up because of something I read around the time of the
emergency patch related to the possibility of viruses or trojans being
embbedded in graphic files. It suggested that the underlayment
(operating environment) was being adversly affected, that is it was
significantly slower to respond to certain requests, as a result of the
patch.
Thanks for your attention...Hello,
If you are using an Access database and you do not have a single
connection for the entire application, you may be running into this
issue:
http://support.microsoft.com/kb/q200300
Razvan