Showing posts with label sheet. Show all posts
Showing posts with label sheet. Show all posts

Thursday, March 22, 2012

Barcode doesn't print from reports server

Hi there,

Ok, so I have a report that is generating product labels on a standard mailing lable sheet (30 of them on a 8.5X11 sheet of stock). The whole process works just fine even the printing of the bar codes when I am printing the lables from VS2005's Preview function. However, when I moved the report to our reports server and run the same report, the barcodes don't print out. I have checked, and the barcode font has been installed on the server.

Any suggestions would be greatly appreciated. Thanks! - Eric-

Can you tell me how you got the labels to print correctly.

I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels.

Thanks

Crystal

|||Crystal, Where are you in the process? Have you gotten the data to print in three columns? Let me know and I will try to dial you in. :-)|||

I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column.

My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help!

|||

Hi,

I am trying to display the barcode on a webfor for a tracking number, How do I display it.

I am new to asp.net, but i have to get this done.

Thank you,

|||

I have tried using barcode fonts without much success.

However I did find a product which works very well and I highly recommend it.

THe only caveat to using this product is if you upgrade it you need to go back and upgrade all your other reports that use the older version.

the product is neodynamic barcode professional 3.0 for reporting services.|||

is there any method which I can use to convert a dll designed for windows forms, to web forms.

this is a free dll supplied by ID automation.

Barcode doesn't print from reports server

Hi there,

Ok, so I have a report that is generating product labels on a standard mailing lable sheet (30 of them on a 8.5X11 sheet of stock). The whole process works just fine even the printing of the bar codes when I am printing the lables from VS2005's Preview function. However, when I moved the report to our reports server and run the same report, the barcodes don't print out. I have checked, and the barcode font has been installed on the server.

Any suggestions would be greatly appreciated. Thanks! - Eric-

Can you tell me how you got the labels to print correctly.

I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels.

Thanks

Crystal

|||Crystal, Where are you in the process? Have you gotten the data to print in three columns? Let me know and I will try to dial you in. :-)|||

I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column.

My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help!

|||

Hi,

I am trying to display the barcode on a webfor for a tracking number, How do I display it.

I am new to asp.net, but i have to get this done.

Thank you,

|||

I have tried using barcode fonts without much success.

However I did find a product which works very well and I highly recommend it.

THe only caveat to using this product is if you upgrade it you need to go back and upgrade all your other reports that use the older version.

the product is neodynamic barcode professional 3.0 for reporting services.|||

is there any method which I can use to convert a dll designed for windows forms, to web forms.

this is a free dll supplied by ID automation.

Barcode doesn't print from reports server

Hi there,

Ok, so I have a report that is generating product labels on a standard mailing lable sheet (30 of them on a 8.5X11 sheet of stock). The whole process works just fine even the printing of the bar codes when I am printing the lables from VS2005's Preview function. However, when I moved the report to our reports server and run the same report, the barcodes don't print out. I have checked, and the barcode font has been installed on the server.

Any suggestions would be greatly appreciated. Thanks! - Eric-

Can you tell me how you got the labels to print correctly.

I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels.

Thanks

Crystal

|||Crystal, Where are you in the process? Have you gotten the data to print in three columns? Let me know and I will try to dial you in. :-)|||

I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column.

My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help!

|||

Hi,

I am trying to display the barcode on a webfor for a tracking number, How do I display it.

I am new to asp.net, but i have to get this done.

Thank you,

|||

I have tried using barcode fonts without much success.

However I did find a product which works very well and I highly recommend it.

THe only caveat to using this product is if you upgrade it you need to go back and upgrade all your other reports that use the older version.

the product is neodynamic barcode professional 3.0 for reporting services.|||

is there any method which I can use to convert a dll designed for windows forms, to web forms.

this is a free dll supplied by ID automation.

Tuesday, March 20, 2012

Balance Forwarding

Hi,

Just want to seek advice on how to forward the ending balance of Balance Sheet Accounts of previous year to the current year.

Marvs

You can use a couple of MDX function depending on the level you are standed.

If we have the following time heriarchie:

[DimTime].[Year-Month-Day-H] = [Year], [Month], [Day]

And assuming that the [Balance] measure is additive

1) if you drill down to the day level you can obtain the ending balance of the previous year thorugh the following MDX sentence:

(ParallelPeriod([Year],1,[Dim Time].Currentmember).Parent.Lastsibling.Lastchild, measure.[Balance])

2) If you drill down to the month level you can obtain the ending balance of the previous year like this:

(ParallelPeriod([Year],1,[Dim Time].Currentmember).Lastsibling.Lastchild, measure.[Balance])

3) If you are on the year level you can obtain the ending balance of the previous year like this:

([Dim Time].currentmember.Lag(1).Lastchild.Lastchild, measure.[Balance])

And finally you can put the three sentences in two nested iif function, like this:

Iif([DimTime].currentmember.Level.Name = "Day", <Sentence 1>,

Iif([DimTime].currentmember.Level.Name = "Month", <Sentence 2>,

<Sentence 3>))

Other ways using custom rollup formulas can be used.

Hope that helps you

Leandro

|||

What I think you are looking for is the new semi-additive measures in AS2K5, specifically the "last non-empty child" aggregation function. It is designed for balances, quantities on-hand, and a whole class of semi-additive situatons. While this is technically possible on AS2K, it involves a considerable amount of calculations and MDX to evaluate it at runtime. In AS2K5, it is a native aggregation function and performs at the same speed as sum, count, etc.

_-_-_ Dave

|||

That' right.

So the following more simple sentence could be used:

(parallelperiod([Year],1,[DimTime].currentmember), measures.[Balance])

Thanks