Search results for query: *

Thanks. Your reply made me realize I was sending the spaces from my stored procedure in a char column. It's been a long week. Andrea

Is there a way to create a file with different record lengths in VB .NET? I need to create a file that has a header record with a length of 88, any number of detail records with a length of 396 each, and a trailer record with a length of 91. There should not be any spaces after the final...

You can create linked reports, which I usually find preferable to copying. If you create linked reports, you only have to update the original to get updates to all of the linked reports. If you copy them, you would have to update each copy. To link reports in Report Manager, go to the...

I'm not sure. I have never used a multi-choice parameter, but it looks like it creates an array of parameter values. You can probably use custom code to format that array like you want. I don't know if there is an easier way. Andrea

You can reference the parameters directly in the page header; you don't have to put them in a hidden textbox in the report first. Andrea

You can create a linked report for each one. I'm not sure if there is a way to copy an entire folder. You might want to look at Linked Report Generator; it's free and seems to make linking reports a little faster and easier. You can get it at http://www.sqldbatips.com/showarticle.asp?ID=73...

It is possible the form you are loading on startup has an error and cannot load. Look at the application log in event viewer and see if you have any errors. Andrea

You can set a default for one or all of the parameters in Report Parameters. Andrea

Try this; it usually does a pretty good job. http://www.developerfusion.com/tools/convert/csharp-to-vb/ Andrea

I've come up with somewhat of a solution. I added a field to my underlying table and stored procedure to store the sub-row and added a group for the sub-row in the matrix. Then, I added an expression to the Top Border Style. =IIf(Fields!sub_row.Value = 1, "Solid", "None") I did have to move...

I'm trying to add a border to the bottom of each row group, but I can't figure out how. My row group may have up to three lines of data, but I only want the border on the bottom of the last line of the group. When I select the matrix row and add a border, it applies it to every row. Is there...

I normally see that error when the client does not have full trust to the network location. Andrea

Is the project located on your computer or on a different computer on the network? Can you successfully connect to your database anywhere else in your project? Andrea

This is code I use to export to a PDF file. You will need to replace "reportserver" with your report server name. This report has four parameters; you may not need those. I'm not sure about the rest of your questions; I will have to think about those. Dim rs As New...

Did you create your dataset with the wizard or in code? I rarely use the wizard, but if you created it that way, the dataset designer will show the types of each of the datacolumns. If you don't have a strongly typed dataset, you shouldn't be getting that error until you update the database.

Did you check the data type on the DataColumn where the DataSet is defined and make sure it is also varchar?

Remove New before DataRow, and try this for the other line. adjSwipeAccumulativeHoursRow("EmpNum") = Me.cboEmployee.Text

What errors are you getting and on which lines?

Yes, you have to use @Year, but you already have it in @StartDate and @EndDate.

You need to remove "month" from the @StartDate and @EndDate, and you need to move the statements where you are setting the @Qtr and @Year right after your DECLARE statements, before you use them.